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 the importance of .pll extension in oracle?

987

How to use values from other tables in update statements using oracle?

1066

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2378

How to create a temporary table in oracle?

1250

Explain the use of Merge statement in oracle 11g

1011

How to export data to a csv file?

1273

What is SQL access advisor in Oracle?

1177

How does Oracle guarantee data integrity of data changes?

2369

Explain what are the uses of rollback segment?

991

Explain what are the characteristics of data files?

1064

How to rename a tablespace in oracle?

1071

How to divide query output into groups in oracle?

977

How to delete a user account in oracle?

953

Explain the use of full option in exp command.

1089

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2111