Difference between primary key and unique key ?
Answer Posted / pandiyan
Primary key doesnot allow null value but unique key allows
null value.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between pre-select and pre-query?
What is an oracle database?
How to list all indexes in your schema?
How to run create database statement again?
How do I know if oracle is installed on windows?
What is the usage of merge statement?
How to create a new user account in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
what are bitmap indexes? How does they work?
How to create lov dynamically at runtime & attach to text field?
Explain implicit cursor.
Explain temporal data types in oracle
What are the set operators union, union all, minus & intersect meant to do?
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
How to assign data of the deleted row to variables?