can i use global variables in stored procedure or function
Answer Posted / rajesh venati
Yes, we can use global variables in procedure and functions.
| Is This Answer Correct ? | 22 Yes | 1 No |
Post New Answer View All Answers
What is numeric function sql?
What do you understand by pl/sql cursors?
How do I delete a trigger?
Which is faster view or stored procedure?
What is the default isolation level in sql server? : Transact sql
What are character functions?
How show all rows in sql?
How do you explain an index number?
How does sql store data?
What is procedure in pl sql?
How to sort the rows in sql.
List out the acid properties and explain?
Can we use insert statement in function?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
what is the difference between a web-garden and a web-farm? : Sql dba