Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Query With analytical function

515746Aug 10 2010 — edited Nov 6 2010
Hi

Below is the scenario which i am looking for in sql query using analytical functions
I/p

Col1 
50
0
-150
-200
300
-100
-300
500
-100


O/p 

Col1     	col2
50            	0
0              	0
-150          -100
-200         	-200
300          	0
-100         	0
-300         	-100
500          	400
-100         	0
Any help really appreciated

Thanks in advance

Edited by: unique on Aug 10, 2010 4:53 AM

Edited by: unique on Aug 10, 2010 4:55 AM

Edited by: unique on Aug 10, 2010 4:55 AM

Comments

momy momy

mark

user_2DKLA

@User_T9GS1: “Table comment” is not the proper term for what you ask here: what you're showing above are pieces of information (column name, data type, maximum length, possibility of NULL values, etc.) excerpted from the description of columns in SQL queries. That information is available in cursor metadata, and yes, exposing it would be nice.

Maybe in SQL Developer Next?

Regards,

thatJeffSmith-Oracle

Interesting idea. It would have to be done on a separate thread as to not slow down the execution time for the query itself…but yeah, interesting.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 7 2010
Added on Aug 10 2010
6 comments
1,320 views