Two triggers one is before insert and other is after insert
are firing on a table.If 10 times you insert in a table.Then
how many times before trigger and how many types after trigger
will fire in pl/sql.
State some uses of redo log files?
What do you mean by cdb and pdb in oracle 12c?
How would you extract DDL of a table without using a GUI tool?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to create a testing table in oracle?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
how many columns can a plsql table have
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
How to omit columns with default values in insert statement in oracle?
What is a Redo Log ?
query to find the maximum no persons with same age(age colomn) from emp table
What is meant by recursive hints in oracle?