-
Query based Database Tuning
What is query based database tuning?
-
Through Shell script in Unix, How can you run the Oracle procedure?
saginandkishore
- Jun 20th, 2008
To execute sqlplus via Unix shell scripts the following parameters need to be initialized.(1.) ORACLE_HOME export ORACLE_HOME=Path to <ORACLE_HOME>(2.) ORACLE_SIDexport ORACLE_SID=Actual ORACLE_...
srinsr
- Mar 14th, 2007
$ORACLE_SQLPLUS -s $TCS_ORACLE_ID > $ORALOG 2>&1 <<EOFset serveroutput onset heading offset feedback offset verify offset linesize 250set pagesize 0set termout offexec solpk_upd_tcash ( '$SRC_SYS_CD', '$Date');commit;quit;EOF
-
-
Hi, We are on Oracle Apps 11.5.8Database 9.2.0.6 We want Report outputs in excel. Is there anyway we can get the same. Sajani Pillai
svinaymbd
- Jun 12th, 2008
Hito convert report in excel format your need to install desktop patch on your client and should have the xml publisher responsibility as a developer you need to create a first you need to convert you...
-
UTL File Package
What parameter must be set in init.ora file for utl_file package?
-
-
How to copy the tables from one system to another or from one user to another user?
Means i have 150 tables in one system, i want to copy those tables into another system.
-
How to write RESERVE WORD as table column?For example if you want to write Number as table column name How do you write?
vamsikatragadda
- Mar 9th, 2008
You Can do it Simply but keeping the table name in quotes Here it goes like thisCreate table "table" as select * from table_name;and your problem is solvedenjoy
-
-
Difference between co-related query and co-related sub query
kirangsv
- Jun 2nd, 2008
Co-related sub-query:- The main differencre between subquery and co-related subquery is that in subquery child query is executed first n then parent,but in co-related subquery main query is executed...
-
How to find out running totals in D2K Report?
kirangsv
- Jun 2nd, 2008
Well you can do it in 2 ways i.e., 1. Manually 2. Wizard wise u can do it both are one and the same try it if any doughts plz let me know will do further needful to u
-
How to use interfacing table?
kirangsv
- Jun 2nd, 2008
Hi suman,Hope you were asking about interface tables. Its used to transfer the data from a legach system into oracle database. For e.g., if you have a data other than Oracle format (like VB, linux...)...
-
Oracle Explain
In Oracle what is meant by 'Explain'
singh.neerajin
- May 28th, 2008
This must be oracle explain plan.The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements. It also helps you to underst...
-
Hi All, How do i run the otrcsvr.sql file in Oracle9i, it is suppose to be available in @$ORACLE_HOME/rdbms/admin; But its is not present in that folder. Can i use another script on Oracle 9i to achieve the same ?Regards,Ashish
satishorre
- May 27th, 2008
Connect your database as sysdbawe assume that this script available in $ORACLE_HOME/rdbms/adminRun the script at the SQL prompt@$ORACLE_HOME/rdbms/admin/otrcsvr.sqlLet me know any comment if any
-
-
What is stucture of Database
AshaMahesh
- May 15th, 2008
ther is Physical structure & Logical structurePhysical structure Consits of 3 files one or more data files ...
Mohammed Abdul Afroze
- Sep 28th, 2007
The Physical Structure of a Database are as follows:1.Controlfiles2.Redo Log Files3.Datafiles.
-
How to write a query to retrieve only the months from certain given duration.
I will be getting this duration from the dual table. Provide query for this.Like for example, if suppose I am going to get value from the month of 01-Jan-2006 to 31-Apr-2007 then My result should be only 4 months like Jan, Feb, Mar, Apr.Btu not the whole dates. Only four rows has to be retrieved. This should be retrieved from the dual table but not from other tables.
Imran_Javed
- May 13th, 2008
SELECT TO_CHAR(ADD_MONTHS('01-jan-2007', ROWNUM-1), 'MON')FROM dualWHERE ADD_MONTHS('01-jan-2007',ROWNUM-1) < '30-apr-2007' CONNECT BY LEVEL <=12;
jamesravid
- Jul 18th, 2007
Use this query, select to_char(add_months('01-jan-2007',rownum-1),'MON') from user_objects where add_months('01-jan-2007',rownum-1) < '30-apr-2007';
-
What is the command to get the number of coloumns in table
Imran_Javed
- May 13th, 2008
SELECT COUNT(cname)FROM COL c, TAB TWHERE T.Tname = c.Tname AND T.Tabtype='TABLE' AND T.Tname ='EMP';
debasisdas
- Jul 7th, 2007
SELECT COUNT(COLUMN_NAME) FROM DBA_TAB_COLUMNS WHERE table_name = 'TABLE_NAME' AND owner = 'OWNER_NAME' ;
-
Evaluate this query?Select e.emp_id from emp@wing e; What is "@wing" ? Is it a partition on emp table or a constraint on table emp?
Imran_Javed
- May 13th, 2008
Its a DB link which is used to access tables which reside on another server.From the above query you are trying to access emp table which is in "WING" schema.WING being on other server.
-
Oracle Dual
Select round(13.19,1) from dual will return 13.2Select round(13.19,-1) from dual ....what will be the output.....IN ORACLE
Imran_Javed
- May 13th, 2008
SELECT ROUND(13.19,-1) FROM DUAL;RETURN result IS 10; WHEN you pass second argument AS "-1" , rounding takes place BEFORE the DECIMAL point.That IS the reason IN the above example it rounds 13 TO 10. IF you USE 15 OR more than 15 it will ROUND TO 20
Oracle Basics Interview Questions
Ans