The integrity constraints are stored in USER_CONSTRAINTS.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

User_constraints, dba_constraints, all_constraints

Answer Question  Select Best Answer

Kaliappan

• Mar 7th, 2007

SQL plus doesn't have engine with that. So the SQL commands will be executed at the database only.

Answer Question  Select Best Answer

Narender Reddy

• Jan 4th, 2006

In Oracle 9i instead of snapshot we can use meterialized views which can act as snapshot.Diff between view & snapshot is view is not a table its a virtual table to join one or more table or to pre...

prakash2906

 Profile Answers by prakash2906 Questions by prakash2906

• Dec 27th, 2005

A snapshot is a table that contains the     results of a query of one or more tables or views, often located on     a remote database.

Answer Question  Select Best Answer

Shankar

• Feb 24th, 2006

The startup of database depends on the nature of Oracle server :Incase Of Enterprise Server and Unix Environment :Go to Unix and type the following commands :sqldba lmode=yconnect internalstartupThis ...

rajat dey

• Feb 9th, 2006

in oracle 7.1.6 unix enviournmentsqldba lmode=y connect internelstatuporacle 7.3.4 and 8isvrmgrl connect internelstatupin 9isqlplus /nologconnect /as sysdbastartup u can use option like alter database openstartup mount /nomount

Answer Question  Select Best Answer

iasritesh

 Profile Answers by iasritesh Questions by iasritesh

• Jan 15th, 2007

Theta Joins  Theta joins are joins that use any of the comparison operators: Greater than, denoted by > Greater than or equal to, denoted by >= Less than, denoted by < Less than or ...

Answer Question  Select Best Answer

Nikhil_4_Oracle

• Mar 1st, 2007

--This code will insert a image into database   create or replace PROCEDURE INSERT_BLOB(filE_namE IN VARCHAR2,dir_name varchar2)IStmp number;f_lob     bfile;b_lob &n...

Answer Question  Select Best Answer

niteshaggarwal

 Profile Answers by niteshaggarwal Questions by niteshaggarwal

• Oct 20th, 2008

The ROWID of that row and the Data value on which that index is created will be inserted in index file. ROWID have row address, which will locate the row at the physical level and thus accessing of that value will be fast.

Answer Question  Select Best Answer

List all customer (user id, name, and e-mail), number of charging, total charging,number of transaction and total number of transaction value?If u have these tables:1- 'Credit_card'columns: credit_number,type,value,Customer_ID.2-'Coupon'columns: Coupon_number,value,password,Customer_ID3-'Customer'columns: Customer_ID,Fname,Mname,lname,E_mail,password,bdate,tot_trans,mobil_no,hom_no,ex_id_date,current_Balance.

friends_mukesh

 Profile Answers by friends_mukesh Questions by friends_mukesh

• Feb 19th, 2008

Hi, One of the solution is as follow: select cust.customer_id,fname,mname,lname,e_mail,credit.tot_credit+coupan.tot_coup no_of_recharge,credit.tot_credit_val+coupan.tot_coup_val tot_recharging,to...

Answer Question  Select Best Answer

In which section of a PL/SQL block is a user defined exception waste?

vishakha_jain81

 Profile Answers by vishakha_jain81 Questions by vishakha_jain81

• Aug 7th, 2008

In exception block

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Shivani Goel  

 Profile Answers by Shivani Goel Questions by Shivani Goel

• Member Since Jun-2009 | Jun 23rd, 2009

---

Integrity constraint is that which depend upon the parent and child relationship in which parent column have the primary constraint and child column have the foreign key constraint.
You cannot delete the any value from column that have foreign key constraint until you never delete its related primary key column value, that is a integrity constraint.
If you try to do this it will show you error related to integrity constraint.

Shivani Goel

 Profile Answers by Shivani Goel Questions by Shivani Goel

• Jun 23rd, 2009

Integrity constraint is that which depend upon the parent and child relationship in which parent column have the primary constraint and child column have the foreign key constraint. You cannot d...

Rossitza Kanovska

• Aug 9th, 2005

An integrity constraint is a rule that restricts the values in a database. There are six types: A NOT NULL constraint prohibits a database value from being null.  A unique constraint prohibi...

Improve Answer

Scott

• May 12th, 2005

