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 use "for" statements in oracle?

1123

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2066

please explain.. DB architecture ...

2081

Use of an integrity constraint is better to validate data. Explain

1088

How to change user password in oracle?

1093

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1982

What is the data type of dual table?

1064

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2147

What are the restrictions in a oracle read only transaction?

1081

Write a syntax for update query in oracle?

1073

What are the types of partitions in oracle?

1078

Is oracle the best database?

1010

How many types of database triggers exist?

1186

Whats the benefit of dbms_stats over analyze?

2064

How to connect to oracle using service name instead of sid?

1067