 Related Questions Latest Answer : Cursor is a private Sql area which is used to execute sql statements and store Processing information, Where as Refcursor is a data structure which points to an object which inturn points to memmory LocationThe advantage Refcursor over Normal Cursor is1.We ... Latest Answer : SQL is a structured query language.Used to perform operations such as retrieval,updations,insertions etc. on database.PL/SQL is a Programming language which is an extension for SQL with control structures added to them.Number of SQL statements can be ... Latest Answer : %type will use for to define at column level.%rowtype is used to define for one or more than one columns ( like row or record or tuple ) means its user define type which hold one or more than one columns along with it. and generally it used with Cursor. ... Latest Answer : A Unique Key can have null values but a Primary Key can't have null values ... Read Answers (21) | Asked by : Babar Shabbir Latest Answer : Yes we can relate two tables from 2 diff usersE.g. if user A has table Ta and User B has Table Tb and Table Tb is child table and needs foreign key on A.Ta then we need to grant "references" object privillege to User B on table ... Read Answers (1) | Asked by : Shankar Latest Answer : Two types of trigger are there1. Row level trigger2. Statement level trigger ... Read Answers (7) | Asked by : GIRISH H.R. Latest Answer : no difference ... Read Answers (9) | Asked by : Suyog What are the different types of collections supported in Oracle?PL/SQL datatypes TABLE and VARRAY, allow us to declare the collections nested tables, associative arrays, and variable-size arrays. How do i write a function that returnsmore than 1 records from a tablefor example in sql server there is a solution as create function f1() return table asselect * from emphow do i do the same in oracle. plz help Latest Answer : GRANT and REVOKE are DCL commands ... ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
