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 |
How do you use a while loop in pl sql?
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 is the use of a view in sql?
Is it possible to pass parameters to triggers?
Which data type is a composite type?
I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
Is not equal in sql?
Main diff between varray and nested tablea
How many null values can be inserted in a coulmn whihc is unique constraint
Do view contain data?
What are the basic sql commands?
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)