G. Sreedhar

• Sep 26th, 2007

Actually there are several ways of importing the data from Excel files to Oracle database.1) Save the .xls file to .csv file and then by using TXT2SQL tool we can generate the code and execute the code in TOAD or SQL prompt.2) By using SQL*LOADER we can import the data from excel to oracle database.

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 26th, 2007

It can be some application interacting the oracle as a server/database. Forms, Toad etc.

Answer Question  Select Best Answer

Mohammed Abdul Afroze

• Sep 27th, 2007

Schema Belongs to the objects are as follows:Sql>Desc dba_objects

Answer Question  Select Best Answer

Mohammed Abdul Afroze

• Sep 27th, 2007

If a users is having the SYSDBA Privilege then he can be able to accesses the data dictionary views.

Chiranjeevi Manne

• Mar 30th, 2007

If scott has the privilege of "SELECT ANY DICTIONARY", then he could read the information in DICTIONARY views.

Answer Question  Select Best Answer

While developing sopping cart application we have to create a main catagory and the admin want facillity that he can add the unlimited number of subcatagories and the subcatagories again having unlimited number of subcatagories. So how to create catagory table to perform this tree like structure

Mohammed Sameer

• Nov 27th, 2007

Dude Remember!when its your first job you should say"It doesnt matter if you pay me less or more i believe with my good work I would get a handsome salary today or tomorrow and I am sure organisation ...

Gururaj

• Nov 30th, 2006

Well,It depends upon your company policies.I liked this figure 10000 so i demanded if ur company wants to pay more u r welcomed.and it depends on year exp.if ur exp then alwaz ask >  30% hike

Answer Question  Select Best Answer

madhupriya

• Nov 27th, 2007

Normalization is being applied for the database to reduce redundancy as in case of first normal for remove the redundant data from rows and in 2nd normal form it removes the redundant data vertically ...

Answer Question  Select Best Answer

sreekumar_nair_it

 Profile Answers by sreekumar_nair_it Questions by sreekumar_nair_it

• Dec 1st, 2007

Try thisCREATE OR REPLACE FUNCTION FIN2008.rowtocol( p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2AUTHID CURRENT_USER ASTYPE c_refcur IS REF CURSOR;lc_str VARCHAR2(4000)...

ora.nachs

 Profile Answers by ora.nachs Questions by ora.nachs

• Feb 5th, 2007

we can also do this by insert all statement.....INSERT ALLINTO sales_info VALUES (employee_id,week_id,sales_MON)INTO sales_info VALUES (employee_id,week_id,sales_TUE)INTO sales_info VALUES (employee_i...

Answer Question  Select Best Answer

amisha_me

 Profile Answers by amisha_me Questions by amisha_me

• Dec 27th, 2007

Only the size differs in nvarchar2 length is much more compare to varchar2

Answer Question  Select Best Answer

What is Upper and Lower Checkpoint?

What is the difference between Subquery and Corelated Subquery?Give some examples of each

How can I copy a table from one database instance to another database instance

napster.syed

 Profile Answers by napster.syed Questions by napster.syed

• Feb 27th, 2008

By using Db link

Answer Question  Select Best Answer

Explain how the cursor can become stuck between two items, resulting in a navigation trap.

How to load data onto db2 environment other than FTP