What are the query optimization techniques?
No Answer is Posted For this Question
Be the First to Post Answer
table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004
What are the components of a PL/SQL block ?
What is gpt format?
What is java sql connection?
What is the maximum rows in csv?
Can we call dml statement in function?
What are the three pl sql block types?
What does select count (*) mean in sql?
what is column? : Sql dba
What is the use of desc in sql?
In what condition is it good to disable a trigger?
What is procedure function?
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)