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

What is an anonymous block?

1169

How does oracle handle read consistency?

1054

What are the different pseudo commands? Explain in general?

1028

What is different types of joins?

972

How a tablespace is related to data files?

1064

How to view existing locks on the database?

1005

What is oracle rowcount?

1041

How to create tables for odbc connection testing?

1022

What is the recommended interval at which to run statspack snapshots, and why?

2875

How to estimate disk space needed for an export job?

997

What to do if the binary spfile is wrong for the default instance?

1008

How to create a new oracle data file?

977

What is enter substitution variable in oracle?

994

How to set up autotrace for a user account?

986

how may join possible between (requisition with purchase order)

2175