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

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

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

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

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

select .nextval from dual;select .currval from dual;orselect * from user_sequences where sequence_name = ;here last_number is your currval and last_number + increment_by is your nextval

kishorebabukm

 Profile Answers by kishorebabukm Questions by kishorebabukm

• Sep 20th, 2005

I would like to give you a small example to use the sequence.currval and sequence.nextvalcreate sequence seq_name start with 1minvalue 1 maxvalue 999 increment by 1 nocycleinsert into table_name (sno,name) values (seqname.nextval,'abc');select seqname.currval from dual

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

sorting mean puting the value in a particular order , could by alhphabaticgouping mean making a group of same type of values and displaying a single row for that groupexample select deptno, sum(sal)&n...

ravi wadalkar

• Jan 2nd, 2006

sorry to say,sorting will not give distinct values, but will just sort the data depending on asceding[default]or desc. group by will group the data depending upon the distinct values with in a column by which we are grouping

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

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

pratyush

• Oct 22nd, 2006

in cases where a very small table is being joind to large table ,the oracle hash join will often dramatically speedup the querry hash join are for faster than nested loops join same cashes.regards pratyush singh

anu_dw

 Profile Answers by anu_dw Questions by anu_dw

• Sep 25th, 2006

The Hash join will be used, if there are no adequate indexes on the joined columns. This is a worst situation. In this case, hash table will be created. Hash join is most efficient when one of the tables is significantly differ in size than another one.Regards,Anu

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

tnsnames.ora is used to connect to the remote db. To get the connection listener.ora should be configured at the server and it should be up and running.

deva

• Sep 20th, 2006

Listener is used to get the client server communication. U can access ur server only if the listerner is ON

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

Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.

RamPrasad K

• Jun 12th, 2006

Hi,Yes,We can use current and next values from a sequence.-Regards,

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

I don no

Ramprasad K

• May 30th, 2006

Hi,Implementing a project from the begining to the production and maintenance stage.(1) System Planning:        (Scope & Budget of the Project)(2) Business Analy...

Answer Question  Select Best Answer

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• May 11th, 2006

Nextval must be used to generate a sequence number in the current user's session before currval can be referenced.

Shasi

• Jan 8th, 2006

You can find the last number used in the session for your sequence from the below mentioned queryselect last_number from user_sequences where sequence_name =

Answer Question  Select Best Answer

Using ROWID.CONSTRAINTS

tarun1282

 Profile Answers by tarun1282 Questions by tarun1282

• Apr 27th, 2006

By using the index and rowid

Answer Question  Select Best Answer

Database Link is a named path through which a remote database can be accessed.

tarun1282

 Profile Answers by tarun1282 Questions by tarun1282

• Apr 27th, 2006

When u want to access the database from remote database then u hv to create a database link with creating a directory .

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

Integrity constraint is a rule that restricts values to a column in a table.

samiksc

 Profile Answers by samiksc Questions by samiksc

• Jan 19th, 2006

Integrity constraint restricts values of a column so that only meaningful values as per the business logic of the table be entered into the column.Integrity constraints are of the following types:Not ...

Answer Question  Select Best Answer