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

How to delete all rows a table in oracle?

1068

How to connect to a local oracle 10g xe server?

992

What is hot backup and logical backup?

1051

Which are the five query types available in oracle?

949

What is an oracle table?

991

How to create an oracle database?

1048

What are advantages of dateset in datastage?

2263

What are the various oracle database objects?

1148

How to load a large xml file?

1057

What is a user role in oracle?

1132

How to recover a dropped table in oracle?

1048

What is difference between cartesian join and cross join?

1091

How do I call oracle stored procedures that take no parameters?

1120

Explain the use of record length option in exp command.

1067

What is a cognitive schema?

972