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.. ...
What will happen if you dont use Replace option in a Procedure when first creating it for first time?
Latest Answer: No problm. It successfully creates the procedure.But once it created ,if u modify it and compail without REPLACE ,it will give an error ...
How can we connect Oracle database with our C++ program. Explain with an example.
Latest Answer: hi i fil u can use pro c to connect the data base to the front end data condition: database should b oracle ... ...
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
Can anyone please tell me what are the advanced features in 10g when compared to 9i
Latest Answer: Oracle 10g features are 1) Sys Aux Tablespace 2) ASM3) New Flash Recovery Area 4) CTWR (Change Tracking Writer) This is background process which writes the block change information to the change tracking file. 5) Server Manageability Components6) Unified ...
Latest Answer: If the database is running in archivelog mode then perform time-based recovery to recover the table. ...
Latest Answer: drop user ...
Latest Answer: ALTER SYSTEM SET SHARED_POOL_SIZE=..... ...
I developed like below.Any experts query ....please send.selecttable_name,constraint_namefrom user_cons_columns where column_name=(select a.COLUMN_NAME from user_cons_columns a,user_constraints bwhere
Latest Answer: SELECT uc.CONSTRAINT_NAME, ut.TABLE_NAME, ucc.COLUMN_NAMEFROM USER_CONS_COLUMNS ucc, USER_CONSTRAINTS uc , USER_TABLES utWHERE uc.table_name = ut.TABLE_NAME AND uc.CONSTRAINT_NAME =ucc.CONSTRAINT_NAME ...
Is there any way to import the excel data in to oracle database without using the SQL loader, please let me know.
Latest Answer: Well,if you have less data ,you can just copy the data; for exampleselect * from table for update then open the lock, then copy the data from excel to the database; ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
