How to select all records from the table?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
What is a cursor ? Why Cursor is required ?
what does the t-sql command ident_current does? : Transact sql
Is it possible to update views?
What is sql catalog?
what is the difference between inner and outer join? Explain with example. : Sql dba
Can triggers stop a dml statement from executing on a table?
What is out parameter used for eventhough return statement can also be used in pl/sql?
what is ref cursor in pl/sql?
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 is a recursive stored procedure?
What is dynamic query?