Answer Posted / surya
Do we have constraining table in oracle :(
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what are properties of a transaction? : Sql dba
Why query optimization is needed?
What is function and procedure in pl sql?
How do you modify a table in sql?
Difference between truncate, delete and drop commands?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Explain some predefined exceptions.
What does truncate mean in sql?
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 localdb mssqllocaldb?
Can we create view in stored procedure?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
When do we use triggers?
Is natural join same as inner join?