how do get database name at sql prompt?
Answers were Sorted based on User's Feedback
Explain the use of tables option in exp command.
Use of an integrity constraint is better to validate data. Explain
Explain the use of ignore option in imp command.
What privilege is needed for a user to query tables in another schema?
write a query that displays every Friday in a year with date?
Can we create more than one index on particular column?
what is the difference between sql& oracle?
What is a synonym? What are its various types?
1) Does oracle have any table which contain all the exceptions and it's code internally?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to define an external table with a text file?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.