How to get each name only once from an employee table?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What are types of joins?
What is the maximum rows in csv?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
how to create table with in the procedure or function?
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
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.
What are the types of records?
Enlist some predefined exceptions?
what is explain plan?
Types of backups ?
What does the base_object_type column shows in the user.triggers data dictionary view?
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)