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 2284What are the differences between a sys and system user and what are the extra privileges available to the sys user?
1 4611I 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
1662HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 7958Using 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.
1218Using 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.
1465Post New Oracle General Questions
How to export your own schema?
What are the differences between char and varchar2 in oracle?
How do I know if oracle client is installed on windows?
What is sequence?
How to export data with a field delimiter?
How to unlock the sample user account in oracle?
Explain joins in oracle?
Explain integrity constraint?
How to get execution statistics reports on query statements?
What are the general rules on data consistency?
How to sort output in descending order in oracle?
What is integrity and what is constraint??Explain with example
What is an oracle wallet?
What is meant by a deadlock situation?
How to recover a dropped table in oracle?
