what are the advantages of mysql in comparison to oracle? : Sql dba
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
Is full outer join same as cross join?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is scalar and vector?
How do you create a db file?
how to check server status with 'mysqladmin'? : Sql dba
What is pl sql and why it is used for?
What is difference between inner join and cross join?
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.
What is sqlexception in java?
What is the use of desc in sql?
Does sql*plus also have a pl/sql engine?