Can pl sql procedure have a return statement?
No Answer is Posted For this Question
Be the First to Post Answer
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
how a reference cursor works?what all adnvantages are gained with it..specify the situation?
What is the default value of CHAR type?
Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.
What does “select count(*) from tab” result?
15 Answers IBM, Student, Wipro,
what is Complex index. how to create it?
what is user defined functions? : Sql dba
<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?
What are the types of views in sql?
What is transaction control language (tcl)?
How to access the current value and next value from a sequence?
Can we use joins in subquery?
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)