How to resolve name conflicts between variables and columns?
Answer / Hariom Narayan
To avoid name conflicts between variables and columns in Oracle PL/SQL, you can use aliases for the column, rename the variable or the column, or use a different block.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to create an oracle database?
How to run create database statement again?
What is autonomous transaction?
Explain what does a control file contain?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
how to produce numbers from 1 to 10 using dual table
what is the use of composite key constraint?
What is an Index ? How it is implemented in Oracle Database ?
How to rename a tablespace in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is oracle rownum?
How to use subqueries with the exists operator in oracle?