- Types of triggers
- View
- Dcl
- Procedures, packages, functions
- Metasolve
- Can use Dcl in triggers
- package case study
- Cursor and its types
- triggers schedule
- Wrap
- Why we are using fetch and for in cursor. difference?
What are sql queries used for?
What is difference between TRUNCATE & DELETE?
16 Answers Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,
What is difference between stored procedures and application procedures?
What are the parameter modes supported by pl/sql?
How many types of cursors are available in pl/sql?
What is string data type in sql?
How do we tune the code?
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....
Is microsoft sql free?
What is t sql used for?
What is difference between table and view?