bind variables created in SQL prompt for testing purpose variable create

difference between bind variable and variable

Question Posted / ravi gali

Answer Posted / ravi gali

bind variables created in SQL prompt for testing purpose

variable created inside the prcedures/functions/packages...
etc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5663

what is the difference between substr and instr function in oracle?

1138

What is a nvl function?

1091

What is an oracle recycle bin?

1058

What is using clause and give example?

1102

Why do we use bulk collect in oracle?

1103

what is the dual table in oracle?

1036

Explain parameter file in oracle.

1074

How to build data dictionary view an new database?

1042

Explain oracle left join with an example?

1055

In which language oracle has been developed?

1132

What is truncate oracle?

1010

What are set operators?

1134

what is the scenario where you take the database to NoArchivelog mode?

2371

What is enter substitution variable in oracle?

1092