How to empty your oracle recycle bin?
No Answer is Posted For this Question
Be the First to Post Answer
What is the usage of analyze command in oracle?
What would you do if a database crashes in production?
What is varray?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How to use "if" statements on multiple conditions?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
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.
How to create a server parameter file?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
What is a nested table?
What happens if the imported table already exists?