When using a count(distinct) is it better to use a self-join or temp table to find redundant data, and provide an example?
Latest Answer: Application trigger: Fires whenever an event occurs with a particular application Database trigger: Fires whenever a data event (such as DML) or system event (such as logon or shutdown) occurs on a schema or database ...
Latest Answer: UTL_FILEThe Oracle supplied package UTL_FILE can be used to read and write files that are located on the server. It cannot be used to access files locally, that is on the computer where the client is running.Procedures/Functions present in UTL_FILE:fcloseprocedure ...
Latest Answer: A CURSOR normally selects the records given by the query in a separate buffer
area and these fetched records will be referenced or make used in the program by
looping structures like FOR LOOP etc.
A REF CURSOR is used as a reference type. for Ex:- ...
What is the difference between private packages and public package . what is the difference in declaration of these 2 packages.
Latest Answer: To add primary key or unique key constraint Alter table tablename add constraint constraintname primary key / unique (column name)To add check constraint Alter table tablename add constraint constraintname check (codition)To add ...
Latest Answer: Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, ...
Why we use instead of trigger. what is the basic structure of the instead of trigger. Explain specific business reason of it's use
Latest Answer: select a.no from (tablename) t1 a where rowid notin (select (max(rowid) from t1 b where a.no=b.no) ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
