singh.mandeep

 Profile Answers by singh.mandeep Questions by singh.mandeep

• Jun 27th, 2007

Yes the table can have primary key as well as unique constraint in a table.a table can only have a single primary key were as it can have more than one unique key

Answer Question  Select Best Answer

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 17th, 2007

That is background processes because SGA is the memory area allocated during instance startup.

Answer Question  Select Best Answer

rajeshasha

 Profile Answers by rajeshasha Questions by rajeshasha

• Jul 4th, 2008

First of all this is a convention.Second thing is that if they start writing as varchar1 people will be confused this with char so they named it like this.

Answer Question  Select Best Answer

vijay_orcl

 Profile Answers by vijay_orcl Questions by vijay_orcl

• Jan 30th, 2008

you can use HOST commend.for examplehost('md c:vijay');it will create vijay directory on c drive. 

Answer Question  Select Best Answer

Find it imm...

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 12th, 2007

For the machine point of view data is stored in binary format.But if we say from database point of view it is stored in unicode format.

Answer Question  Select Best Answer

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 12th, 2007

It is not necessary if your database is running in archivelog mode i.e. automatic archiving is enabled.

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

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 17th, 2007

Use synonym when a table name or view name is too long, and if u want to give access permission of your table or view is accessed by all users (i.e. PUBLIC).

Answer Question  Select Best Answer

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 17th, 2007

1. float 2. decimal 3. double precision 4. int 5. integer 6. numeric 7. real 8. smallint

Answer Question  Select Best Answer

kumar1974

 Profile Answers by kumar1974 Questions by kumar1974

• Jan 23rd, 2008

I think MIS means Management Information Systems.

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

rajakumar_na

• Nov 6th, 2007

If group of columns or column which uniquely identifies each and every record of a table is called candidate key. Candidate key other than primary key is called alternate key.

Answer Question  Select Best Answer

rajakumar_na

• Nov 6th, 2007

Using SQLERRM, and SQLCODE functions we can find the error message related to the SQL Error code.

Answer Question  Select Best Answer

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 11th, 2007

In table level constraints, a single constraint can be created on more than one columns but it is not possible in case of column level constraints.A table level column can be created after the creation of the table without altering the column definitions.

Answer Question  Select Best Answer

Is there any way to import the excel data in to oracle database without using the SQL loader, please let me know.

xuqinglei2000

 Profile Answers by xuqinglei2000 Questions by xuqinglei2000

• Nov 21st, 2007

Well,if you have less data ,you can just copy the data; for exampleselect * from table for update then open the lock, then copy  the data from excel to the database;

Answer Question  Select Best Answer

xuqinglei2000

 Profile Answers by xuqinglei2000 Questions by xuqinglei2000

• Nov 21st, 2007

ALTER SYSTEM SET SHARED_POOL_SIZE=.....

Answer Question  Select Best Answer

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 10th, 2007

If the database is running in archivelog mode then perform time-based recovery to recover the table.

Answer Question  Select Best Answer

Can anyone please tell me what are the advanced features in 10g when compared to 9i

kumar1974

 Profile Answers by kumar1974 Questions by kumar1974

• Jan 23rd, 2008

Oracle 10g features are 1) Sys Aux Tablespace 2) ASM3) New Flash Recovery Area 4) CTWR (Change Tracking Writer) This is background process which writes the block change information to the change tracking file. 5) Server Manageability Components6) Unified Job Schedular etc

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 is the function BASECONV.CONVDATA(FILED_01,ARG_1,ARG_2) used for ?

nagarjuna

• May 2nd, 2014

Baseconv.convdata is the conversion of some encrypted data to numeric data. the conversion values depends on the arguments u are passing for the function

Answer Question  Select Best Answer