krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 22nd, 2008

Ref cursor is basically a data type. A variable declared based on that data type is called cursor variable. The main advantage of using this variable is we can dynamically assosiate with different  queries at runtime depending upon  our requirement.

tariq_oracle

 Profile Answers by tariq_oracle Questions by tariq_oracle

• Jun 8th, 2008

1. This is a dynamic cursor which can holds multiple value at run time2. Actually this is nothing but a data type of cursor variable

Answer Question  Select Best Answer

A bad answer is count them (SELECT COUNT(*) FROM table_name)A good answer is :-'By generating SQL to ANALYZE TABLE table_name COUNT STATISTICS by querying Oracle System Catalogues (e.g. USER_TABLES or ALL_TABLES).The best answer is to refer to the utility which Oracle released which makes it unnecessary to do ANALYZE TABLE for each Table individually.

safdar

 Profile Answers by safdar Questions by safdar

• Sep 4th, 2007

If you want to find the number of Rows in table SELECT COUNT(*) FROM EMP;This is valid query

gony

 Profile Answers by gony Questions by gony

• Feb 8th, 2006

Use SY-DBCNT. It is used to count number of rows in a databse table.in internal tables we use SY-TABIX.cheers dude....bye

Answer Question  Select Best Answer

OPEN cursor variable FOR SELECT...StatementCLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

• The OPEN-FOR statement associates a cursor variable with a multirow query, executes the query, identifies the result set, and positions the cursor to point to the first row of the result set.&b...

S.Senthil Kumar

• Oct 31st, 2006

Without Open Cursor statement the data which is in the table cannot be load into cursor variable.The Close Cursor statement deallocates the memory occupied by the cursor

Answer Question  Select Best Answer

INOUTINOUT

roopali

• Jun 1st, 2007

IN : lets you  pass values to the  subprogram being calledOUT: lets you return  values to the caller of subprogramINOUT: lets you to pass values to the subprogram and return values to the caller of the subprogram.

SIVANARAYANA CHEKURI

• May 25th, 2007

INOUTIN OUTNO COPY

Answer Question  Select Best Answer

Oracle Call Interface is a method of accesing database from a 3GL program. Uses--No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides-functions to parse SQL statemets-bind input variables-bind output variables-execute statements-fetch the results

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

The Oracle Call Interface (OCI) is a set of low-level APIs (Application Programming Interface Calls) used to interact with Oracle databases. It allows one to use operations like logon, execute, parse,...

subbaraovangalli

 Profile Answers by subbaraovangalli Questions by subbaraovangalli

• Apr 4th, 2007

What is meant by 3GL PGRM

Answer Question  Select Best Answer

UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

With the Oracle-supplied UTL_FILE package, you can read from and write to operating system files. It Provides security for directories on the server through the init.ora file. UTL_FILE Procedures and ...

Rakesh

• Mar 20th, 2007

Utl_file is oracle procedure tht enable file access .You can write ,read to file.Also possible is to del or rename a file.It requires the use of a directory object.

Answer Question  Select Best Answer

1,000,00

ssschowdary

• May 8th, 2007

Up to Oracle 10g the buffersize os an integer between 2,000 and 1,000,000; From Oracle 10g Release 2 the buffersize is unlimited

Ashok

• Feb 19th, 2007

The maximum buffer size is "Unlimited". Thanks,Ashok

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

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Mar 8th, 2007

nikhil take 14 is the currvalue  in the sequence the result for this query isselect s.currval , s. nextval,s.nextval from dualis15,15,15yes :-) ok  now about execution  of this query.i ...

Nikhil_4_Oracle

• Mar 8th, 2007

HI ddkdhar,  U r output wll be...   CURRVAL    NEXTVAL    NEXTVAL    -----------     -----------    ...

Answer Question  Select Best Answer

Merge Join :Oracle performs a join between two sets of row data  using the mergejoin algorithm. The inputs are two separate sets of row data. Output isthe results of the join.  Oracle reads rows from both inputs in analternating fashion and merges together matching rows in order togenerate output. The two inputs are sorted on join column.Hash Join :Oracle performs a join between two sets...

mvg_mca

 Profile Answers by mvg_mca Questions by mvg_mca

• Mar 24th, 2010

A merge join basically sorts all relevant rows in the first table by the join key, and also sorts the relevant rows in the second table by the join key, and then merges these sorted rows.A hash join (...

Manoj Seemar

 Profile Answers by Manoj Seemar Questions by Manoj Seemar

• Nov 2nd, 2007

Merge Joins Sort merge joins can be used to join rows from two independent sources. Hash joins generally perform better than sort merge joins. On the other hand, sort merge joins can perform better th...

Answer Question  Select Best Answer

raj1402

 Profile Answers by raj1402 Questions by raj1402

• Oct 12th, 2007

You can use oracle as Database and Jsp for scripting!!!

prasadmeduri

 Profile Answers by prasadmeduri Questions by prasadmeduri

• Feb 14th, 2006

Hi,You can use any type of webapplications for this task.I think ASp/JSP will be of great use and benefit.Keep database(SQLServer or Oracle) and your IIS/Weblogic on one dedicated machine for ser...

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

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

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

When you drop a table, normally the database does not immediately release the space associated with the table. Rather, the database renames the table and places it in a recycle bin, where it can later...

Suresh

• Aug 4th, 2006

You can use this command to retrieve the dropped table, simply by querying,FLASHBACK TABLE TO BEFORE DROP;you can also query this to view the objects that can be undropped,SHOW RECYCLEBIN

Answer Question  Select Best Answer

nis1981

 Profile Answers by nis1981 Questions by nis1981

• Aug 5th, 2008

Select empidfrom ratinggroup by empidhaving count(empid) > 1;

Harshita

• Apr 18th, 2006

Select empID from RATING group by ReviewSeason having count(empID)>1

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

Kiran Bondre

• Aug 1st, 2006

The fundamental difference between "WHERE" and "HAVING" is this: "WHERE" selects input rows before groups and aggregates are computed (thus, it controls which rows go into the aggregate...

Anurag Puranik

• Aug 1st, 2006

The WHERE clause is used to restricted only those columns which are not in group while HAVING clause is use to restricted the group functions.

Answer Question  Select Best Answer

jaspreet.nagra

 Profile Answers by jaspreet.nagra Questions by jaspreet.nagra

• Jul 14th, 2009

Sometime the special index you get automatically with every primary key and unique constraint might not help in certain situations. If this happens then maybe it's time to explicitly create a seco...

SateeshReddy

 Profile Answers by SateeshReddy Questions by SateeshReddy

• Oct 9th, 2006

Hello frnd,why cant we create an index on the index....i think according to the database concepts we can create it. it may called as multilevel indexes...like B trees and B+trees are examples for that...

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