What are the rules to be applied to nulls whilst doing comparisons?
No Answer is Posted For this Question
Be the First to Post Answer
How do rank () and dense_rank () differ?
Differentiate between syntax and runtime errors.
How to display the contents of a current record fetched in a reference cursor?
What are primary key and foreign key and how they work?
What are the types of triggers in sql?
What are the types of optimization?
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
Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)
What is a scalar value in sql?
Can we use commit inside a trigger?
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
how to get @@error and @@rowcount at the same time? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)