How to define a variable to match a table column data type?
Answer / Ashvin Yadav
"To define a variable that matches the data type of a specific table column, you can simply declare the variable with the same data type as the column in your PL/SQL block.nnDECLAREn my_column VARCHAR2(255); BEGIN ... END;"
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we commit inside a function in oracle?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
What is bulk copy or bcp in oracle?
List out the components of logical database structure of oracle database.
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
How to define a record variable to store a table row?
What are the data types in oracle?
How to export your connection information to a file?
What is Index and different types of Indexes?
What is a cognitive schema?
What is using clause and give example?
How can you merge two tables in oracle?