DECODE is a power function, and that was a trick question.
Here are some details on DECODE on this link.
http://www.psoug.org/reference/decode_case.htm l
SQLSilverSurfer
Last Activity: Apr 23 '07, 05:26 PM
Joined: Apr 18 '07
Location: USA
-
I would think that CHANGE might be reserved word somewhere in CASE SQL.
SELECT <myColumnSpec >
CASE
WHEN <A> THEN <somethingA>
WHEN <B> THEN <somethingB>
ELSE <somethingE>
ENDLeave a comment:
-
may not be best answer, but this tool works wonders.
O2XAGENT.EXE --src=db1 --dest=c:\from_ms sql.xls --user=administra tor --pswd=the_passsw ord --tab_file=c:\tab file1.txt --xls_ver=1
http://www.convert-in.com/ora2xls.htm
intelligent converters
** I do not work for them, but have used the product for clients **...Leave a comment:
-
untill I saw that 170m will remain, TRUNC was my first thought. Perhaps a parameter driven delete on a timed sequence trigger. However, the rollback will need to be disabled for this, and not sure about 300M in a LOCK EXCLUSIVE MODE.
I'd like to know the final outcomeLeave a comment:
No activity results to display
Leave a comment: