how to genarate random numbers in oracle for particular row?
- 3 Answers
- 6450 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What happens to the indexes if a table is recovered?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What do you mean by redo log file mirroring?
How many anonymous blocks can be defined?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What are oracle functions?
Explain an exception?
What is the usage of analyze command in oracle?
Is the After report trigger fired if the report execution fails ?
Can we call procedure inside function in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
How to select some columns from a table in oracle?
What is transport network substrate (tns) in oracle?
How do I spool to a csv formatted file using sqlplus?
What is a nested table?
