What is trigger and stored procedure in sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What are field types?

0 Answers  


Mention what plvcmt and plvrb does in pl/sql?

0 Answers  


What is the difference between a query and a report?

0 Answers  


What is difference between left and right outer join?

0 Answers  


Explain what is a column in a table?

0 Answers  






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

0 Answers  


What is a unique key?

0 Answers  


What is the use of index in hive?

0 Answers  


what is the difference between nested subquery and correlated subquery?

0 Answers  


Explain the methods used to protect source code of pl/sql.

0 Answers  


What is scalar and vector?

0 Answers  


How can you select unique records from a table?

0 Answers  


Categories