|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 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 : The main differences between a primary key and a unique key is that a primary key (although unique) cannot contain NULL values, whereas a Unique Key can. ... Read Answers (18) | 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 : there are mainily 3 types of triggers1> dml trigger2>instead of trigger written on only view3>system triggerdml trigger written on table that gets fired on dml events like insert or delete or update operationthat trigger may ... Read Answers (5) | 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
