gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

Do as john said.... use any data migration tool you will get that

John Thomas Ambadan

• Nov 29th, 2006

If u want to migrate ur access database to oracle, u can use Oracle migration work bench for microsoft access.for more details refer oracle documentation.

Answer Question  Select Best Answer

Abbireddy Anil Kumar

• Dec 15th, 2006

set_block_property('blockname',orderby clause,'fieldname);

subasini sahu

• Nov 17th, 2006

Before we have to clear the Block,Then in Set_Block_Property put the where conditions value.Thanks ,Subasini.

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

TRY THISSELECT ENAME||' ' ' '||'S' FROM EMP:

Jos? Baptista

• Nov 19th, 2006

HiYou just need to do this: ename||'''||'s'.If ename := 'Scott', the output is Scott's.RegardsJos? Baptista 

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

NO YOU CANNOT WRITE A FUNCTION WITHOUT RETURNING A VALUE.IT SHOULD RETURN ATLEAST ONE VALUE.........WITH REGARDS,SHARAT

Pawan Ahuja

• Dec 9th, 2006

No, we can not write a function witout a functionRegardsPawan Ahuja

Answer Question  Select Best Answer

raghu

• Nov 22nd, 2006

Hii think u studied in sree nipuna technologies right..............

Subasini

• Nov 17th, 2006

Data base link is a Database object .Basically we use it when we require to connect to other user or any remote user from current user.Syntax for creation is Create database link link_name connect to&...

Answer Question  Select Best Answer

Abbireddy Anil Kumar

• Dec 15th, 2006

declareserch_item number;a number;b number;beginserch_item:=:emp.empno;b:=:system.cursor_record;first_record;a:=:system.cursor_record;for i in a..b-1 loopif srich_item=:emp.empno thenmessage('Employee No Already Exists')raise form_trigger_failre;elsenext_record;end if;end loop;end;

Anil Kumar

• Dec 12th, 2006

declarea number;beginfirst_record;a:=system.current_record;for i in a..system.current_record-1 loopchecking codeend loop;

Answer Question  Select Best Answer

Amanpreet Kaur

 Profile Answers by Amanpreet Kaur Questions by Amanpreet Kaur

• Feb 21st, 2007

One has to configure jdbc odbc driver in case of windows. and set the oracle variables and environment paths. java will be connected to oracle.

PurnaChandarrao

• Feb 13th, 2007

Hai First you have to create DSN name ; Control Panel--->Administrative Tools--->DatabaseSources(ODBC) And give new DSN name and configure with your Data base either it is Oracle 8i or Oracle 9i se...

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

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 16th, 2007

Hi taraldesai! Y Not?Here is the example Try thisALTER TABLE table_nameADD (column datatype DEFAULT expr);(or)ALTER TABEL table_nameMODIFY (column datatype DEFAULT expr)

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

Specify parameter there is nothing like you are asking..like alter system set default ... wrongalter system set sql_trace=TRUE;

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Aug 27th, 2007

Actually Oracle is made for query purpose not for FTS, and it obviously depends upon your requirements. In FTS oracle server process reads all the blocks concerned with the table and it is not so when...

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

Depends, if you want certain columns then why to query whole data. bcoz it involves more IO, network traffic and many other things

Answer Question  Select Best Answer

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 17th, 2007

One more point Bind variables are declared outside the pl/sql block whereas declare variables are declared with in the pl/sql block

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 18th, 2007

Bind variables are command line parameters.whereas declare variables are variables local variables declared with in the pl/sql code.scope of declare variables is within the procedure you can't use them outside of the pl/sql code. But bind variables are valid till the session is valid

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

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 18th, 2007

For ur second question,select * from   (select * from (select col1,col2,rownum as rank                   ...

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 18th, 2007

I would consider the following points,1. Identify how many variable should be returned by your pl/sql code. If it is only one go for functions else go for procedures.2. Fuctions can be used in ur sql queries whereas procedures can't be used.

Answer Question  Select Best Answer

dbashashi

 Profile Answers by dbashashi Questions by dbashashi

• Jul 14th, 2009

Select statement works in the same way as other querries. The result set is brought from the Datafile if not already in Buffer cache. As we are aware that Buffer cache works on LRU and MRU algorithm ...

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 12th, 2007

When a query is submitted by the user it comes to the sharedpool and it is processed by the library cache i.e. statement is parsed their,execution plan is prepared and data is retrived from the datafi...

Answer Question  Select Best Answer

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Feb 3rd, 2008

U have to use this gropu as a column by specifiying it in "doublequotes"

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Feb 1st, 2008

Hi,??? Send me mail if satisfied .Thanks.MadhupriyaSQL> create table string("group" varchar2(20),name varchar2(20));Table created.SQL> insert into string values('&group','&name');Enter value for gr...

Answer Question  Select Best Answer

nkrrish

 Profile Answers by nkrrish Questions by nkrrish

• Dec 30th, 2007

Drop user

sanjay Sawant

 Profile Answers by sanjay Sawant Questions by sanjay Sawant

• Dec 23rd, 2007

Drop user U/N cascade;

Answer Question  Select Best Answer

What is the difference between the tools and utilities in Oracle 9i?

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Sep 12th, 2008

Utility is something which comes along with software?where it is intended to help us to solve a particular purpose but tool is something which enable us to develop more delebrately we can say as helpful for innovative development.

jaladurgam3127

 Profile Answers by jaladurgam3127 Questions by jaladurgam3127

• Jun 25th, 2008

Utility cannot uninstall it is an inbuiltTool can uninstall

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

What is the command to print the time taken by a query

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Feb 13th, 2008

you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time..

karunakaradepu

 Profile Answers by karunakaradepu Questions by karunakaradepu

• Jan 29th, 2008

    If UR Q is  How TO PRINT A TIME:       SELECT TO_CHAR(SYSDATE,'HH:MI:SS') FROM DUAL;

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