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

Whats the benefit of dbms_stats over analyze?

2064

---

Are truncate and delete commands same? If so why?

1201

---

Explain a private synonyms?

1097

---

What are the differences between char and varchar2 in oracle?

1246

---

Why use resource manager in Oracle?

1172

---

Will you be able to store pictures in the database?

1173

---

How to open a cursor variable?

1089

---

How to define a data field as not null?

1161

---

Why does oracle 9i treat an empty string as null?

1128

---

What is bulk load in oracle?

1125

---

How many memory layers are in the oracle shared pool?

1253

---

How to check the oracle tns settings?

1087

---

What is MTTR advisor in Oracle?

1137

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2408

---

How to manage transaction isolation level?

1054

---