Can we set the parameter, so that a particular report gets printed in the particular printer only ?
Latest Answer : Hi Friend,Here is simple defination initSID.ora will tell you SID is the database name where you are going to creating a new database.when you create database it'll take you as pfile and spfile is the system parameter file which you can convert if you ...
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 : 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?
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 determine whether particular parameter of parameter file is static or dynamic?
Latest Answer : In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column
contains three phases 1) Immediate 2) DEFERRED 3) False
1. Immediate : We can change the parameter in fly database ie Dynamic.
2. DEFERRED : We can change the parameter in fly ...
What parameter must be set in init.ora file for utl_file package?
How to take a Table Name as Parameter in Procedure?