in procedure how to return a value
Answers were Sorted based on User's Feedback
Answer / rahul khanke
we can return a single or more than one value useing OUT
prameter
| Is This Answer Correct ? | 4 Yes | 0 No |
what are the type of locks ? : Sql dba
What are types of indexes in sql?
what is self-join? : Sql dba
How to write pl sql program in mysql command prompt?
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Can you have multiple SPs with the same name on a database?
25.67,-1 Trunc = 20 Round= 30 HOW????
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
how to create a table index in mysql? : Sql dba
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
Oracle (3253)
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)