why dont we assign not null constraint as table level
constraint.
No Answer is Posted For this Question
Be the First to Post Answer
What are the different types of partitions in oracle?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
sql query to get zero records from a table
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What do database buffers contain?
What are the limitations of check constraint?
Calculate difference between 2 date / times in oracle sql?
What is the recommended interval at which to run statspack snapshots, and why?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
In oracle there is column command, how will you explain that?
What is the function of Redo Log ?