thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 23rd, 2006

Nice reply sir

dmadhusudhanarao

 Profile Answers by dmadhusudhanarao Questions by dmadhusudhanarao

• Aug 2nd, 2006

good question.remember... you are doing huge work. means assume that you have execute 100 queties. ok . you already finished 50 queries. after executing the 51 query you thaught there is a mistic. wha...

Answer Question  Select Best Answer

bhargav

• Nov 27th, 2006

        To calculate number of hours ...          1) we have to find out difference between date, base on number of hour...

Dhaval

• Nov 14th, 2006

Select Count(*) , DATEPART ( hh , sellbooksdate) From bookssellWhere sellbooksdate = '14 Nov 2006'Group By DATEPART ( hh , sellbooksdate)

Answer Question  Select Best Answer

bhargav

• Nov 29th, 2006

          Self joints : joining a single table by itself using its instance as another table is called as self joint.      &n...

Lalita.p

• Sep 18th, 2006

Self join requires two or more tables. but the two tables are not Necessarily different tables.u can take one table and other table is the instance of the first table .and can implement self join concept on these tables.

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

use these steps.1 modify init.ora   add a line         UTL_FILE_DIR='D:My_DIR'2. login as system as sysdba        shutdo...

dev

• Oct 17th, 2006

Hi Maria Antony,Thanks for the reply.I tried by giving UTL_FILE_DIR='D:' in the init.ora.71720061376 file.but still it's having the same error.please let me know the solution.Thanks in advance.Developer.

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

use this query:delete from emp ewhere rowid  ( select max(rowid) from  empwhere ename = e.ename );

Anjali

• Aug 23rd, 2006

Abhishek, I think in the group by clause u need to add all the field names, so as to make sure the records are exactly same.Anjali

Answer Question  Select Best Answer

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Dec 10th, 2006

Try this query select trunc(sysdate) today, hiredate, to_char(trunc(months_between(sysdate,hiredate)/12)) || ' years ' || to_char(mod(trunc(months_between(sysdate,hiredate)),12)) || ' months ' || to_c...

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

what is cursor ?how many type?what is the diffrence ?what is exception?diffrence between function & procedurelike wise you can prepare your own questions.

Answer Question  Select Best Answer

No, a cursor variable points a row which cannot be stored in a two-dimensional PL/SQL table.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

No you can not store the cursor variable into pl/sql tablebut yes the out put or cursor variable can be stored how:set serveroutput ondeclaretype v_table is table of emp%rowtype index by binary_intege...

Answer Question  Select Best Answer

Ramprasad

• Dec 14th, 2006

Hi,Through Copy command in SQL will copy a table with Data like a normal COPY command in MS-DOS.In SQL, CREATE statement will provide flexibility to copy complete structure or...

Answer Question  Select Best Answer

ashok rajagopal

• Dec 14th, 2006

This is how the index works in simple terms. When you add a row to a table, the rowid of that row plus a few other info is store in a separate area which is dedicated to keep it.  Lets say you de...

sibgatullah

• Dec 13th, 2006

Effective use of index will speed up your query execution time.

Answer Question  Select Best Answer

Nasim

• Dec 19th, 2006

Maximum we can write 28 triggres on table3 -> insert, update and delete4 -> combination of insert, update and delete2 -> trigger type (for each row and statement)2 -> trigger event (before and after)(3+4)*2*2 = 28

Girdhar Singh

• Aug 22nd, 2006

  total 12 trigger we created but we write trigger how much we want

Answer Question  Select Best Answer

shailendra nigam

• Jan 4th, 2007

hii am shailendraits my opinionoracle is based on RDBMS. its follow the 10-11 rules in Dr. E.F.Codd  but SQL Server is based on RDBMS. its follow the only 7-9 rules in Dr. E.F.Codd.

Manivannan Palanichamy

• Aug 24th, 2006

SQL - A RDBMS language, is ANSI std.Oracle - a database vendor/database server, which can run across multiple operating system, has number features than any other databases, which is hot in marke...

Answer Question  Select Best Answer

sharib

• Jan 11th, 2007

I think you are wrong.we can write dml in both function and procedure.

Manish

• Nov 23rd, 2006

1. SP can not return the table datatype whereas function can return.2. in UDFunction if one sql statement raise the error then whole function is terminated where in SP if one sql statement raise the error then other sql statement can be executed.

Answer Question  Select Best Answer

shakthi

 Profile Answers by shakthi Questions by shakthi

• Jan 25th, 2007

Clear screen.... cl scr.... clear scr..... cl screen

Answer Question  Select Best Answer

Ajay Nerumati

 Profile Answers by Ajay Nerumati Questions by Ajay Nerumati

• Jan 29th, 2007

Hi All,A Schema in oracle is a logical representation of all the Oracle objects owned by a user.To make my explanation simpe , let me give an example.Let's say you own a bike, a computer, mobile. Now ...

JKreddy

• Jan 24th, 2007

HI all.. To create/update schema one should have SYSADMIN privilages.. ie high level system admin privilages, And these privilages are also necessary for editing the DUAL table in the DB.. thx and regard's jk.m.reddy

Answer Question  Select Best Answer

Gurwinder Singh Saini

• Feb 15th, 2007

SQL> select * from pn;COL1 COL2 COL3 COL4----- ----- ----- -----a b c dSQL> update pn set col4=col1, col1=col2, col2=col3, col3=col4 ;1 row upda...

Answer Question  Select Best Answer

narendra

• Feb 16th, 2007

Rollup Note: ROLLUP enables a SELECT statement to calculate multiple levels of subtotals across a specified group of dimensions. It also calculates a grand total. ROLLUP is a simple extension to the G...

satyanarayana

• Apr 5th, 2006

What is the function we can use for cummilative to.tal function

Answer Question  Select Best Answer

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 18th, 2007

Tables once dropped are permanently removed from database and hence they are stored no where in database.

Radhi09

• Feb 15th, 2007

HiAs of now i dont think there is any thing of that sort in oracle 9i ,but 10g provides the option of flash backthanks

Answer Question  Select Best Answer

Sujata Bisoi

• Mar 8th, 2007

 i think it will perfectly work:-            delete empname from emp A where  rowid > (select min(rowid) from emp B where A.ename = B.ename);

Pawan Ahuja

• Dec 3rd, 2006

Delete from where rowid not in (select min(rowid) from group by col1,col2....)RegardsPawan Ahuja

Answer Question  Select Best Answer

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Mar 8th, 2007

Subquery allowed that depends on no of values returned by sub queryyes :-)

Nikhil_4_Oracle

• Mar 8th, 2007

HI ALL,update statement in SET clause subquery is allowed ,Try this ,update emp set sal=(select sal from emp where empno=7900)where deptno=20Bye,Nikhil.

Answer Question  Select Best Answer