What are the benefits of stored procedures?
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
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What are properties of the transaction?
Does pl/sql support create command?
What is sql data?
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
What is a 'instead of trigger'?
What is transaction control language (tcl)?
Why coalesce is used in sql?
Explain mutating table error.
how can you see all indexes defined for a table? : Sql dba
write a query to delete similar records in same table