Skip to Main Content
Forums

Java Programming

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!

Hiding my jars of applet

NarayanFeb 5 2011 — edited Feb 6 2011
Hello Can anybody tell me how can I hide my jar,lib jars or How could I load my applet without giving fully qualified jar destination.Whenever I make applet every user could easily access and download my jar but as I saw of big vendors like Opera, they usually hides their applet's jar files Could any body tell me how can it be done! Alternative ways will be appreciated

Thanks.
Narayan

Comments

BEDE

select distinct status,count(*) col1
,sum(
case
when reviwe_status='Y' then 1
else 0
end
) number_reviewed
from temp1
group by status
;

Frank Kulash

Hi,
SUM (CASE ...), as Bede showed, will work. You could also use COUNT (CASE ...), like this:

SELECT    status              -- or  LOWER (status) AS status
,         COUNT (*)  AS col1  -- or a more descriptive name, like number_total
,	  COUNT ( CASE
	  	      WHEN  review_status = 'Y'
		      THEN  'OK'
	  	  END
	  	)    AS number_reviewed
FROM      temp1
GROUP BY  status
ORDER BY  status  -- or whatever
;

If you really want to display 'open' and 'close' even though the table has 'Open' and 'Close', as you said, then you just need to change the first line.
In any event, you don't need "SELECT DISTINCT". The GROUP BY clause guarantees that status will be distinct in the output

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

Post Details

Locked on Mar 6 2011
Added on Feb 5 2011
#applet, #database, #java
7 comments
224 views