four procedures is are there should i write their in a package
Answers were Sorted based on User's Feedback
Answer / a.jyothsna
We can write any no.of procedures in a package
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rahul khanke
yes u can write number of procedure in a package
bcoz package is collectin of stored procedure and function.
the idea is-- it is an box(package) where all the material
(procedure and function) is stored.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can we insert in view in sql?
Explain what is an index?
What are the usages of sql?
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
Is sql better than excel?
What is auto increment feature in sql?
What is cursor and why it is required?
can we create index on index?
How can the performance of a trigger be improved?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Explain the purpose of %type and %rowtype data types with the example?
When do we create bitmap indexes
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)