sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 23rd, 2009

select deptno,sum(sal) from emp                             ...

thumatinagaraju

• Oct 23rd, 2006

Hiin where condition we cann't use group function but having clause allows it, both r used 4 data restriction only.group by is used 4 grouping similar items.

Answer Question  Select Best Answer

Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.Data Manipulation Language: INSERT,UPDATE,DELETE,LOCK TABLE,EXPLAIN PLAN & SELECT.Transactional Control: COMMIT & ROLLBACKSession Control: ALTERSESSION & SET ROLESystem Control : ALTER SYSTEM.

gdurga

 Profile Answers by gdurga Questions by gdurga

• Jun 15th, 2009

DDL: Data Defintion LanguageDML: Data Manipulation LanguageTCL: Transaction Control LanguageDCL: Data Control Language

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

DDLDMLDCLTCLSELCT

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

Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

Select a.*, level from emp astart with mgr is nullconnect by mgr = prior empno

deva

• Sep 20th, 2006

connect by prior is used with the key word "level". Its used to get the records in the hierarchical manner. Eg   To get the empno of the employee who is working under manager. and the subordinates of this empno...and so on

Answer Question  Select Best Answer

INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

substr is used to get a part of given string,instr is used to search a charcter in the given string.select substr(ename,1,3) three_charename, instr(ename,'A',1) a_present_at from emp;

tarun1282

 Profile Answers by tarun1282 Questions by tarun1282

• Apr 27th, 2006

Substr is used to get a sub part of a string but instr is a function that returns the position of a specific character and also according to it's occurence in that string.

Answer Question  Select Best Answer

ROWID is a pseudo column attached to each row of a table. It is 18 character long, blockno, rownumber are the components of ROWID.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

rowid is a unique value assigned by system automatically when ever a insert statement gets successful.rowid contains the address of data file,data block, object id, rownumber

tarun1282

 Profile Answers by tarun1282 Questions by tarun1282

• Apr 27th, 2006

Rowid is a uniquely identified number to each row which is given by the oracle server automatically

Answer Question  Select Best Answer

The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE constraint/DISABLE constraint.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

Alter table modify constraint disable/enable

samiksc

 Profile Answers by samiksc Questions by samiksc

• Jan 19th, 2006

Alter table disable constraint unique(col1)

Answer Question  Select Best Answer

CYCLE specifies that the sequence continues to generate values after reaching either maximum or minimum value. After pan ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum.NO CYCLE specifies that the sequence cannot generate more values after reaching its maximum or minimum...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

No cycle:  after reaching to max val sequence will not give nextvalcycle     after reaching to max val sequence will restart with startwith option vlues

tarun1282

 Profile Answers by tarun1282 Questions by tarun1282

• Apr 27th, 2006

In a sequence if we use cycle:- the sequence will repeat after the last sequence number with the first sequence number.in a sequence if we use no cycle:-the sequence will not repeat and continue to upward state.

Answer Question  Select Best Answer

Vamseek

 Profile Answers by Vamseek Questions by Vamseek

• Nov 10th, 2006

SELECT * FROM (SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME LIKE 'TEST');Above query will give the result as TEST.If you dont want to use the table name directly in the query, you can create synonym for that table and can use that synonym in your query.-Vamsee

hs_kashyap

 Profile Answers by hs_kashyap Questions by hs_kashyap

• Apr 25th, 2006

SELECT * FROM (SELECT TABLENAME FROM USER_TABLES WHERE TABLENAME LIKE 'TEM_')Please make check the column name is TABLENAME or TABLE_NAME.

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 DBMS_OBFUSCATION_TOOLKIT  package provides the encryption of password.even DBA can not come to know what is the password, ofcouse he can reset  the new password.

opbang

 Profile Answers by opbang Questions by opbang

• Sep 22nd, 2006

use DBMS_OBFUSCATION_TOOLKIT package.see Oracle supplied pl/sql packages docs for more info

Answer Question  Select Best Answer