How to add a new column to an existing table with a default value?
Explain the use of grant option in exp command.
How to Identify the previously inserted/updated records in already populated table.
What is a sub query? Describe its types?
Explain overloading. Can functions be overloaded?
What happens if variable names collide with table/column names?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
which language is used to develop the oracle........?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What do you mean by a tablespace?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is using clause and give example?
How to retrieve 5th highest sal from emp table?