what is difference between procedure and function
Answer Posted / k.sharada
procedure returns a value and function do not.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is the function that is used to transfer a pl/sql table log to a database table?
Why is there a need for sqlcode and sqlerrm variables?
What is triggering circuit?
What is the difference between unique and primary key constraints?
What is the main difference between sql and pl/sql?
Write a sql query to find the names of employees that begin with ‘a’?
Is sql free?
How run sql*plus commands that are stored in a local file?
What is primary key sql?
What are character functions?
how to get a list of all tables in a database? : Sql dba
Why should I use postgresql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How do we use distinct statement? What is its use?