What is the difference between Delete, Truncate and Drop in Oracle?
No Answer is Posted For this Question
Be the First to Post Answer
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
What is clusters ?
What is a static data dictionary in oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is a Data File ?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the factors causing the reparsing of SQL statements in SGA?
Is there any function in oracle similar like group_concat of mysql?
how may join possible between (requisition with purchase order)
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.