What is procedure in pl sql?
No Answer is Posted For this Question
Be the First to Post Answer
Does asenumerable execute the query?
how can we know the number of days between two given dates using mysql? : Sql dba
What is the syntax and use of the coalesce function?
What is rollback?
What is the difference among union, minus and intersect?
What is optimistic concurrency control? : Transact sql
What are the various levels of constraints?
What does select top 1 do in sql?
what are the different tables present in mysql? : Sql dba
Can we use ddl statements in stored procedure?
What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.
I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL
5 Answers Doyensys, Infosys, Metric Stream,
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)