-
Oracle CASE expression – Implementing IF-THEN-ELSE logic in SQL
May 12, 2009Oracle CASE expression let us implement IF-THEN-ELSE logic in SQL statements with out invoking PL/SQL functions. There are two kinds of CASE expressions 1) Simple CASE expression 2) Searched CASE expression 1) Simple CASE statement Syntax Example In a simple CASE expression, Oracle searches for the first WHEN … THEN pair for which expr is [...]
-
Bar Graph / Chart using Open Flash Chart (OFC) in JSP
May 3, 2009Download the Open Flash Chart tool from openflashchart.com Make sure that the below mentioned 4 files exists in the same directory of the web application. open-flash-chart.swf swfobject.js - Find the above mentioned two files in the downloaded OFC tool. bargraph.jsp <html> <meta http-equiv=content-type content="text/html; charset=UTF-8"> <head> <script type="text/javascript" src="swfobject.js"></script> </head> <body> <form name="ind" id="ind"> <% [...]