laxmidhar

• Sep 5th, 2007

When a prepare statement got executed the statement will be executed through the parser. The parer will check the all syntax. Then it will go to the database. If any wrong was found on the statement then it will return error message..

Answer Question  Select Best Answer

giridhar

• Nov 3rd, 2006

Generally oracle uses Cost_based optimisation. In this method it will calculate all the execution plans for the query to execute and chooses the best optimal plan. Sometimes we may know the best execu...

Tejaswini Mohanty

• Sep 12th, 2006

HINTS  are nothing but the comments used in a SQL statement to pass instructions to the Oracle optimizer.The optimizer uses these hints as suggestions for choosing an execution plan for the state...

Answer Question  Select Best Answer

Sandhya Rani

• Feb 16th, 2007

Hi Satish,Instead of creating a object what you mentioned above(x/y)*100., better to create an variable so that it will solve the problem as for as my knowledge goes.lets say1, object (x)2, object (y)create a varible naming (% of x & y)you will get the proper report.Thanks & RegardsCheers,Sandhya

Answer Question  Select Best Answer

lakshmi1

 Profile Answers by lakshmi1 Questions by lakshmi1

• Jan 5th, 2007

Hey staging area is just used for data cleansing. We dont load data to the target table in the staging area.

Answer Question  Select Best Answer

Rajesh S

• Aug 10th, 2007

This option provides a high level of integrity (WRITE inegrity) for data being updated, while providing no special protection for data only being read. Many tasks in several VSE images can open the ...

Answer Question  Select Best Answer

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Dec 24th, 2006

Hi,  I have checked ur query it's right. select power(2.5,3) from dual; it gives 15.625 right ans.thanks.

Answer Question  Select Best Answer

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Dec 24th, 2006

hi,  IN is used to pick one by one value from a list of values.Supports numbers,chars,dates.It is a special operator.  Exists: It is also a special operator but it returns a BOOLEAN value.

Answer Question  Select Best Answer

Mohit Sethi

• Jan 31st, 2007

Data Pool basically explains key terminologies involved and how data are grouped into "messages", and the different classes or subclasses and "levels" within this organization.

Answer Question  Select Best Answer

shivaleela

• Jan 30th, 2007

i thk it requires 14 joiner,bcoz as per d rule 4 N table to joine v required (N-1) joins

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

Innila

 Profile Answers by Innila Questions by Innila

• Aug 13th, 2007

Hi rajapantula,Do u mean 'concatenate 2 columns' ?*** Innila ***

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

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

nareshgoradara

 Profile Answers by nareshgoradara Questions by nareshgoradara

• May 25th, 2009

Just write N' before value, eg.insert into YourtableName values ( N' हिंदी अनुवाद')

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

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 the difference between Case and Decode?In what situation we can use Case and Decode

veerisetty

 Profile Answers by veerisetty Questions by veerisetty

• Jun 18th, 2008

DECODE works with expressions which are scalar values.CASE can work with predicates and subqueries in searchable form:CASE is an ANSI standard, where as Decode is proprietary for OracleWe can use expressions as part of case statements, where as Decode looks for a value.regardsveerisetty

Answer Question  Select Best Answer

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

Which one is strongest normal form? Why?

kumaranvp

 Profile Answers by kumaranvp Questions by kumaranvp

• Jul 12th, 2008

Boyce codd normal form is the strongest normal form.........

Answer Question  Select Best Answer

If 1000 users are connected to the db, and Listener is up and running suddenly system is hanging what will do ?

tykarthick

 Profile Answers by tykarthick Questions by tykarthick

• Oct 15th, 2009

In real time environment if a DB goes hang or degrades automatically the DB is allocated to next available instance. This is known as RAC i.e Real Application Cluster.

Answer Question  Select Best Answer