Answer Posted / nusrath sultana

We can make use of sequence to generate random numbers.
example:
SQL> create sequence seq1 start with 1 increment by 1
maxvalue 100;
SQL>Sequence created.

SQL> create table dup(rollno number(10) primary key,name
varchar2(20) not null);

Table created.

SQL> insert into dup values(seq1.nextval,'&name');
Enter value for name: SAM
old 1: insert into dup values(seq1.nextval,'&name'
new 1: insert into dup values(seq1.nextval,'SAM')

1 row created.

SQL> /

Enter value for name: RAM
old 1: insert into dup values(seq1.nextval,'&name'
new 1: insert into dup values(seq1.nextval,'RAM')

1 row created.

SQL> /
Enter value for name: REENA
old 1: insert into dup values(seq1.nextval,'&name'
new 1: insert into dup values(seq1.nextval,'REENA'

1 row created.

SQL> /
Enter value for name: TINA
old 1: insert into dup values(seq1.nextval,'&name'
new 1: insert into dup values(seq1.nextval,'TINA')

1 row created.

SQL> /
Enter value for name: MONA
old 1: insert into dup values(seq1.nextval,'&name'
new 1: insert into dup values(seq1.nextval,'MONA')

1 row created.

SQL> SELECT * FROM DUP;

ROLLNO NAME
---------- --------------------
1 SAM
2 RAM
3 REENA
4 TINA
5 MONA

master table and child table performances and comparisons in Oracle ?

2068

---

What are operators in oracle?

1009

---

How does one get the view definition of fixed views/tables?

967

---

What is a tns file?

938

---

What is an oracle user role?

937

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1031

---

Please explain oracle left join with an example?

958

---

What is a cursor in oracle?

1106

---

How to retrieve data from an explicit cursor?

1007

---

How to load data from external tables to regular tables?

986

---

material view and view disadvantages?

1017

---

How to create a single index for multiple columns?

978

---

What happens if variable names collide with table/column names?

1101

---

How to filter out duplications in the returning rows using oracle?

989

---

How to use regular expression in pattern match conditions in oracle?

975

---