How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
1 3123What are the differences between a sys and system user and what are the extra privileges available to the sys user?
1 5728I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
2256HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 10481Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
1795Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
2047Post New Oracle General Questions
How do I uninstall oracle 11g?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How do I find my oracle client driver version?
How can I combine multiple rows into a comma-delimited list in oracle?
How to create a new table by selecting rows from another table?
What are the limitations oracle database 10g xe?
State some uses of redo log files?
How do I spool in oracle?
How to build data dictionary view an new database?
When do I need to use a semicolon vs a slash in oracle sql?
What is recovery manager in Oracle?
What is rowid and rownum in oracle?
What are internal user account in oracle?
How to Truncate Table in Oracle
How to export data to a csv file?