How to add a new column to an existing table with a default value?

Question Posted / sushma chaudhary

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

How to count duplicated values in a column in oracle?

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

How to create an oracle database manually?

What is a View ?

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

Is a rollback possible to any savepoint?

State some uses of redo log files?

What is an oracle cursor variable?

What to do if the startbd.bat failed to start the xe instance?

Write a simple Store procedure and pass parameter to it ?

How to rename a column in an existing table?

For more Oracle General Interview Questions Click Here