shakthi

 Profile Answers by shakthi Questions by shakthi

• Jan 25th, 2007

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

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

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

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

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

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

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

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

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 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

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

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

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

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

Not sure about this, better we could try again with right samplesize in both the versions. Use DBMS_STATS.AUTO_SAMPLE_SIZE.ExecuteDBMS_STATS.GATHER_SCHEMA_STATS('SCOTT',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,GRANULARITY=>'ALL',CASCADE=>TRUE);

Jian Zhang

• Oct 22nd, 2006

Deafult Optimizer9i: CHOOSE10g: CBO

skumarpenugonda

 Profile Answers by skumarpenugonda Questions by skumarpenugonda

• Jul 7th, 2006

Hi,I just started reading 10g. What I came to know that there are many features added and w.r.t. statistics, below are the changes, or new features.1. AWR ( Automatics Work Load repository )...

Answer Question  Select Best Answer

sangeeta

• Oct 18th, 2006

The start with .. connect by clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts). It is also being used when an sql execution plan is explained.

Answer Question  Select Best Answer

dev

• Oct 17th, 2006

Thank u mamathi.developer

mamathi

• Oct 11th, 2006

MERGE INTO DestinationTable     USING SourceTable          ON SourceTable.ColumnX = DestinationTable.ColumnXWHEN MATCHED THEN...

Answer Question  Select Best Answer

Maria Antony Samy

• Oct 14th, 2006

Very Simple question! But should be explained a lot.Databse data is stored in data_file's of the databse. For every table's data some space from the data_files would be allocated. This space is known ...

Answer Question  Select Best Answer

senkumaar

 Profile Answers by senkumaar Questions by senkumaar

• Oct 12th, 2006

In MS-SQL server we can use likeINSERT INTO () VALUES CONVERT(VARCHAR,))ExampleINSERT INTO SEN_TEST(NAMEE) VALUES(CONVERT(VARCHAR,10))

senthilkumar

• Oct 12th, 2006

-MS SSQL Inserting integer values in to varchar columINSERT INTO (col1) VALUES(CONVERT(VARCHAR,10))

Answer Question  Select Best Answer

Musharraf Dabre

• Sep 19th, 2006

 Hi ,    any kind of oracle error ,go to this link::             http://ora-00904.ora-code.com/all.html

Answer Question  Select Best Answer