robarwebservices

less info
104 reputation
18
bio website
location Canada
age
visits member for 2 years, 1 month
seen Nov 5 '13 at 23:51

Feb
14
awarded  Popular Question
Jan
3
awarded  Popular Question
Nov
26
awarded  Notable Question
Sep
26
asked Optimizing UDF - Is Using DUAL Expensive
Aug
15
awarded  Popular Question
Jul
11
asked SQLCMD Exporting 16.5 Million Rows
May
3
asked Exporting 30 million rows to CSV
Apr
5
comment Oracle Alternative to EXISTS EXCEPT
still doesn't work as shown in the previous quesion when I change that keyword... error is sql command not ended properly.
Apr
5
asked Oracle Alternative to EXISTS EXCEPT
Apr
4
awarded  Commentator
Apr
4
comment Convert SQL Server UPDATE Statement for Use in Oracle
That wored perfectly. Going to take some getting used to :)
Apr
4
accepted Convert SQL Server UPDATE Statement for Use in Oracle
Apr
4
comment Convert SQL Server UPDATE Statement for Use in Oracle
Apparently Oracle does not accept this type of update statement SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause: *Action:
Apr
4
asked Convert SQL Server UPDATE Statement for Use in Oracle
Apr
4
comment PL/SQL for Updating 1 Column in Table A Where PK = a row in table B
I agree, but our DBAs wanted to avoid this way to keep the undo logs small...
Apr
3
awarded  Editor
Apr
3
comment PL/SQL for Updating 1 Column in Table A Where PK = a row in table B
@ypercube - information added to the question.
Apr
3
revised PL/SQL for Updating 1 Column in Table A Where PK = a row in table B
added 423 characters in body
Apr
3
asked PL/SQL for Updating 1 Column in Table A Where PK = a row in table B
Feb
20
comment SQL Server Restore a SINGLE table from a backup
I went with this, simple and easy, and no disruption to the production db or the other tables which were not affected.