CTRL ALT DEL on Remote Desktop

If you remote into desktop, and the desktop locks out, CTRL ALT DEL, will only bring your machine's screen.

To send CTRL ATL DEL for Remote pc, use


CTRL ALT END

CTRL ALT DEL on Remote Desktop

If you remote into desktop, and the desktop locks out, CTRL ALT DEL, will only bring your machine's screen.

To send CTRL ATL DEL for Remote pc, use


CTRL ALT END

Regular expression to split comma separated values

with test as
(select '5/10/2007,36352737,,"first_name, last_name Jr.",211001,7204,-75.00' str from dual)
Select regexp_substr(str,'".*"|[^,]+', 1, level)
from test
connect by regexp_substr(str,'".*"|[^,]+', 1, level) is not null

Oracle: Spool to Excel from SQLPlus

Spooling the output from SQLPlus to log file is often in unreadable format.

To Spool SQLPLus output to Excel (.xls) file, the trick is to turn On "MARKUP HTML"

SQL>set markup html on
SQL>set feedback off

SQL>spool c:\test.xls

SQL>select * from user_objects where rownum <= 20;
SQL>spool off

SQL>set markup html off

GPS