Yes

swapna

• Mar 28th, 2007

Yes. In such case you don’t need to specify any value and the actual parameter will take the default value provided in the function definition

Answer Question  Select Best Answer

Drop Procedure procedure_nameDrop Function function_name

kumars77

 Profile Answers by kumars77 Questions by kumars77

• Apr 24th, 2008

Absolutely it will work

Answer Question  Select Best Answer

jahid

• Mar 24th, 2007

You can use view "user_tab_columns". in this view you will get. In this you will get table_name, column_name, datatype and all things..select * from user_tab_columns;

Answer Question  Select Best Answer

SIVA

• May 25th, 2007

We can't?select?next value and current value?from views.

Answer Question  Select Best Answer

Lovely Gahlawat

• Jul 27th, 2007

Reverse -key index is index that reverse the data of the being indexed column. For example if the column value contains LOVELY, the reverse-key index will be YLEVOL.This index very much useful where u...

Answer Question  Select Best Answer

Brajesh Singh Bhadoriya

 Profile Answers by Brajesh Singh Bhadoriya Questions by Brajesh Singh Bhadoriya

• Apr 19th, 2007

No, a table can have only one column of LONG datatype. If you try to create a table with more than one LONG column it will throgh an error saying that a table can have only one LONG type of coumn.Regards,Brajesh.

Answer Question  Select Best Answer

madhaviguthula

 Profile Answers by madhaviguthula Questions by madhaviguthula

• Mar 9th, 2007

When you create a partitioned table,you should create an index on the table. The index may be partitioned according to the same range values that were used to partition the table.Local keyword in the ...

Answer Question  Select Best Answer

Anil Kumar

• Dec 11th, 2019

We can use listtag for such scenario.

Code
 

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

Choose - Choose either Rule based or Cost based depend on theavailability of statistics. If statistics is available on the table it usesCBO and if not it uses RBO.       ALL_ROWS - Choose based optimization, statistics is needed. U couldpass as hint in ur query.But in the majority of cases with optimizer_mode=choose ( and with a goodstatistics ) the CBO will be able to find a good...

Manoj Seemar

 Profile Answers by Manoj Seemar Questions by Manoj Seemar

• Nov 2nd, 2007

The OPTIMIZER_MODE initialization parameter establishes the default behavior for choosing an optimization approach for the instance.CHOOSEThe optimizer chooses between a cost-based approach and a rule...

Answer Question  Select Best Answer

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

   No, It's not possible because select statement only selects the values.   Thanks & Regards    K.Santhosh

RK

• Apr 24th, 2006

FOR EXAMPLE TO RETRIEVE 2ND COLUMN(ENAME)  IN EMP TABLE:SELECT COLUMN_NAME FROM USER_TAB_COLUMNSWHERE TABLE_NAME ='EMP'AND COLUMN_ID = 2

Answer Question  Select Best Answer

jaya

• May 29th, 2007

Hi,It seems your application is using a cursor with for update clause , where the other transaction (DML) will wait until the current one gets end.check the code , if this is not the case then there m...

Answer Question  Select Best Answer

dev

• Sep 13th, 2006

Good Deephi. It's working.Thanks.

Deepthi

• Jul 18th, 2006

Spool is used to write the output into a file.Spool (write the file name) ex: spool d:sampl.txtif u want stop spooling use the command spool off

Answer Question  Select Best Answer

Dhaval

• Nov 14th, 2006

Select Count(*) , DATEPART ( hh , sellgoodsdate) From goodssellGroup By DATEPART ( hh , sellgoodsdate)

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

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

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

saibabu

 Profile Answers by saibabu Questions by saibabu

• Jan 12th, 2007

hi select  ..........col3,col2,col1    from   tablename;just specify the columns   in the reverse order  i n the select statement.

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