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

What are the different types of trigger and explain its various uses and functions?

1024

What is an oracle and why it is used?

1090

What is the Tune Query

2242

What is index-organized table in Oracle?

1028

How to handle a single quote in oracle sql?

984

What is the parameter mode that can be passed to a procedure?

992

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2516

What is a tns file?

948

How to name query output columns in oracle?

1144

Are truncate and delete commands same? If so why?

1092

How to create a stored function in oracle?

1056

What is truncate oracle?

922

ABOUT IDENTITY?

2014

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1862

How to call a sub procedure?

1045