Reputation
17,761
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
9 53 123
Impact
~2.4m people reached

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
Nov
5
comment How to filter out the records with the latest date?
What database is this? MYSQL?
Nov
2
awarded  Notable Question
Oct
28
awarded  Necromancer
Oct
26
comment Select performance problems with conditional index vs non-conditional on large volume table
What percentage of the table includes rows with an archived value of N?
Oct
23
comment Automate - recover database using backup controfile
It works, very obvious, and exactly what I was looking for.
Oct
22
comment Automate - recover database using backup controfile
OK, I thought AUTOMATIC was the default, but if that works, it would be awesome.
Oct
20
awarded  Nice Answer
Oct
20
revised Automate - recover database using backup controfile
added 471 characters in body
Oct
20
comment Automate - recover database using backup controfile
That doesn't seem to work. Do I have the syntax wrong? SQL> RECOVER DATABASE UNTIL TIME '2015-10-20:13:54:16' USING BACKUP CONTROLFILE CONTINUE DEFAULT; ORA-00274: illegal recovery option CONTINUE SQL> RECOVER DATABASE UNTIL TIME '2015-10-20:13:54:16' CONTINUE DEFAULT USING BACKUP CONTROLFILE; ORA-00274: illegal recovery option CONTINUE