difference between bind variable and variable
Answer / 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 |
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
 How to use an oracle sequence generator in a mapping?
What are privileges and grants?
How would you extract DDL of a table without using a GUI tool?
various types of hints and their usage
Explain the use of show option in imp command.
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
What are the restrictions on external table columns?
What is Redo Log Buffer in Oracle?
What is a database table in oracle?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
What view(s) do you use to associate a users SQLPLUS session with his o/s process?