can i write pl/sql code in a package
Answers were Sorted based on User's Feedback
Yes we can write pl/sql code directly in package. This
process is known as package initialisation. In this we can
write the code direct in package body in the end of body.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / a.jyothsna
In package body we can write ..
But in package specification also we can write
| Is This Answer Correct ? | 0 Yes | 0 No |
how to get second highest salary in SQL(as/4000
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
what are properties of a transaction? : Sql dba
What is the use of procedures?
Does mysql support pl sql?
What is magic table?
What are %type and %rowtype for?
What is sqlerrd?
How do temporal tables work?
what are sequences
How insert into statements in sql?
What is the usage of NVL?
7 Answers Infosys, Micro Infotek,
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)