Reputation
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
9 51 121
Newest
 Yearling
Impact
~2.2m people reached

Feb
1
comment What exactly is a database engine?
@nealmcb The bold question also has a misconception. Most databases have no distinction between the database engine and the rest of the database. Those that separate the database engine have more than CRUD in the engine. The question cannot be answered directly because it has a false premise.
Jan
19
answered Should I have a column for every data type or 1 column that stores everything
Jan
7
answered Pass (comma separated) -yet single parameter to cursor
Jan
7
answered Oracle : Redo / Undo for nologging table + Append + archivelog
Jan
4
answered Switching values in a column with one update statement
Jan
4
awarded  Yearling
Dec
21
answered fastest way to generate permutations of a table with n columns and put in a new table added one more question to same how to remove duplicate rows
Dec
21
awarded  Necromancer
Dec
18
revised In Oracle SQL Developer, how do I create or update a procedure and have the schema name be a variable:
added 6 characters in body
Dec
17
answered How to get return value from pl sql procedure and assign it to variable?
Dec
17
reviewed Leave Open How to design mongodb collection?
Dec
17
revised Inner Joins between Subsets of the Same Table
edited tags
Dec
14
comment Connect by prior - multiple fields and query efficiency
Your query references equip_no, but that is not a column in either table. Is this an alias for equipment.id?
Dec
9
awarded  Good Question
Dec
7
comment Eliminate duplicates in ListAgg (Oracle)
This is an interesting solution and somewhat similar to mine that uses row_number.
Dec
7
awarded  Necromancer
Dec
2
answered Catching Errors in procedure
Dec
2
revised How to tune a SQL query?
added 722 characters in body
Nov
30
answered How to tune a SQL query?
Nov
20
revised How do I Create Tablespace in Oracle 11g?
added 2 characters in body