Answer Posted / vishal
procedure have two type of parameter intput and output type
but function have only one
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What is orm in sql?
What are triggers in sql?
What are the different types of sql commands?
how can we know the number of days between two given dates using mysql? : Sql dba
Name some usages of database trigger?
What are triggers and its uses?
What normalization means?
How can you load multi line records? : aql loader
What is the sql case statement?
Can we create table in function?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what is acid property in database? : Sql dba
What is a primary key sql?
Can we use insert statement in function?
Explain character-manipulation functions?
