How to avoid using cursors? What to use instead of cursor and in what cases to do so?
- 0 Answers
- 607 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can you skip header records while loading? : aql loader
What are different clauses used in sql?
What are sql ddl commands?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
How many scalar data types are supported in pl/sql?
Is left join same as join?
What is time based sql injection?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What are different types of triggers?
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
How to add Foreign key in a table after the creation of the table?
define sql delete statement ? : Sql dba
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
