What is SQL Tuning? How does it work? Thanks

abhi2433

 Profile Answers by abhi2433 Questions by abhi2433

• Feb 6th, 2008

SQL tuning is the process of ensuring that the SQL statements that an application will issue will run in the fastest possible time

Answer Question  Select Best Answer

select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

patilpravin_1981

 Profile Answers by patilpravin_1981 Questions by patilpravin_1981

• Jan 30th, 2008

Select * from employees where salary between(1000 and 5000);

LRANI

 Profile Answers by LRANI Questions by LRANI

• Jul 31st, 2007

Hi,minus is used for finding the missing records between 2 tables and not finding the records between the range.It is BETWEEN operator that displays the records between 2 ranges from single table.

Answer Question  Select Best Answer

vanigreat

 Profile Answers by vanigreat Questions by vanigreat

• Jan 17th, 2008

select (to_date('31/01/2008','dd/mm/rrrr')-to_date('01/01/2008','dd/mm/rrrr')+1) - (select count(days) from (selectto_char(to_date('01/01/2008','dd/mm/rrrr&...

Answer Question  Select Best Answer

Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname of person = lastname of second person? ln phone----------------------------------john cubick 1223sam course 4556output:john course

geminine79

 Profile Answers by geminine79 Questions by geminine79

• Jan 3rd, 2008

I think you can use the cartesian product on the same table and try to get the data out of that. try this and let me know.

naveen.papineni

 Profile Answers by naveen.papineni Questions by naveen.papineni

• Nov 26th, 2007

Select first_name ,last_name ,phone_number from table where first_name in (select last_name from table )I think this will work out.RegardsNaveen.

Answer Question  Select Best Answer

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 10th, 2007

Dear Shruti,First query the data dictionary view "USER_CONS_COLUMNS" to find the constraint name.Then instead of dropping the constraint just disable it.step1:--> select constraint_name,c...

Answer Question  Select Best Answer

I cant drop the whole column because that is interlinked with my process? I have declared not null on a column, I have to change it

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 10th, 2007

Dear Sarika,Instead dropping the constraint just disable the constarint.The command is:Alter table table_name disable constraint constraint_name;try it and reply me

Answer Question  Select Best Answer

How to know the days or months or years between two employees in emp table.

jbabu

 Profile Answers by jbabu Questions by jbabu

• Dec 10th, 2007

Select hiredate,lead(hiredate,1) over(order by hiredate) next_months, round(months_between(lead(hiredate,1) over(order by hiredate),hiredate),3) months from emp;

Answer Question  Select Best Answer

How to see on what coloumns the indexes have been created?

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 29th, 2007

SELECT * FROM ALL_INDEXES WHERE TABLE_NAME = 'table_name'-- It will give u all indexes in required table

Answer Question  Select Best Answer

For e.g. Create table tempOCT as Select....If i run the code in any day of Nov the table name should be tempNOV.

vishal gupta

• Nov 21st, 2007

You can do one this?in the code itself that is going to create the table at run time incorporate the logic to get the currect date,?take it as string variable and then in the code itself you can write the query?Create table as(..)Might help you.Vishal.

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

I think it is not possible, i try to concate date with table name but no vail.You can not rename the table name by cancating date

Answer Question  Select Best Answer

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

 SELECT BYTES/1024     FROM DBA_EXTENTS  WHERE OWNER = 'SCOTT'       AND SEGMENT_NAME = 'EMP';  This will return you size of table in Kilo Bytes.  User is Scott and Table is Emp.

Answer Question  Select Best Answer

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 20th, 2007

ALTER TABLE table_nameADD CONSTRAINT table_column_pk PRIMARY KEY (column_name);It is a table level primary key constraint applied on an existing table. SELECT TO_CHAR(DOB, 'DD-MM-YYYY')   FROM table_name;

Answer Question  Select Best Answer

Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screenCan be row level or statement level No distinction between row level and statement level.Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms.Can be fired from any...

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 14th, 2007

Database Trigger: We can't invoke a Form Trigger in DatabaseFrom Trigger: We can invoke a Database Trigger in Forms

Mohit Dhamija

• Jul 3rd, 2006

Even 'Form Trigger' can be fired before and after the event. ex- Triggers like Pre Block / Pre Record / Post Block / Post Record ..

Answer Question  Select Best Answer

CD

• Nov 5th, 2007

You may use a functions called 'characters'.Syntax:characters ()

Answer Question  Select Best Answer

Choose - Choose either Rule based or Cost based depend on theavailability of statistics. If statistics is available on the table it usesCBO and if not it uses RBO.       ALL_ROWS - Choose based optimization, statistics is needed. U couldpass as hint in ur query.But in the majority of cases with optimizer_mode=choose ( and with a goodstatistics ) the CBO will be able to find a good...

Manoj Seemar

 Profile Answers by Manoj Seemar Questions by Manoj Seemar

• Nov 2nd, 2007

The OPTIMIZER_MODE initialization parameter establishes the default behavior for choosing an optimization approach for the instance.CHOOSEThe optimizer chooses between a cost-based approach and a rule...

Answer Question  Select Best Answer

vidya

• Oct 30th, 2007

Where clause doesnt allow group functions.You need to use Having Clause.i.e Having count(*)>1

ROHIT_4444

 Profile Answers by ROHIT_4444 Questions by ROHIT_4444

• Mar 28th, 2007

IN THIS PREV NO EXPRESSION I PUT = IT WORK BUT ONLY SIMILAR EXACT QUERY IS DELETE FROM  WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM  GROUP BY <DUPLICATE VALUE FIELD NAME);IT'S WORK SURE

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 28th, 2007

1. When you create more indexes on a table , for example  table A has 10 columns and you have create 8 indexes on that table. Then whenever you r going to retrieve data from that table each row o...

Sushma

• Jul 11th, 2007

3.If we have the null values in the column then we can not create primary key trigger on that column.4. It is an event that raised implicitly when you update the table.Regards,Sushma

Answer Question  Select Best Answer

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 23rd, 2007

As in case of normalization and properly index conditions and order of coulumns are not require to care the pointer of the new record created at last. This will be managed by the indexes and orders of...

Madhu

• Mar 24th, 2007

Suppose a table dept contains 3 columns say deptno,dname and loc.If u want to change the order of dname and loc in reverse,then write  a query as followscreate table dept1 as  (select deptno,loc,dname from dept);drop table dept;create table dept as (select * from dept1); 

Answer Question  Select Best Answer

Dhaval

• Nov 14th, 2006

Select Count(*) , DATEPART ( hh , sellgoodsdate) From goodssellGroup By DATEPART ( hh , sellgoodsdate)

Answer Question  Select Best Answer

vaibhav Tyagi

 Profile Answers by vaibhav Tyagi Questions by vaibhav Tyagi

• Oct 21st, 2007

Create proc EarnMoneyProcasdeclare @earn int,@total int,@tempday int,@TotDays int set @earn=1set @tempday=1set @total=0set @Totdays = 50*365print @Totdayswhile(@tempday <= @Totdays  )beginset @earn = @earn + 2;set @tempday =@tempday+1print @earnendprint @total

Srinivasa Pavan

• Jan 9th, 2007

hai allam a new to this site and i can give a solution to this Question and here is the coding for that.declare result number :=1;inc number ?:=2;year number :=1;i number;beginwhile??(?year?<=50?)?...

Answer Question  Select Best Answer

vaibhav Tyagi

 Profile Answers by vaibhav Tyagi Questions by vaibhav Tyagi

• Oct 21st, 2007

ROWLOCK Use row-level locks when reading or modifying data. PAGLOCK Use page-level locks when reading or modifying data. TABLOCK Use a table lock when reading or modifying data. DBLOCK Use a database...

Answer Question  Select Best Answer