can i use global variables in stored procedure or function
- 1 Answers
- 7454 Views
- L&T, I also Faced
- E-Mail Answers
Answer / rajesh venati
Yes, we can use global variables in procedure and functions.
| Is This Answer Correct ? | 22 Yes | 1 No |
Is primary key is clustered index?
How does sql developer connect to oracle database?
What is trigger and stored procedure in sql?
What is the difference between cross join and natural join?
How do you take the union of two tables in sql?
what are enums used for in mysql? : Sql dba
discuss about myisam key cache. : Sql dba
What is the difference between microsoft access and sql server?
What is sql constant?
Regarding joins what are the differences you observed in oracle 9i and sql server?
What are the built in functions of sql?
i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
