jvilango

 Profile Answers by jvilango Questions by jvilango

• Nov 9th, 2006

The purpose of Product_user_profile table of SYSTEM is to control users from executing SQL commands.  For example, if you dont want one of your users to execute DELETE fommand, this can be implemented in this table.

bhanushiva

 Profile Answers by bhanushiva Questions by bhanushiva

• Jan 20th, 2006

The PRODUCT_USER_PROFILE (PUP) table provides product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles.To create the PUP tableLog in...

Answer Question  Select Best Answer

Balaji

• Aug 5th, 2015

The way for accessing a remote object.

maqk

• Jan 2nd, 2006

What's the Difference between COM and DCOM?Obviously, the difference is that DCOM is distributed but COM is not. To be more precise, there are three main elements added to COM: The way for creating a ...

Answer Question  Select Best Answer

jagadishVarodia

• Apr 12th, 2006

For time being type below command at sql promptSQL>define_editor=viYou can add export EDITOR=vi in .profile and logou/login for permament changeHope this will solve it

Guna Sagar Challa

• Mar 27th, 2006

Hi,To set the editor for editing sql commands and PL/SQL code at the SQL*Plus (Unix: $sqlplus) enter the following command at ur sql prompt after logging indefine _editor = <path and file name of the exe for the new editor>Hope this solves ur probCheers,Guna Sagar Challa

Answer Question  Select Best Answer

dev

• Oct 11th, 2006

Hi,for every table it is giving the same answer like:SQL> select bytes from user_segments where segment_name='DEPT';     BYTES----------     65536why? I did compress on one table. eventhough it's giving same answer.Thanks in advance.

S.Madhu

• Mar 29th, 2006

 I have created a table in oracle 9i database. How can i know the storage prticulars of  a table  created in oracle database ?please give me the answer to my e-mail id.thank u

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

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

what harsha said is right.in addition to the above reports there are 3 more triggers1. VALIDATION TRIGGERS2.FORMAT TRIGGERS3.ACTION TRIGGERS

Harsha

• Jul 14th, 2006

Report Customization means taking the orginal oracle report and modifing ( changing layout, query- by adding some more field....) according the user requirement.There are 5 types of report triggers1)B...

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

raja

• Oct 10th, 2006

    SQL: 1.it is a language for communicating with the oracle server to access data 2.it is based on ANSI standered sql.3.can"t be abbreviated.4.uses fns to perform some formatting.5.do...

madhu sudhan rao

• Sep 18th, 2006

sql*plus is a tool ( interface ) where we enter sql commands, its just like an command line interface like doswereas sql is query language with which we communicate with the database.in order to communicate with the database we can do only with the query language

Answer Question  Select Best Answer

Neeraj

• Nov 7th, 2006

You can write the query in the following way.select max(sal)-min(sal) difference from emp;

Manikandan

• Sep 22nd, 2006

Select max(sal)-min(sal) as Difference from employee;

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

Amol Bawane

• Nov 15th, 2007

Yes we can use procedure in trigger...but not trigger in Procedure.ThanksAmol Bawane

Shailu

• Oct 6th, 2006

We can not use  trigger in procedure, but can call procedure in trigger. When u r  trigger code is  too lengthy then write procedure and call in trigger.e.gcreate  trigger <trig...

Answer Question  Select Best Answer

How do you send the output of your SQL* Plus session to a text operating system file

prateek2612

 Profile Answers by prateek2612 Questions by prateek2612

• May 15th, 2011

See spool command

lanka_satya

 Profile Answers by lanka_satya Questions by lanka_satya

• Jul 4th, 2008

well you want to see the output ina  text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spoo...

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

Used to avoide parsing three mode  shared, exclusive and similarcursor_sharing=need to set this parameter on session or system level. this can also affect bind picking

Answer Question  Select Best Answer

gpsaravanan202

 Profile Answers by gpsaravanan202 Questions by gpsaravanan202

• Dec 12th, 2007

The only difference between rownum and level pseudocolumn  isRownum is used to order the datas according to their ranks and it is used in inline views..Level pseudocolumn is used in hierarchial retrival of database.....

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

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

kumaresan.m

 Profile Answers by kumaresan.m Questions by kumaresan.m

• Sep 12th, 2006

high water mark is concerned with segments not with the datafilesafter analysing the segments, this query will give the hwm for the segmentselect (blocks-empty_blocks) HWM from dba_segments where segment_name=upper('name') and segment_owner=upper('name');

bhanushiva

 Profile Answers by bhanushiva Questions by bhanushiva

• Jan 19th, 2006

There is no single system table which contains the high water mark (HWM) for a table. A table's HWM can be calculated using the results from the following SQL statements: SELECT BLOCKS ...

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

Tarak Nath

• Apr 12th, 2006

Increasing the DBWN will not help ,because unless LGWR writes DBWN cannot write. Here the solution will be to decrease th e MTTR parameter  so that frequent check point takes place.

SURINDER KAPOOR

• Mar 26th, 2006

dbw0 The database writer writes modified blocks from the database buffer cache to the datafiles. Oracle Database allows a maximum of 20 database writer processes (DBW0-DBW9 and DBWa-DBWj). The initial...

Answer Question  Select Best Answer