What is analyze command used for?
No Answer is Posted For this Question
Be the First to Post Answer
How to see the table columns used in an index?
How to create a new oracle data file?
how do u setup a replication site?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
what is shell?
what is exact difference between drop and truncate table.
What is Data Dictionary Cache in Oracle?
Please explan Why static query is more faster than dynamic query ?
What is an external table?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
what are the advantages of running a database in archive log mode?