What is a package ? What are the advantages of packages ?
Answers were Sorted based on User's Feedback
Answer / tulsi
Package is a database object that groups logically related
procedures.
The advantages of packages are Modularity, Easier
Applicaton Design, Information. Hiding,. reusability and
Better Performance.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / sandy
Package is a game with a lots of indiviual players
performing there roles as in a group.
| Is This Answer Correct ? | 5 Yes | 1 No |
Is join same as left join?
How can a pl sql block be executed?
how to use in conditions? : Sql dba
What does rownum mean in sql?
How does left join work in sql?
What are the limitations of sql express?
What is pl sql variable?
How to create your own reports in sql developer?
1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins
How does a self join work?
Can we rename a column in the output of sql query?
How do you sort 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)