How to assign a table row to a record variable?
- 1 Answers
- 1139 Views
- I also Faced
- E-Mail Answers
Answer / Mr Praveen Kumar Jain
In Oracle SQL, you can use a SELECT statement with the `INTO` clause to assign a table row to a record variable. Here's an example:nn```sqlnDECLAREn my_record my_record_type;nBEGINn SELECT column1, column2 INTO my_record FROM your_table WHERE primary_key = :primary_key;n ...nEND;n``
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a directory object?
What are the differences between number and binary_float in oracle?
What are the oracle differences between nvl and coalesce
types of indexes and the rationale behind choosing a particular index for a situation.
How do I manually create a database in oracle?
Explain an index segment?
How to install oracle database 10g xe?
How to put more than 1000 values into an oracle in clause?
ABOUT IDENTITY?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
Oracle General 
