Answer Posted / rajeev
NAMED PL/SQL BLOCK STORED IN ORCALE SERVER , CAN ACCEPT
PARAMETERS AND CAN BE INVOKED REPEATDLY BY NAME .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is synonyms?
What is identity column in sql server?
what is a trigger? : Sql dba
Is it possible for a table to have more than one foreign key?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What do you mean by “trigger” in sql?
How many disk partitions should I have?
What is the difference between subquery and correlated query?
What is audit logout in sql profiler?
Determine if oracle date is on a weekend?
What is data modelling in sql?
What is the difference between a procedure and a function?
Do ddl statements need commit?
How is data stored in sql?
What is primary key sql?