Answers were Sorted based on User's Feedback
Answer / surya
Do we have constraining table in oracle :(
|Is This Answer Correct ?||8 Yes||0 No|
Answer / atul
constraining table is used in trigger
this is table where used foreign key on that table(i.e)
one table depand upon another table
|Is This Answer Correct ?||6 Yes||2 No|
What is difference between % ROWTYPE and TYPE RECORD ?
How do you assign Construct the where clause without concatenating Field,value pairs?
IF i write before / after insert / update trigger and i do rollback what will happen?
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#
How will you select unique values from a list of records?
write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/
Difference between IN and EXISTS
can i write pl/sql code in a package
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
What are nested triggers ?
if a table is getting updated what happens if a function is called from sql query?