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

A library is a collection of subprograms including user named procedures, functions and packages.

orazeb

 Profile Answers by orazeb Questions by orazeb

• Jul 11th, 2009

When some procedures, function are frequently used in your applications, you can create a library containing these functions or procedures, and call them from anyform, to avoid redundancy or writing t...

Answer Question  Select Best Answer

How to copy database from one machine to another machine in MYSQL? Explain with an example?

bagya

 Profile Answers by bagya Questions by bagya

• Jul 31st, 2009

Select * from information_schema.tables where TABLE_SCHEMA='test 'into outfile'D:backuptest_backup.sql';

soorajVs

 Profile Answers by soorajVs Questions by soorajVs

• Mar 6th, 2008

Make a dump of the database to be copied : mysqldump -u root -p --databases --opt MyDatabase > MyDatabase.sql
Copy MyDatabase.sql to the second machineImport the database to MysSQL server : mysql -u root -p < MyDatabase.sql

Answer Question  Select Best Answer

What is Inversion Key Entry?

skachalia

 Profile Answers by skachalia Questions by skachalia

• Aug 6th, 2009

A column or group of columns used to access data from the table very frequently and may not be unique but?are potential candidate for creating non-unique indexes on them are known as Inversion Entry key.Inversion Entry key is represented by IE notation.

Answer Question  Select Best Answer

Ravi Kanojiya

 Profile Answers by Ravi Kanojiya Questions by Ravi Kanojiya

• Aug 17th, 2009

If you are usin php myadmin, click Import->CSV using LOAD DATA->Fields terminated by-> here use "," at the place of ";"?

gtomar

 Profile Answers by gtomar Questions by gtomar

• Jul 28th, 2008

Hi,If you are using toad then you need to follow steps given below :-1. login to toad .2.Go to DBA < Data import/export < Sql data wizzard <Choose .csv file  (Browse from the saved location)< Finish3. upload data into desired table .Thanks,Gunjan

Answer Question  Select Best Answer

Query Record Groups NonQuery Record Groups State Record Groups

Push_22

 Profile Answers by Push_22 Questions by Push_22

• Sep 7th, 2009

Static Record groupsQuery Based Record GroupsNon-Query Based Record Groups

Answer Question  Select Best Answer

When users are not able to log onto database, What are all the probable reasons?

Arpit Narula

 Profile Answers by Arpit Narula Questions by Arpit Narula

• Sep 14th, 2009

1. Database server is not up.2. User not aware of the correct credentials.3. TNS entry is not proper.4. Some network problem.

Answer Question  Select Best Answer

Where are the Background processes logging information written to?

tykarthick

 Profile Answers by tykarthick Questions by tykarthick

• Oct 12th, 2009

The information about the background process are stored in alertlog file.

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

If your database is running slow from last 2 hrs.you can't wait for Statspack report generation. What will be your first step to handle the problem? Where can be the problem?

ramavenky

 Profile Answers by ramavenky Questions by ramavenky

• Feb 19th, 2010

Check for Buffer Cache SizeCheck For Poor SQL Query

kven_sat

 Profile Answers by kven_sat Questions by kven_sat

• Aug 8th, 2008

Remove unnecessary joins,? too much normalization can effect query to perform slow, excess use of cursors, indexes, procedures or temporary tables may effect on query to perform slow. If my answer is wrong please correct me

Answer Question  Select Best Answer

What is included in the schema of a relational model?

Deepaklathwal

 Profile Answers by Deepaklathwal Questions by Deepaklathwal

• Apr 20th, 2010

The overall design of a relational database model is called Relational schema.

Answer Question  Select Best Answer

Among the many databases available in the market which database is providing more user friendly behaviour and why?

maha_g3

 Profile Answers by maha_g3 Questions by maha_g3

• Jun 17th, 2010

MySql Database

Answer Question  Select Best Answer

Which functionality of a database creates alert log?

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

Server processes will create the alert logfile.

Answer Question  Select Best Answer

kollati

 Profile Answers by kollati Questions by kollati

• Apr 21st, 2011

What exactly you are looking for....you can delete?complete row in a table by using delete statement using where clause.you can make it null value in the attribute in a row.

Answer Question  Select Best Answer

kollati

 Profile Answers by kollati Questions by kollati

• Apr 21st, 2011

Balaji,If you are Good at Command line use SQL loaded to convert the data.IF you are GUI specialist use Toad..it's very easy.ThanksVenkat

nidhi sharma

• Aug 9th, 2007

Excel -> CSV -> OracleSave the Excel spreadsheet as file type 'CSV' (Comma-Separated Values). Transfer the .csv file to the Oracle server (usually HP Unix). Create the Oracle table, using the SQL CREA...

Answer Question  Select Best Answer

SELECT * FROM V$VERSION

Read Best Answer

Editorial / Best Answer

Answered by: Mohammed Abdul Afroze

• Sep 27th, 2007

---

To find the Oracle Version:

Sql>Select * from v$version;

Mohammed Abdul Afroze

• Sep 27th, 2007

To find the Oracle Version:Sql>Select * from v$version;

Improve Answer

Read Best Answer

Editorial / Best Answer

msvkrishna  

 Profile Answers by msvkrishna Questions by msvkrishna

• Member Since Feb-2009 | Feb 11th, 2009

---

Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.

msvkrishna

 Profile Answers by msvkrishna Questions by msvkrishna

• Feb 11th, 2009

Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.

Chiranjeevi Manne

• Mar 30th, 2007

Go for Replication using either Oracle Streams or Quest Shareplex

Improve Answer

Julius Cooper

 Profile Answers by Julius Cooper Questions by Julius Cooper

• May 30th, 2011

In an Oracle database, you use the BLOB (Binary Large Object) to perform an inline storage of a video or picture file.? Alternatively, you can use an externally-stored object in conjunction with the Oracle datatype "BFILE."

Answer Question  Select Best Answer

How to monitor the database ?Why shmmax and semaphore parameters are used whenever we are installing database on linux?

subrahmanyam pattapu

• Jul 20th, 2011

while installing oracle software this parameters we need to set kernel parameters of shmax, semosphere its is compatible with memory of o/s and oracle database memory. while installing oracle softwar...

ramanjidba

 Profile Answers by ramanjidba Questions by ramanjidba

• Feb 27th, 2011

Using the third party tool OEM we can monitor the database.

Answer Question  Select Best Answer

Azam

• Oct 24th, 2011

10 G supports grid computing, ASM (Automatic storage management) and Memory management. Oralce 10g is higher version of 9i , Oracle 10g has added a follwoing features Transparent Data Encryption A...

Ashwin Hegde

• Aug 20th, 2011

I is for Internet
g is for Grid Computing

Answer Question  Select Best Answer