?
Solved

How can I create a new index for my Oracle Pipelined Table Functions select statement

Posted on 2011-10-03
1
Medium Priority
?
325 Views
Last Modified: 2012-06-27
How can I create a new index for my Oracle Pipelined Table Functions select statement

For example this select statment is retriving 49 rows in one column but i need to create another column showing the number of each row every time I run the select

SELECT "COLUMN_VALUE" FROM TABLE(cast(read_bulk_channel(17400505,'MD')AS NumberTable));

col1
------
234
567
567
444
666

I want to be able to do this !!

new_col      col1
1                 234
2                567
3                567
4                 444
5                666
0
Comment
Question by:Mohammed Dallag
1 Comment
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 36902889
If you have no specific order just add rownum:

SELECT rownum new_col, "COLUMN_VALUE" FROM TABLE(cast(read_bulk_channel(17400505,'MD')AS NumberTable));

0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses
Course of the Month15 days, 14 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question