what is variable in package specification
Answers were Sorted based on User's Feedback
Answer / suresh somayajula
variable which is declared in a paackage specification is
global to the package and local to the Schema.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / madhuri
Variables declared in package specification are known as
global variables
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / kiran r
Package specification is the declaration of public variables such as Cursors, Objects, Procedures, Functions and Exceptions.
Is This Answer Correct ? | 0 Yes | 0 No |
Can we enter data in a table in design view?
Can we use ddl statements in stored procedure sql server?
Can pl sql procedure have a return statement?
what is inline command?
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query
What has stored procedures in sql and how we can use it?
What is function and procedure?
How to make a copy values from one column to another in sql?
in procedure how to return a value
How to start the command-line sql*plus?
Can we create view in stored procedure?
What is Overloading of procedures ?