How to add a new column to an existing table with a default value?
No Answer is Posted For this Question
Be the First to Post Answer
Is oracle a programming language?
What is pragma autonomous transaction in oracle?
Please explan Why static query is more faster than dynamic query ?
what is foreign key?
How does Oracle guarantee data integrity of data changes?
Differentiate between TRUNCATE and DELETE?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
What is index in Oracle?
Difference between varchar and varchar2 data types?
What are the different pseudo commands? Explain in general?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
what happened to the global index when I truncate the data in one of the partition?