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
|Is This Answer Correct ?||3 Yes||2 No|
What is numeric function sql?
What is an inner join sql?
What is offset in sql query?
How do you write a subquery?
Why commit is not used in triggers?
What is sql lookup?
Can you have more than one key in a database?
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
What are the types of dbms?
What is a sql trace file?
What is foreign key and example?
Does view store data in sql?