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.
- 1 Answers
- 2203 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / 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 |
What to do if dba lost the system password?
What are the different oracle database objects?
In Oracle 9i what does "i" Stands for?
How to delete a column in an existing table?
Explain a synonym?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
What is a Sequence ?
How to use values from other tables in update statements using oracle?
What is Hash Cluster ?
how the indexes are stored in the Oracle Database?
How to convert csv to table in oracle?
Explain the use of analyse option in exp command.
Oracle General 
