How will you distinguish a global variable with a local variable in pl/sql?
No Answer is Posted For this Question
Be the First to Post Answer
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
What is difference between hql and native sql?
what are date and time functions in mysql? : Sql dba
What is the meaning of disabling a trigger?
What is application trigger?
what are aggregate and scalar functions? : Sql dba
Why is nosql good?
Explian rowid, rownum? What are the psoducolumns we have?
how can we find the number of rows in a table using mysql? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
What are the types of functions in sql?
define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.
Oracle (3253)
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)