Why do we need varrays ,index by table,pl/sql table etc when cursor is avai

Advertisement
November 30

hi,
Why do we need Composite data types like Index by Table, varrays etc when we have cursors and we can do all the things with cursor.
Thanks
Ram

Advertisement

Replay

I would have to create a collection type for each column in the select statement.No.
SQL> select count(*) from scott.emp ;
  COUNT(*)
        14
1 row selected.
SQL> DECLARE
  2      TYPE my_Table IS TABLE OF scott.emp%ROWTYPE;
  3      my_tbl my_Table;
  4  BEGIN
  5      SELECT * BULK COLLECT INTO my_tbl FROM scott.emp;
  6      dbms_output.put_line('Bulk Collect rows:'||my_tbl.COUNT) ;
  7  END;
  8  /
Bulk Collect rows:14
PL/SQL procedure successfully completed.
SQL> disc
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL>Message was edited by:
Kamal Kishore

View 9 Replies

Multiple users need to see some documents in SQL table, PHP

October 11

Is there a way to serve up data for a user based on their group assignment?  I have two SQL tables.  The first one has the user login information (username, password, groupID note: multiple users can belong to same GroupID).  The second table has the

View All Replies

PL/SQL TABLE AS OUT ON PROCEDURE CALL AND JDBCTHIN(NEED HELP

October 11

How can I pass pl/sql record in and out and pl/sql tables in out thru a pl/sql procedure using jdbc with the zip file of 816classes12.zip... I have tried everything I know... I know the procedure is working, others are using it with in Oracle... I ne

View All Replies

Netbeans - Why do I need to make separate library projects and import?

November 30

I'm running through some of the some of the tutorials for netbeans like [acrostic example|http://www.netbeans.org/kb/60/java/javase-intro.html] and I can't seem to grasp the organization. When and why do I need to create a separate library project an

View All Replies

Need help :: how to search in nested table/varray data type

November 30

I have the following structure... CREATE TYPE lang_con AS VARRAY(15) OF VARCHAR2(50); CREATE TYPE rel_con AS VARRAY(15) OF VARCHAR2(50); CREATE TABLE Country_n( "NAME" VARCHAR2(40 BYTE) CONSTRAINT "COUNTRY_NAME_NOTNULL_N" NOT NULL ENAB

View All Replies

Why ORA-01555 (Snapshot too old) occures on an unchanged table

November 30

Hello, we have to add a not null column into a large table. The simple update is not good, due to UNDO space. alter table T add F INTEGER default 0 not null; ORA-30036: unable to extend segment by  in undo tablespace ''It is OK. (We cannot use create

View All Replies

Index Multiple Column of Multiple Tables

November 30

Hi All, I would like to know how to create a index which can search through all column in my database tables. Eg: I have 30 tables and every tables have around 10 columns. I want to create a index which can search through the columns in these tables.

View All Replies

Why do we need GUID?

November 30

Hi All, I noticed some posts on SDN forums talking about creating  GUIDs and using them as primary keys in DB tables and Persistent Objects especially in CRM. But I don't know why do we need GUID? aint the business key enough? What are the uses of GU

View All Replies

Why do we need to put \\\\ for inserting a single \

November 30

Hi, I wanted to replace the string h"i with h'i. The following code does that. public class replace {      public static void main(String a[]) {           String hel = "h\"i";           System.out.println(hel);           hel = hel.repl

View All Replies

NEED HELP ASAP-populate contents from 5 tables into one master table

November 30

Scenario: Assign a new_customer_id to each existing customer of our three business. A master lookup table (M) was given to me with pre-populated (SEQ_NOs), (NEW_CUSTIDs), and NULL in (OLD_CUSTIDS). My duty is to (1) Fill the M.OLD_CUSTID column with

View All Replies

How can i make indexes on the Master data table

November 30

Hi Gurus, I got a query, in this one i have an Infoobject with many values, like to say invoice number, and i filter and need a lot of Nav Attr of this IO, for this reason the query performance its really bad but i dont know what to do, some friend a

View All Replies

SQL Developer Behavior When Gathering Table/Index Statistics

November 30

Hey All, Not sure if this has been posted yet. I did a search and did not find any threads on the topic though. I noticed with SQL Developer 2.x, when you using the context menu to gather table/index statistics for a given table, you get no modal pro

View All Replies

WHY DO I NEED TO CHANGE DATA PLAN IN ORDER TO GET A NEW PHONE?

November 30

WHY DO I NEED TO CHANGE PLAN IN ORDER TO GET A NEW PHONE FOR A CHEAPER PRICE ?You do not like the answer that is different then you being wrong. Everyone can think things about anything, but it is a black and white issue. To get a new cheaper phone,

View All Replies

Best method of indexing for composite range partitioned table

November 30

Can anyone suggest the best method of indexing for a composite range partitioned table. The following is the scenario ... Table has been created as follows: CREATE TABLE t1           x NUMBER,           y NUMBER,           c1 VARCHAR2(1),           c

View All Replies

Why does WebUtil needs AS configurations?

November 30

If we have to only attache the WebUtil.PLL and sub-class the webutil.olb to the form and place the frmwebutil.jar in the \%Oracle Dev Home%\forms\java then why do we need such a complicated set-up in the app server (like signing with JACOB which I re

View All Replies

What is a inforecord? why do we need to maintain that?

November 30

Hello, what is a inforecord? why do we need to maintain that? is it automatically created or manual? Thanks,Info Record is used for storing the purchasing information about a vendor and a material as the master data at purchasing organization and pla

View All Replies

Need To Create a table in Sql Server and do some culculation into the table from Oracle and Sql

October 11

Hello All, I'm moving a data from Oracle to Sql Server with ETL (80 tables with data) and i want to track the number of records that i moving on the daily basis , so i need to create a table in SQL Server, wilth 4 columns , Table name, OracleRowsCoun

View All Replies

Why does Bridge Need Illustrator to Save as PDF compatible file?

October 11

1. Why does Bridge need Illustrator files to be saved as PDF files? "PDF Compatible File" ticked in the save menu. 2. Why does saving with this info take so long, even on decent fast modern systems? 3. Why does Bridge not consistently render the

View All Replies

Keynote and pages are now free, but why do i need to pay for them still when there now free?!?

October 11

keynote and pages are now free, but why do i need to pay for them still when there now free?!?Users can obtain the iWorks and iLife applications free, if they purchased a Mac after the beginning of October 2013. Older Mac purchases require a paid pur

View All Replies

Why do we need the @EJB annotation at the class level?

November 30

Why do we need the @EJB annotation at the class level? Eg: Why do we need the first piece of code, when the second code seems much simpler . *1.* @Stateful @EJB(name="ejb/TradeLocalNm", beanInterface=TradeLocal.class) public class TradeClientBea

View All Replies

Tags:

  1. ipod nano wont turn on
  2. iphone 4 does not regonizes sim card
  3. Free youtube settings sa nokia503
  4. ipad a1396 charging only vibrate no on
  5. ipad A 1460 is disabled itunes
  6. inurl: sign.html
  7. apple error code 4men 9
  8. imovie program for a1151
  9. BAPI_SALESDOCUMENT_CHANGE sample
  10. where character is in string sql
Copyrights 2017 Fcffair BigData Resource, All rights reserved