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 is parameter substitution in sql?
How to place comments in pl/sql?
please explain database architecture..
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
what tools available for managing mysql server? : Sql dba
Why do we use cursors?
What is trigger explain with example?
What is a table?
What is the sql case statement?
How will you make performance better for application including front end and back
What are the advantages of stored procedure?
In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;
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)