What is the difference between database trigger and stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
Define union, minus, union all, intersect ?
What are pl/sql cursor exceptions?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
What is constant in pl sql?
what is collation? : Sql dba
How do I count rows in sql query?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
List out the acid properties and explain?
What are the advantages of pl sql?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
what is offset-fetch filter in tsql? : Transact sql
Why functions are used in sql?
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)