how to create a primary key with out creating an index?

Answer Posted / santanu

hi,
we can create pry key also by creating a sequence with NO
CYCLE option.
san

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a data definition language?

784


what is a database lock ? : Sql dba

777


Explian rowid, rownum?

736


How run sql*plus commands that are stored in a local file?

702


Is it mandatory for the primary key to be given a value when a new record is inserted?

925






What are the syntax and use of the coalesce function?

766


What does := mean in pl sql?

750


What is oracle sql developer?

786


What is a primary key called that is made up of more than one field?

1023


What is varchar used for?

743


Can a procedure in a package be overloaded?

746


Does normalization improve performance?

755


What is difference sql and mysql?

696


What is difference between left and right outer join?

717


Write a query to display the current date in sql?

733