difference between bind variable and variable
- 1 Answers
- 2628 Views
- Attra, I also Faced
- E-Mail Answers
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 |
Can we create trigger on materialized view in oracle?
What is hash cluster in oracle?
What is concurrency in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How do we switch from init.ora file to asp file?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What do you mean by a database transaction & what all tcl statements are available in oracle?
select * from emp what happened internally when we write this query in the sql prompt?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What are the attributes of the cursor?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
how to get count of tables in particular database in Oracle?
Oracle General 
