Interested to Buy Any Domain ? << Click Here >> for more details...
how to tune oracle sql queries pls tell me step by step.
urgent pls
- 1 Answers
- 3279 Views
- I also Faced
- E-Mail Answers
Answer / define
You can use pl/sql query profiler in dbForge Studio for Oracle. It helps to tune oracle sql performance very much.
| Is This Answer Correct ? | 0 Yes | 1 No |
what are the default admin accounts in Oracle 10g ?
what are the advantages of running a database in NO archive log mode?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
is there a tool to trace queries, like profiler for sql server?
what is the scripts in data base?
Why packages are used in oracle?
what is meant by magic query
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
find out first highest salary?
10 Answers Verinon Technology Solutions,
What is instant client oracle?
Oracle General 
