Latest Answer: Optimizer hints are used to alter execution plan of SQL statement. For ex, certain index can be sometimes more selective for certain queries. Based on the information you can choose a more efficient execution plan by using hint and telling the optimizer ...
How oracle manages dependency between referenced and dependent objects ?
Latest Answer: Oracle manages dependency between referenced and dependent objects by using 2 modes1. Timestamp mode2. Signature mode ...
List at least three common ways to write logs in PL SQL?
Latest Answer: i.feel,using a ref cursor, we can return more than one value to a fucntion ...
Hi,My questions is " Can function return more than one value".I have gone through the all answers relevant to my question was been posted earlier. But all answers are confusing me.Few people
Latest Answer: Hi,First of all I want to make it clear that function must return a value but also can return more than one value at a time.There are two ways to return more than one value from function:-1) you can implement this by passing out parameters in function. ...
Hi,There is problem with ult_file.fopen. When I run from the server side, there is no issue with utl_file and it is working fine.If I run the same procedure from Client machine, I am facing problem. It
Latest Answer: the parameter set in configuration file init.oraand UTL_FILE_DIR belongs to the directory structure in oracle server machine. And the directory structure should be on same machine as oracle server. Thus fopen can run in oracle server machine not client.Thus ...
What is Global temporary table? and what are the benefits of it?
Latest Answer: Global temporary table is kind of temporary table managed by system. it'll keep in temporary tablespace till the session remain. there are two methods available i.e.1) create global temporary table t1 on commit delete rows. with this option, table ...
begin For i in 1..5 loop insert into A values(i); savepoint 1; end loop; rollback to savepoint 1; commitend;--initially there are no data in table A. So my question is after execution of this
Latest Answer: The first mistake in this code is savepoint 1;You can't give 1 as identifier. Identifier name must begin with a letter.insert into A values(i);savepoint x;Here you are defining savepoint after inserting the value. So the final savepoint ...
Give an example for calling procedure with user and system exception
Latest Answer: Simple example for predefined exception CREATE OR REPLACE PROCEDURE TEST_PROC AS A NUMBER ; BEGIN A := 'TEST'; DBMS_OUTPUT.PUT_LINE('THE VALUE OF A = '||A); EXCEPTION WHEN VALUE_ERROR THEN DBMS_OUTPUT.PUT_LINE('The value of A should ...
How will implement the PL/SQL tables?
Latest Answer: - Pl/sql is in memory representation of a table.- It is just a data type. ( Collection type)- It may store any number of rows from table.Here is a simple exampleCREATE OR REPLACE PROCEDURE TEST_PROC ASTYPE EMP_TYPE IS TABLE OF EMP%ROWTYPE;EMP_VAR ...
can we issue rollback, commit in the trigger body. if we issue what is the result
Latest Answer: We can use commit and rollback in trigers using autonomous transactions.- An atonomous transaction is an independent transaction initiated by another transaction.- When an atonomous transaction is called the parent transaction is temporarly suspended.- ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
