 Related Questions How can we exit from long running report, ie. if the report is running for more than 15min it must exit automatically,is there any command.Plz help. View Question | Asked by : dominic Latest Answer : SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE/FUNCTION/PACKAGE/PACKAGEBODY'/ ... Read Answers (2) | Asked by : vid How can i sort data in Oracle Forms at runtime after executing the query for specified critirion? i used set_block_property but when click on Sort button it fetches all the data again from the base table.Thanks in advanceTasleem Read Answers (2) | Asked by : Tasleem Truncate command in oracle is DDL command or DML command ? give the answer with descirptive reason which is and why? Latest Answer : Hi taraldesai! Y Not?Here is the example Try thisALTER TABLE table_nameADD (column datatype DEFAULT expr);(or)ALTER TABEL table_nameMODIFY (column datatype DEFAULT expr) ... Latest Answer : SELECT COUNT(cname)FROM COL c, TAB TWHERE T.Tname = c.Tname AND T.Tabtype='TABLE' AND T.Tname ='EMP'; ... Read Answers (2) | Asked by : anil Latest Answer : you can use HOST commend.for examplehost('md c:vijay');it will create vijay directory on c drive. ... Read Answers (1) | Asked by : gajender How to set NLS_DATE_FORMAT for a database permanentlyfor example let's say I want to set : NLS_DATE_FORMAT= 'dd:mon:yyyy hh24:mi:ss' for the database and I am not supposed to give the ALTER What is the command to print the time taken by a query Latest Answer : you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time.. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
