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 |
List different type of expressions with the example.
What are the different tcl commands in sql?
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
What are stored procedures in mysql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Which one is better sql or oracle?
what are the nonstandard string types? : Sql dba
Is t sql a programming language?
What is a design view?
What is a cursor for loop ?
Is join and inner join the same?
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)