Friday, March 26, 2010

Date Extract function of Oracle

select extract(day from date1) from table
select extract(month from date1) from table
select extract(year from date1) from table

Thursday, March 25, 2010

JSP request.setCharacterEncoding

Today I just find that what I have inserted into database (Chinese characters) is scrambled code.

Finally, the solution is
request.setCharacterEncoding("utf8");

JavaServer Page Implicit Objects

http://www.gulland.com/courses/JavaServerPages/jsp_objects.jsp

Oracle Special Table - Dual

Oracle:

Dual is a special table with a garbage cell which is used for our queries.

For example,
select seq.nextval from dual