How does stored procedure reduce network traffic?
No Answer is Posted For this Question
Be the First to Post Answer
How many primary keys can a table have?
What is data modelling in sql?
What is Histogram?
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 are the types of join and explain each?
i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk
What are all types of user defined functions?
What is sql exception?
Can we create view in stored procedure?
What do we need to check in database testing?
Store procedure will return a value?
What are the two types of exceptions in pl/sql?