Is trigger a stored procedure?
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 is the difference between primary key and unique key? : Sql dba
how to create a database in oracle?
How to get the 3rd column(i.e all the data along with the column name)in a table?
How does a self join work?
What is embedded sql what are its advantages?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
Differentiate between syntax and runtime errors.
Can you rollback after commit?
Is sql procedural language?
What is nvarchar in sql?
Types of optimization?