By utilizing savepoints, you are able to rollback to a given point in your processing. An example of this would be: ... COMMIT;  INSERT UPDATE SAVEPOINT A  DELE...

Ratan

• Mar 25th, 2005

Savepoints are the temporary bookmarks. it is possible to rollback up to the named savepoint.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: rajesh

• Sep 14th, 2005

---

binary	Bigint	bit	Char	datetime
decimal	Float	image	Int	Money
nchar	Ntext	nvarchar	Numeric	Real
smalldatetime	smallint	smallmoney	sql_variant	sysname
text	timestamp	tinyint	varbinary	varchar
uniqueidentifier

these are the data types used in sql table

gdurga

 Profile Answers by gdurga Questions by gdurga

• Jun 15th, 2009

Dec(p,s), desimal(p,s), double precision, foat, int, inteager, real, smallint, numeric(p,s), number(p,s), char(size), varchar2(size), long, raw, long raw, date, timestamp, urowid(size), rowid, boolean, nchar(size) , nvarchar2(size), bfile, blob, clob, nclob...

rajesh

• Sep 14th, 2005

binaryBigintbitChardatetimedecimalFloatimageIntMoneyncharNtextnvarcharNumericRealsmalldatetimesmallintsmallmoneysql_variantsysnametexttimestamptinyintvarbinaryvarcharuniqueidentifierthese are the data types used in sql table

Improve Answer

G.D.S.Prasad

 Profile Answers by G.D.S.Prasad Questions by G.D.S.Prasad

• Jun 21st, 2008

VARCHAR2: Max Size=4000 bytesCHAR: Max Size=2000 bytesNUMBER(p,s): The precision p can range from 1 to 38.               &nbs...

Rama Krishna,Yerra

• Aug 2nd, 2006

The Max Size is upto 32.Thanks&RegdsRamki,TCS,Hyd

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

Alter table modify constraint < constraintname> disable/enableexamplealter table CONTACT_US modify constraint CONTACT_US_UK disable;

Mathivanan

• Jul 16th, 2005

Using enable/disable clause along with Alter command, we can activate/deactive constraints.  For example:  Alter table Empolyee disable constraint pk_EmpNumer

Answer Question  Select Best Answer

sushilsb

 Profile Answers by sushilsb Questions by sushilsb

• Jun 2nd, 2006

TOO_MANY_ROWSNO_DATA_FOUNDINVALID_CURSORSCURSOR_ALREADY_OPENDUP_VAL_ON_INDEX

koi.milgaya

• Jul 10th, 2005

I think WHEN_OTHERS is only OTHERS NO_DATA_FOUND  WHEN_OTHERS  TOO_MANY_ROWS  

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

NVLselect empno, ename, mgr, nvl(to_char(mgr),'no manager') from emp;

koi.milgaya

• Jul 10th, 2005

NVL or Decode

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

if index is create by primary key /unique key constraint thenby droping the constriant , the index will be droped automaticallyelsedrop index

koi.milgaya

• Jul 10th, 2005

Drop Index Indexname

Answer Question  Select Best Answer

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 31st, 2007

Hi Guys,A subquery is a SELECT statement that is embedded in a clause of another SQL statement, Called the parent statement.The subquery (inner query) returns a value that is used by the parent statem...

SaratKumar Puranam

• Oct 10th, 2005

Subqueries will be executed once for the entire parent statement.

Answer Question  Select Best Answer

YESTHA BAPNA

• Jul 31st, 2007

With scrollable cursors, you can move directly to the rows you want without having to FETCH every other row returned by the cursor. the rows of a table can be fetched many timesSequence is repeated each time FETCH statement is issued

Shreenivas

• Sep 22nd, 2005

A scrollable cursor, however, can move forward and backward, and can seek any desired record in the cursor.  Such operations are common in applications that present results sets in scrolling wind...

Answer Question  Select Best Answer

Sub query is a query whose return values are used in filtering conditions of the main query.

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 31st, 2007

Hi Guys,A subquery is a SELECT statement that is embedded in a clause of another SQL statement, Called the parent statement.The subquery (inner query) returns a value that is used by the parent statem...

SaratKumar Puranam

• Apr 10th, 2006

Subquery is the one which is executed once for the entire parent statement.

Answer Question  Select Best Answer