Answer Posted / nageswararao.kamineni
we can create morethan one constrint on column
for example
create table emp11
(empno number(2) primary key,
ename varchar2(20) unique,not null
sal number(7,2));
here a table can containe only one primary key,if we wnat
declare more then one primary key,we can create like this
using unique and not null constarint.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is format trigger?
How to shutdown your 10g xe server from command line?
What is dual table oracle?
What are set operators?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to create a stored program unit?
Explain the use of analyse option in exp command.
What is java oracle used for?
What is the difference between primary key and unique key and foreign key in oracle?
Explain the types of exception?
How to export your connection information to a file?
How to speed up webrick?
What is logical backup in oracle?
what is the dual table in oracle?
How to manage transaction isolation level?
