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.

How to create a single index for multiple columns?

1037

---

What is an oracle recycle bin?

1009

---

what is Single Byte Overhead...?

2555

---

How to convert numbers to characters in oracle?

1030

---

What is materialized view in Oracle?

1074

---

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

---

What is set operator oracle?

980

---

When do I need to use a semicolon vs a slash in oracle sql?

1090

---

Difference between the “verify” and “feedback” command?

1368

---

What is the relation of a user account and a schema in oracle?

1080

---

What are dml statements in oracle?

1095

---

What is the use of file param in imp command?

1165

---

What do you mean by cdb and pdb in oracle 12c?

1060

---

In which language oracle has been developed?

1075

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2022

---