adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Using the relations and the rules set out in the notes under
each relation, write statements to create the two sequence
generators specified in the notes.

Question Posted / Anand Singh

Answer Posted / Anand Singh

This question requires writing SQL sequences creation statements based on given relations. Here's an example of how to create sequences named EMPLOYEE_SEQ and DESPATCH_SEQ:

CREATE SEQUENCE EMPLOYEE_SEQ START WITH 1;

CREATE SEQUENCE DESPATCH_SEQ START WITH 1000;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to start an oracle instance?

1103

How to select all columns of all rows from a table in oracle?

1132

Design database draw er diagram for a certain scenario ?

4656

What is oracle latest version?

1174

How to use values from other tables in update statements using oracle?

1158

How to write a left outer join with the where clause in oracle?

1155

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

How to put more than 1000 values into an oracle in clause?

1115