|
| 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 : %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 : 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 : hi ,U can use the PRAGMA Function.I.e Autonomous Function to come back to normal stage in Mutating table. ... Read Answers (1) | Asked by : ranjan 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 What would be the o/p for this ....declarecursor c1 is select * from employees;emp_rec c1%rowtype;beginopen c1;delete from employees;loopfetch c1 into emp_rec;exit when c1%notfound;end loop;close c1;end;tell me what is active set ?why you need cursors?and what is going to happen when you use for update clause in cursor declarationwhy use nowait clause what is its use We have on delete cascade in Oracle but we don’t have on update cascade. If you compare Oracle with SQL Server in SQL Server we have the option called on update cascade but In Oracle we don’t have this option why? Please can you just clarify my doubt? Read Answers (1) | Asked by : inam Help me to write a procedure for:verify a table for record if it is exists need to update or else insert that record( using cursor write a procedure ) Read Answers (4) | Asked by : Srinivas If anyone asks in interviews, about "what are the types of triggers" then my ans is likerow level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.and can i even mention instead of triggers,database trigger and schema triggers Read Answers (2) | Asked by : oradev
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
