How to define a record variable to store a table row?
- 1 Answers
- 1149 Views
- I also Faced
- E-Mail Answers
Answer / Rahul Pratap Singh
To define a record variable to store a table row in Oracle, you can use the RECORD keyword followed by the table name. For example: n`DECLARE recMyTable MyTable%ROWTYPE; BEGIN SELECT * INTO recMyTable FROM my_table WHERE id = 1; END;`
| Is This Answer Correct ? | 0 Yes | 0 No |
what is analyze command ? what kind of statistics does it generate?
How to download oracle database 10g xe?
Explain the function of optimizer in oracle?
What is Network Database link ?
Explain integrity constraint?
How can we find out the current date and time in oracle?
Give the different types of rollback segments.
What is a OUTER JOIN?
What is key preserved table?
What is the difference between substr and instr?
Name the various constraints used in oracle?
How to do clean up if create database failed?
Oracle General 
