The programmer may like the database o take some action when a database event occurs. In order to achieve the above purpose triggers are defined. The trigger body refers to the code written within the trigger which gets fired and executed when the related database event associated with the trigger occurs. On this situation one may have the question what is the event on the happening of which triggers...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

 trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures.Triggers are implicitly fired by Oracle when a triggering event occ...

Answer Question  Select Best Answer

Truncate command will delete all records and the most important thing to make note of truncate command is since truncate command cannot be rolled back one must make sure to take proper backup of table data before performing the truncate command. Truncate command is thus used to remove all rows from either a table or a cluster. If one wants to use the truncate command in a cluster they can use it only...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

* Used to Delete all the datas in a table .* Cannot be rollbacked.

Answer Question  Select Best Answer

sulakshana

• Jan 16th, 2007

Try out with adopendynamic,adlockoptimistic.Also try it by  givingselect distinct(column_name) from table_namedo replyThanks and regards

Chandra

• Mar 18th, 2006

In this case record set is open  in adOpenForward and adLockreadonlyor (by removing the loaktype or open mode)rs.Open CadSql, Cnn

Answer Question  Select Best Answer

Praveen reddy.P

• Jan 31st, 2007

HiTo improve the performance of a Query, The following are the steps to be followed.1) First Check the Elapsced time of the Query2) Then see the optimization mode 3) Run the query in different optimiz...

Answer Question  Select Best Answer

seema

• Feb 8th, 2007

Both commands are same but each is executed at different situations.When we directly want database should come in mount stage we give startup mount and when we want to do some modifications at nomount stage then first we nomount the database then give alter database mount command

Answer Question  Select Best Answer

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

New Features of 10g1. Regular Expressions2. Flashback dropped table3. Can send mail using UTL_MAIL4. Datapump utility instead of export and import5. Comparision of nested table6. Sql Tuning advisor9....

Answer Question  Select Best Answer

Neelkanth

• Feb 16th, 2007

Change the settings, i.e. change the color to 32bits and screen area to 1024*768 pixelit will work.

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

suresh

• Mar 7th, 2007

you can create a a plan_table, by searching in the oracle folder of c drive in ur computer. look for the file utlxplan which usually resides in c:oracleora92rdbmsadmin. where u can get the script and ...

Answer Question  Select Best Answer

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Mar 16th, 2007

Alter session set nls_date_format ='new_date_ format';or use to_date functions

Answer Question  Select Best Answer

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Mar 16th, 2007

Delete from empwhere empno in ( select empno from emp where rownum <=4)

Answer Question  Select Best Answer

You can also use tnsping utility on command prompt to check Oracle Net connectivity. Follow these steps to check the connection to particular SID.Open Command prompt.Write tnsping < SID for the database connectivity you want to check >If you get the message “Used TNSNAMES adapter to resolve the alias” then tnsping utility is able to resolve the service name.If you get “TNS-03505: Failed to resolve...

Chiranjeevi Manne

• Mar 30th, 2007

TNSPING is an Oracle network utility which checks for connectivity of a remote database.

kmkumar24

 Profile Answers by kmkumar24 Questions by kmkumar24

• Mar 29th, 2007

The TNSPING which helps to findout whether we have the connectivity to the particular database. It can be accessed from the dos prompt with either database name or with IP address.If it ping with that...

Answer Question  Select Best Answer

Guest

• Apr 12th, 2007

Hi,If you are using SQL server then you have an in-built option in the SQL Server itself. You can read xml in db through stored procedures.sp_xml_preparedocument - search for this option in sql server.

Elango

• Jun 23rd, 2006

Hi,There are couple of ways to do it other than loader.1) You can load the file into a clob and make use of the sys.xmlparser and sys.xslprocessor packages to load it to files.2) You can load the file...

Answer Question  Select Best Answer

matvin

• Apr 20th, 2007

Pre-query trigger fires before the query excutes and fires once while you try to query. With the help of this trigger you can modify the where clause part dynamically. Post-query fires after query exc...

Answer Question  Select Best Answer

Nagi

• Apr 27th, 2007

1. PL/SQL developer by Allround automations2. TOAD by Quest Software

Answer Question  Select Best Answer

pkjayan

 Profile Answers by pkjayan Questions by pkjayan

• Apr 29th, 2007

Instance is the memory structures and background processes used to interact with Database.Instance = SGA + Background ProcessDatabase is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and Redo-Log fileS(minimum 2).  

Answer Question  Select Best Answer

A view is nothing but a window of an existing table by which one can view and can also change the values in tables. The main point aspect of view is views have no storage space. For this reason views are also called as virtual tables. Thus in other words a view is a database object that gives a logical representation of one or more database tables.
As we have seen above views have no data for...

aardvax

 Profile Answers by aardvax Questions by aardvax

• May 17th, 2007

Please clarifythat if there are some changes made in view(created from a single  base table)would they reflect in the base table as well?

rayadurgamsudha

 Profile Answers by rayadurgamsudha Questions by rayadurgamsudha

• Mar 11th, 2007

A view acts like a mirror of the main table created. any changes made in the base table are seen in the view while changes made in the view cannot be seen in the base table except if the view is on a ...

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

You write a trigger on some table and in that trigger code if you access the same table, then it generate this error. To avoide, use views or call procedure from trigger.. bcoz your table is in between modification mode (mutating mode) and you are accessing it...it generates this error.

Answer Question  Select Best Answer

8060

Jaya

• May 29th, 2007

Hi,Rowsize depends up on the no of columns and their size , you can calculate the avg row size using vsize? and maximum we can have 1000 col in table.

Answer Question  Select Best Answer

sisindia

• Jun 7th, 2007

hi to all sql loversthe answer is-unable to create initial extent for segment in such table spacefailed to find sufficient contiguous space to allocate initial extent for segment being createduse ALTE...

madhu sudhan rao

• Sep 18th, 2006

Create table privilege is not grantedin order to grant create table privilege, connect to sys/manager and then type grant create table to

Answer Question  Select Best Answer