sanch167

 Profile Answers by sanch167 Questions by sanch167

• Dec 29th, 2010

A view on a single table can be modified, however the same cannot be done on multiple tables.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 if a view based on one table or multiple table matter is it should contain all not null columns and additionaly no calculated column then ant DML statement will cause changes in base table.

Answer Question  Select Best Answer

thirupathi

• Sep 24th, 2007

Explicit & Implicit crusors have same attributes.

kashan

• May 28th, 2006

hai,          plz help me about coursor in sql quries 

Answer Question  Select Best Answer

Haraprasad

 Profile Answers by Haraprasad Questions by Haraprasad

• Nov 3rd, 2008

SQL%ISOPEN exists. Oracle always evaluates this to FALSE as PL/SQL closes implicit cursors immediately after they are executed.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

sql%isopen is there but it will always return "false" for implicit cursor

Answer Question  Select Best Answer

Neelkanth

• Sep 21st, 2006

There are only three tablespaces as follows:-1.Permanent tablespace2.Undo tablespace3.Temperory tablespace

na123

 Profile Answers by na123 Questions by na123

• Mar 24th, 2006

A tablespace is a collection of one or more datafiles.all database objects are stored in tablespaces.diff types of tablespaces:-1)system tablespace.2)temp tablespace.3)tools tablespace4)users tablespace.5)rollback tablespace.6)data and index tablespace.

Answer Question  Select Best Answer

aditi

• Oct 16th, 2007

UNION : It is a set operator which retrives all the matching records from two different tables and eliminates the duplicate rows.OUTER JOIN: It is used to retrive lacking records from one table agains...

suresh

• Oct 21st, 2005

UNION is a set operator which combines the result set of one query with that of the otherOUTER JOIN is a type of join which gives both the matching and unmatching in the table specified in the left si...

Answer Question  Select Best Answer

Correlated sub query is a sub query which has reference to the main query.

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 31st, 2007

Hi Guys,The Oracle Server performs a correlated subquery when the subquery references a column from a table reffered to in the parent statement. A correlated subquery is evaluated once for each row pr...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

when a sub query executes for each row its called a corelated sub query, in other words when a sub query takes the input from outer query for executation then execute and passes the result to outer query then outer query executes.

Answer Question  Select Best Answer

When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.

bhawesh

• Jul 17th, 2007

Does not consider parent-child relationship.On deletion of parent record child records are deleated automatically but vise versa is'nt true

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

for deleteing master record with out deleteing the child records on delete cascade is used.  in this case when ever master record is deleted all the child record will be deleted automatically.

Answer Question  Select Best Answer

vijaya

• Jan 10th, 2006

If DEFINE is isqlplus command then how do u define ACCEPT command. what is difference between them?i think define is a command in sql *plus which works same in isqlplus with ACCEPT.pls do forward the argument.

marthand

• Dec 27th, 2005

define is not a sql commanddefine is Isql*plus command.  to give a global variable we use it

Answer Question  Select Best Answer

joshmohit

 Profile Answers by joshmohit Questions by joshmohit

• Oct 26th, 2010

Commit;commit work;commit work 'comment';rollback;rollback work;rollback to savepoint ;

narendra kumar

• Dec 6th, 2006

COMMIT:it is used to make the manipulations ENABLE permanently on the table where as ROLLBACK is used to DISABLE the effect of the queries(which were typed a bit above it) on ...

Answer Question  Select Best Answer

Answered by Scott on 2005-05-12 10:18:34: Constraints are found under the USER_CONSTRAINTS table.

amol shinde

• Apr 15th, 2016

Constraints are stored in data dictionary

Rahul B

 Profile Answers by Rahul B Questions by Rahul B

• Jun 25th, 2007

Correction to some answers aboveUser_Constraints is a view and not a table

Answer Question  Select Best Answer

pratima

• Dec 26th, 2006

Hi Rampratap, U r telling abt the efficiency of view @ mutating table concept. can u pls explain it with an example?Thanks Pratima

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

The advantages of View are:security:  only selected column from a table made available to view.Complaxity: write a complex query and assign this query to a view so next time no need to write that...

