Home » SQL & PL/SQL » SQL & PL/SQL » how to show dynamic column aliases (oracle dbase 10g, xp)
how to show dynamic column aliases [message #387945] Sun, 22 February 2009 05:09 Go to next message
OraVision
Messages: 17
Registered: March 2008
Junior Member
can any one help me how to show the dynamic column aliases.


its urgent please.


Thank you.
Re: how to show dynamic column aliases [message #387946 is a reply to message #387945] Sun, 22 February 2009 06:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I wanted to answer you but OraFAQ Forum Guide states:
Quote:
Avoid the following keywords: urgent/please/help/now/immediately (and derivatives)

and also
Quote:
Did I search the board properly? Have I also tried the Site Search Engine?

It seems to me you didn't follow both.

As already said to you, read and follow the guidelines.
Post a Test case, explain your case in details and post the result you want.

Regards
Michel

[Updated on: Sun, 22 February 2009 06:08]

Report message to a moderator

Re: how to show dynamic column aliases [message #387948 is a reply to message #387945] Sun, 22 February 2009 07:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/254375/102589/?srch=print_table#msg_254375

Regards
Michel
Re: how to show dynamic column aliases [message #388004 is a reply to message #387945] Mon, 23 February 2009 00:24 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Michel,

http://www.orafaq.com/forum/m/254375/102589/?srch=print_table#msg_254375 .This post is the classical example of what not do here, it was really painful to format the code myself ( i was just practising to give this answer).

It will make life easy when we FORMAT using the tools which we have here, its easy..

Regards,
Ashoka BL

Re: how to show dynamic column aliases [message #388020 is a reply to message #388004] Mon, 23 February 2009 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
This post is the classical example of what not do here

Why?

Quote:
it was really painful to format the code myself

Hard to format! Really?

Quote:
It will make life easy when we FORMAT using the tools which we have here, its easy..

What does this mean?

Regards
Michel
Re: how to show dynamic column aliases [message #388028 is a reply to message #387945] Mon, 23 February 2009 00:55 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Quote:
This post is the classical example of what not do here


First of all, it was not at all formatted, after u saying as well,

Quote:

it was really painful to format the code myself


Hard to format! Really?



When i say format, i mean i had to copy the code and paste it and do formatting manually,(deleting the LINE NUMBERS)

Quote:
It will make life easy when we FORMAT using the tools which we have here, its easy..


What does this mean?



We do have formatting tools when we post the question, if we do format and explain what we do want then it will be very easy.

Quote:

NO until you read the links I posted and format your post.


I haven't commented anything that you did, i think u did correct when u said the above Statement.


Sorry if any mistake,i felt that you can only answer when you are given the clear picture( A well formatted POST)

Regards,
Ashoka BL
Bengaluru

Re: how to show dynamic column aliases [message #388041 is a reply to message #388028] Mon, 23 February 2009 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
First of all, it was not at all formatted, after u saying as well,

It is, what do you want more? Or are you talking about another post from the same topic?

Quote:
When i say format, i mean i had to copy the code and paste it and do formatting manually,(deleting the LINE NUMBERS)

Sure you are talking about another post, mine has no line numbers, it is just one line exec command.

Quote:
We do have formatting tools when we post the question, if we do format and explain what we do want then it will be very easy.

I very agree, too bad you are talking to the wrong person.

Quote:
NO until you read the links I posted and format your post.

Where does it come from?

Quote:
i felt that you can only answer when you are given the clear picture

Right! This prevent from answering outside the REAL problem.

Regards
Michel

Re: how to show dynamic column aliases [message #388047 is a reply to message #387945] Mon, 23 February 2009 01:14 Go to previous messageGo to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Michel,

First of all sorry for the confusion created..I was just referring to the OTHER PERSON Who hasn't formatted it properly.


I was referring to

http://www.orafaq.com/forum/m/254375/102589/?srch=print_table#msg_254375

Regards,
Ashoka BL
Bengaluru
Re: how to show dynamic column aliases [message #388051 is a reply to message #388047] Mon, 23 February 2009 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you mean
http://www.orafaq.com/forum/mv/msg/86284/254373/102589/#msg_254373

With a 3 and not 5 at the end of message number.

Regards
Michel

[Updated on: Mon, 23 February 2009 01:18]

Report message to a moderator

Re: how to show dynamic column aliases [message #388052 is a reply to message #387945] Mon, 23 February 2009 01:21 Go to previous message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Yes Michel,

Lets hope that we dont have confusion anywhere.

Regards,
Ashoka BL
Previous Topic: Beginner: Need some simple code checking
Next Topic: Pivot Table
Goto Forum:
  


Current Time: Fri Dec 09 19:15:51 CST 2016

Total time taken to generate the page: 0.14044 seconds