first take table. the table contain a more than one row. write query displ

how to genarate random numbers in oracle for particular row?

Question Posted / swamireddy

Answer Posted / swamireddy

first take table. the table contain a more than one row.
write query display the row randomly.
SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explain a data segment?

1015

Why do you create or replace procedures rather that drop and recreate.

946

What are the common oracle dba tasks?

1069

What are the ansi data types supported in oracle?

895

What is oracle sid?

887

What is the data pump import utility?

968

How to use "out" parameter properly?

1023

What is raw datatype in oracle?

1050

What happens if you use a wrong connect identifier?

979

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2183

What is oracle data type?

901

Explain constraining triggers.

1043

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2219

What is tns service name?

1072

Differentiate between translate and replace?

1038