Hello! Eddie Awad’s Blog is using DISQUS, a powerful comment system, to manage its comments. Learn more.
Community Page
- awads.net/wp/ Jump to website »
-
Subscribe -
Community
-
Top Commenters
-
Popular Threads
-
Recent Comments
- wow this suxxxxxxxxxxx
- My husband works in China. When I visited I met some lovely Chinese people. One young man went out of his way to show us China. Wonderful shopping experiences & friendship. My husband is...
- Thanks very much for sharing that Eddie, it saved me a lot of time! Best regards, -Adam vonNieda
- Hi William, I'm assuming you're referring to the usefulness of Enso or other launcher applications. I have Firefox open all the time so it does not make much difference there. From personal...
- To open Firefox, wouldn't it be simpler to click on the Firefox icon? Or in Windows, press Win-R to get a "Run" prompt and type "firefox"? Google and Dictionary.com already...
Eddie Awad’s Blog
News, views, tips and tricks on Oracle and other fun stuff
Amazing what you can do with ANYTYPE, ANYDATA, ANYDATASET, DBMS_TYPES, DBMS_SQL and pipelined table functions implemented using the interface approach. You can end up with a dynamic sql mashup like you’ve never seen before, and pivot like you’ve never pivoted before
... Continue reading »
11 months ago
I would like you to help me to come up with desired results for this report.I am currently preparing a script in SQL for people who has attended course now what i want the report to do is to highlight the entire row green if the column STATUS contains the value ' NOT ATTENDED',Im thinking of a coding like this
select case when status "Attended' then
backcolor = green
else status
end case
the second one is this field called Cost_per_person is captured in string data type and other values are having 'R' before(R4562,00) and the comma is not used to separate thousand is for hundrends instead.Now i want to convert all the numbers to decimal and leave those rows that contains characters('NOT YET PAID').I want to have a code like this one
select CASE WHEN f.segment10 = string then
REPLACE (CAST (f.segment10 AS VARCHAR (10)), 'R', ' ' )
when f.segment10 = varchar then
convert(To_decimal(8,2),f.segment10 )
ELSE f.segment10
END cost_per_person,
your response will be highly appreciated.
Regards
Nosizwe Mxobo
Marang Oracle Centre of excellence : HRMS Business Intelligence
Tel: 27 (21) 403 8075
Fax: 27 (21) 403 3657
Cell: 082 064 4691
www.parliament.gov.za