Answer Question  Select Best Answer

sravee123

 Profile Answers by sravee123 Questions by sravee123

• Jun 17th, 2008

Select ROWNUM, col1, col2 from tablename;

Dr. Codd

 Profile Answers by Dr. Codd Questions by Dr. Codd

• Jun 16th, 2008

SELECT ROWNUM,table_name.* FROM table_name;

Answer Question  Select Best Answer

Answer posted by Scott on 2005-05-25 18:41:26: From the SQL> prompt, type the following:  select * from v$version;

emraan

 Profile Answers by emraan Questions by emraan

• Dec 29th, 2009

      select * from v$version

deepakonroll

 Profile Answers by deepakonroll Questions by deepakonroll

• Dec 26th, 2007

Just type define on your sql prompt ..you will get required info..

Answer Question  Select Best Answer

gdurga

 Profile Answers by gdurga Questions by gdurga

• Jun 18th, 2009

1. DDL: Data Definition Language2. DML: Data Manipulation Language3. TCL: Transaction Control Language4. DCL: Data Control Language5. DQL: Data Query Language

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

                                 &n...

Answer Question  Select Best Answer

CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

Shambhu Kumar

 Profile Answers by Shambhu Kumar Questions by Shambhu Kumar

• May 7th, 2008

The break keyword halts the execution of the current loop and forces control out of the loop. The continue is similar to break, except that instead of halting the execution of the loop, it starts the next iteration.

Shambhu Kumar

 Profile Answers by Shambhu Kumar Questions by Shambhu Kumar

• May 7th, 2008

The break keyword halts the execution of the current loop and forces control out of the loop. The continue is similar to break, except that instead of halting the execution of the loop, it starts the next iteration.

Answer Question  Select Best Answer

It won't, Because SYSDATE format contains time attached with it.

Ashima Chhabra

• Jun 20th, 2015

No...you can save a single row with the sysdate but not more than 1 on same date because format of date is YYYY-MM-DD and format of datetime is YYYY-MM-DD hh:mm:ss[.nnn] and format of smalldatetime is YYYY-MM-DD hh:mm:ss

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

yes with unique constraint on date column we can have same date becuase internally date is stored as  dd-mon-yyyy hh:mi:ss

Answer Question  Select Best Answer

sandeep dasari

• Jul 6th, 2006

by using alter table we can alter only column not the rows. by using alter  command we write query like this........alter table table_name add column_name datatype;for drop that column ;alter table table_name  drop column_name datatype;it's the answer.

Abdul Mannan

• May 28th, 2006

To insert a column in a table dml command should be used i.e., INSERT. A column cannot inserted in a table through ALTER command - only the data in a table is modified thru alter.

Answer Question  Select Best Answer

raghav_sy

 Profile Answers by raghav_sy Questions by raghav_sy

• Jan 24th, 2007

hi,some additions to Ram pratap answer:There are actually two types of triggers: DATABASE and APPLICATION triggers.Database triggers are of three types:1)DML trigeers: we can have a total of 12 DML t...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

cascading is used where primary/foreign key relation:by using cascade we can delete child record or can be set to null or default values

Answer Question  Select Best Answer

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

Multiple transaction can be controlled by three ways:1. COMMIT       : Make changes done in  transaction permanent.2. ROLLBACK  : Rollbacks the state of da...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

Use savepoint after each DML statement. If using procedure/function then do not give commit in them. commit in proc/function will erase your savepoints.

Answer Question  Select Best Answer

sandip01

 Profile Answers by sandip01 Questions by sandip01

• May 25th, 2010

ROWID is internally constructed when a new row is added.BBBBBB.RRRRRR.FFFFFFBBBBBB - Represents the blocks in the datafile.RRRRRR - Represents the rows in the block.FFFFFF - Represents the file no.

imtiazali

 Profile Answers by imtiazali Questions by imtiazali

• Jun 5th, 2009

Rowid and Rownum are psuedocolumns for every table Oracle provides unique rowid, rownum.Rowid are in alphanumeric, rowid are 18 character, for every rowid last 3 character will be changed.

Answer Question  Select Best Answer