can i use global variables in stored procedure or function
Answer / rajesh venati
Yes, we can use global variables in procedure and functions.
| Is This Answer Correct ? | 22 Yes | 1 No |
Does sql*plus have a pl/sql engine?
I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu
Is sql a programming?
What is the difference between delete and truncate statement in sql?
Why do we need pl sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
what is 'force view'?
Explain what is rdbms?
what is meant by databases
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
Which join condition can be specified using on clause?
is it necessary to write group by and order by clause together
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)