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 is a record in pl/sql?
How many triggers can be applied on a table?
what is commit? : Sql dba
Explain exception handling in pl/sql?
what is collation? : Sql dba
How do you know if a relationship is 2nf?
What are triggers and its uses?
What is function and procedure?
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...
What is the usage of when clause in trigger?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
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)