IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY??????
- 8 Answers
- 8809 Views
- rsystems, I also Faced
- E-Mail Answers
Answer Posted / banti
Both r same :)
Primary Key= (Unique + Not Null)
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Explain the difference in execution of triggers and stored procedures?
what is 'mysqlimport'? : Sql dba
What are the two types of periodical indexes?
what are properties of a transaction? : Sql dba
what is the syntax used for partition in tsql? : Transact sql
What is string data type in sql?
Which join is like inner join?
what is a trigger in mysql? : Sql dba
Which is better join or subquery?
What is application trigger?
Mention what pl/sql package consists of?
What is difference between table and view?
The select into statement is most often used to create backup copies of tables or for archiving records?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What do you understand by pl/sql records?
