Answer Posted / tanoy guhasarkar

the DBMS_RANDOM package provides a built-in random number
generator utility.

Using In Side A Block:--
DECLARE
my_random BINARY_INTEGER;
BEGIN
my_random := DBMS_RANDOM.RANDOM;

dbms_output.put_line(my_random);

end ;


Executing This Code, We Will Get A Random Number Every Time...

In Side A Select Statement :--

select DBMS_RANDOM.RANDOM from dual;

Note:--

This DBMS_RANDOM package included in oracle after oracle 8.

What is the sid in oracle?

898

---

Does facebook use oracle?

979

---

How to load excel data sheet to oracle database

965

---

What is the difference between I and G in Oracle?

1018

---

defination of bitmap index

2045

---

Explain what are the characteristics of data files?

1030

---

What is connection pooling in oracle?

911

---

Explain the use of ignore option in imp command.

975

---

What is java oracle used for?

965

---

How to define and use table alias names in oracle?

883

---

Who developed oracle & when?

944

---

How to use attributes of the implicit cursor in oracle?

947

---

What is an oracle and why it is used?

1077

---

What are the components of logical database structure in oracle database?

1022

---

When system tablespace is created?

968

---