Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and storedprocedures
- 16 Answers
- 31709 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / tina
Hello Sharma,
Stored procesure is also have compiled code like triggers.
Thanks,
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What are pl sql procedures?
what is a tablespace? : Sql dba
how to drop an existing view in mysql? : Sql dba
Why are indexes and views important to an organization?
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
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Why is theta join required?
What are the types of index in sql?
How do you clear the screen in sql?
How do you modify a table in sql?
Does sap use sql?
What is a parameter query?
What is the difference between Union and Union all. Which is faster.
Can you have more than one key in a database?
Are views faster than queries?
