-
-
What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
% TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row of a table or view or columns selected in the cursor. The advantages are : I. Need not know about variable's data typeii. If the database definition of a column in a table changes, the...
-
What is the use of nocopy parameter in oracle procedure
Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P
-
-
-
-
What are the components of a PL/SQL block ?
A set of related declarations and procedural statements is called block.
-
How do you set table for read only access ?
if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible
-
-
-
-
-
-
-
How to update a rows with opposite gender in Sql?
In Emp table there is a column which consists of gender (Male or Female) ? How should one
Can update the Values of Male to Female and Female to Male with a single query ? -
-
-
-
-
PL/SQL Interview Questions
Ans