saginandkishore

 Profile Answers by saginandkishore Questions by 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

Answer Question  Select Best Answer

svinaymbd

 Profile Answers by svinaymbd Questions by 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...

Answer Question  Select Best Answer

Means i have 150 tables in one system, i want to copy those tables into another system.

ravi.allam9

 Profile Answers by ravi.allam9 Questions by ravi.allam9

• Jun 4th, 2008

Using import/export

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

1. copy2. create table as select3. export/import

Answer Question  Select Best Answer

ravi.allam9

 Profile Answers by ravi.allam9 Questions by ravi.allam9

• Jun 4th, 2008

Using double quotes

vamsikatragadda

 Profile Answers by vamsikatragadda Questions by 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

Answer Question  Select Best Answer

kirangsv

 Profile Answers by kirangsv Questions by 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...

Answer Question  Select Best Answer

kirangsv

 Profile Answers by kirangsv Questions by 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

Answer Question  Select Best Answer

kirangsv

 Profile Answers by kirangsv Questions by 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...)...

Answer Question  Select Best Answer

In Oracle what is meant by 'Explain'

singh.neerajin

 Profile Answers by singh.neerajin Questions by 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...

Answer Question  Select Best Answer

satishorre

 Profile Answers by satishorre Questions by 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

Answer Question  Select Best Answer

AshaMahesh

 Profile Answers by AshaMahesh Questions by 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.

Answer Question  Select Best Answer

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

 Profile Answers by Imran_Javed Questions by 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

 Profile Answers by jamesravid Questions by 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';

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by 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

 Profile Answers by debasisdas Questions by debasisdas

• Jul 7th, 2007

SELECT COUNT(COLUMN_NAME) FROM DBA_TAB_COLUMNS WHERE table_name = 'TABLE_NAME' AND owner = 'OWNER_NAME' ;

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by 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.

Amritendra kumar

 Profile Answers by Amritendra kumar Questions by Amritendra kumar

• Feb 28th, 2008

It is connection string

Answer Question  Select Best Answer

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

 Profile Answers by Imran_Javed Questions by 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

xuqinglei2000

 Profile Answers by xuqinglei2000 Questions by xuqinglei2000

• Nov 21st, 2007

SELECT ROUND(13.19,-1) FROM DUALRETURN RESULT IS 10;

Answer Question  Select Best Answer

What is No Cache in Sequence?

venkat82.k

 Profile Answers by venkat82.k Questions by venkat82.k

• Apr 11th, 2008

Hi friendsCache is memory allocated to generate numbers in sequencemaximum size of cache is 20okkkkkkkkkk

Answer Question  Select Best Answer

basmgokul

 Profile Answers by basmgokul Questions by basmgokul

• Apr 3rd, 2008

Hi,Step 1: save your script as .sql format.Step 2: to run your script, follow thisSQL> @'pathname'assume your script db.sql was saved in c:datascript, thenex:SQL>@'c:datascriptdb.sql'

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 13th, 2008

To run scriptSQl> @ C:script.txt

Answer Question  Select Best Answer

sreekumar_nair_it

 Profile Answers by sreekumar_nair_it Questions by sreekumar_nair_it

• Mar 27th, 2008

Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse S...

fancyoracle

 Profile Answers by fancyoracle Questions by fancyoracle

• Aug 16th, 2007

Once parsed, the SQL statement is available in the memory till the session is valid.

Answer Question  Select Best Answer

WHat is Composite Primary Key?

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Mar 27th, 2008

Composite primary key used for multiple fields joined together to identify a records in a table. We can use maximum 16 columns for a composite primary key.

ddanda

 Profile Answers by ddanda Questions by ddanda

• Mar 24th, 2008

when 2 attributes of the table form a primary key .such a key is known as composite primary key.

Answer Question  Select Best Answer

How can we connect Oracle database with our C++ program. Explain with an example.

sarthak2175

 Profile Answers by sarthak2175 Questions by sarthak2175

• Mar 8th, 2008

Hi i fil u can use pro c to connect the data base to the front end data condition: database should b oracle ...

Answer Question  Select Best Answer

What will happen if you dont use Replace option in a Procedure when first creating it for first time?

garvi.1983

 Profile Answers by garvi.1983 Questions by garvi.1983

• Mar 5th, 2008

No problm. It successfully creates the procedure.But once it created ,if u modify it and compail without REPLACE ,it will give an error

karunakaradepu

 Profile Answers by karunakaradepu Questions by karunakaradepu

• Jan 29th, 2008

    Nothing happen, It will also be stored in database.       

Answer Question  Select Best Answer