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 |
What makes a good primary key?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
Can we connect to postgresql using sql developer?
what is meant by forward declaration in functions?
What are sql indexes?
what is the difference between a web-garden and a web-farm? : Sql dba
Which one is better subquery or joins?
wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?
4 Answers Oracle, TCS, Tecnics,
create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
What is form and report?
what is the difference between nested subquery and correlated subquery?
Why do we use procedures 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)