How do I find out the time taken by oracle to execute the sql statement or a procedure? Is it possible by firing a select?
Latest Answer : there are many tips!1) inside a cursor never perform an other sql or call a function performing an sql, join that table better to the cursor body.2) perform bulk operations3) avoid in (subselect) better join this table to the master select4) avoid ...
Latest Answer : SELECT TEXT FROM USER_SOURCE WHERE NAME='PROCEDURE/FUNCTION/PACKAGE/PACKAGEBODY'/ ...
Latest Answer : 1. cold backup2. hot backup3. import/export4. RMANRead oracle manual ...
How do you decide on whether to use a Procedure or a Function for a particular task ?Is it possible to get the last 10 rows of a table? If Yes How?
find it imm...
Latest Answer : For the machine point of view data is stored in binary format.But if we say from database point of view it is stored in unicode format. ...
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 to take a Table Name as Parameter in Procedure?
How to call a procedure in SQL*Loader?
Where is the configuration file is stored in Oracle 9i and 10g