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 are the tools for Oracle ?

1053

---

What privilege is needed for a user to query tables in another schema?

964

---

How to check your oracle database 10g xe installation?

980

---

What is the difference between translate and replace?

1053

---

Explain the use of grant option in imp command.

1016

---

What is an oracle tablespace?

1032

---

How to use attributes of the implicit cursor in oracle?

998

---

How to lock and unlock a user account in oracle?

1094

---

What is the difference between pre-select and pre-query?

1207

---

What is a data lock in oracle?

1092

---

What is an index associated with a constraint?

1026

---

How do I limit the number of rows returned by an oracle query after ordering?

1154

---

How do I connect to oracle?

1025

---

How do I call oracle stored procedures that take no parameters?

1099

---

Explain the use of analyse option in exp command.

1119

---