How to resolve name conflicts between variables and columns?



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

Post New Answer

More Oracle General Interview Questions

How to create an oracle database?

1 Answers  


How to run create database statement again?

1 Answers  


What is autonomous transaction?

6 Answers  


Explain what does a control file contain?

1 Answers  


It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

5 Answers  


how to produce numbers from 1 to 10 using dual table

4 Answers   Genpact,


what is the use of composite key constraint?

2 Answers  


What is an Index ? How it is implemented in Oracle Database ?

4 Answers  


How to rename a tablespace in oracle?

1 Answers  


what is difference between sql plus and sql*plus? (not sql and sql plus).

1 Answers  


What is oracle rownum?

1 Answers  


How to use subqueries with the exists operator in oracle?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)