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 an oracle and why it is used?

1213

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114

---

Can we save images in a database and if yes, how?

1109

---

How to change program global area (pga) in oracle?

1146

---

How to invoke the data pump export utility?

1252

---

what happened to the global index when I truncate the data in one of the partition?

2066

---

How to convert characters to numbers in oracle?

1112

---

What is oracle database client?

1081

---

What is merge in oracle?

1095

---

What is a data dictionary and how can it be created?

1238

---

When system tablespace is created?

1090

---

What is bulk load in oracle?

1125

---

Is the After report trigger fired if the report execution fails ?

2952

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2262

---

What is index in Oracle?

1128

---