what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?
1 8521we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?
TCS,
3 7586i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
IBM, Loginworks, OFSS,
2 9658How do you display "13th of November, 17 days left for month end" without hardcoding the date.
3 6145i 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.
2 5074
What will you get by the cursor attribute sql%found?
What is a unique constraint?
Can you do multiple joins in sql?
how many values can the set function of mysql take? : Sql dba
Which version of sql do I have?
What are string functions in sql?
what is online transaction processing (oltp)? : Sql dba
How to write html code in pl sql?
Why do we use joins?
how to see the create table statement of an existing table? : Sql dba
what is foreign key? : Sql dba
How can the performance of a trigger be improved?
What is a Mapplet?
What is full form of rtm?
How do I create a sql database?