|
|
|
|
|
|
|
|
Re: Color property to a particular record [message #627742 is a reply to message #627741] |
Sat, 15 November 2014 10:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
@OP, it is not clear whether you want to display the result set in some coloured format on an application or any GUI based client tool like SQL Developer, PL/SQL Developer, TOAD etc. Or for that matter even SQL*Plus. The prior depends on your application, the latter I don't know. Please clarify.
The worst case is that you are thinking to store the data itself in that way, if yes, then it makes no sense.
Edit :
Just to add, the data is not stored in the database the way we see it. The format is only for display for human beings to make it easy to see and understand.
Regarding storing data in a particular format(colour in your case), I can give an example of the myth about storing a date in particular format, however, Ed Stevens has already mastered it to explain beautifully. I see he has already posted a reply, so he would be a better person than me to explain this example(if required )
[Updated on: Sat, 15 November 2014 10:25] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Color property to a particular record [message #627749 is a reply to message #627730] |
Sat, 15 November 2014 11:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Just a note to other responders: OP is using EBS. HZ_LOCATIONS is table in the AR schema, and that screen shot looks like a standard EBS form.
Avinash, what are you trying to do? Design your own form? Design a report? Write a query that you'll run with SQL*Plus?
|
|
|
|
|
|
|
|
|
Re: Color property to a particular record [message #627875 is a reply to message #627738] |
Mon, 17 November 2014 12:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/27c2fa7e625e5a035ea042a61670b29c?s=64&d=mm&r=g) |
avinash reddy
Messages: 8 Registered: November 2014
|
Junior Member |
|
|
avinash reddy wrote on Sat, 15 November 2014 09:08can i write a query in this way
select CONCATENATED_ADDRESS from HZ_LOCATIONS where CONCATENATED_ADDRESS = '....'
and here i have a problem that how can i assign a colout to '...'
please remove this query as soon as possible on request of OP.
[mod-edit: confidential information replaced with ... by bb]
[Updated on: Mon, 17 November 2014 13:11] by Moderator Report message to a moderator
|
|
|
Re: Color property to a particular record [message #627880 is a reply to message #627874] |
Mon, 17 November 2014 14:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Avinash, it looks as though you are trying to customize EBS. Are you following the CEMLI standards, or are you just hacking? You might want to look up RICE and AIM as well. If you do not recognize those acronyms, you need to stop what you are doing right now, and research them. Customizing EBS is something that you should not do without following the standards or the long term results will be disastrous.
|
|
|