ºê¶ó¿ìÀú¿£ ORA-00933: SQL ¸í·É¾î°¡ ¿Ã¹Ù¸£°Ô Á¾·áµÇÁö ¾Ê¾Ò´Ù±¸ÇÏ°í,sql»ó¿£ 00904¼öÄ¡¿¡·¯±º¿ä(¾Æ·¡sql4¿¡¼ ³ì»öºÎºÐ), ±×¿Ü ¿À·ùºÎºÐÀÌ ¾îµð°í ¾î¶»°Ô ¼öÁ¤ÇØ¾ß µÇ´ÂÁö¿ä
String sql1 = " select count(articleid) "+
" from board "+
" where 1=1 ";
String sql2 = " select count(articleid) "+
" from board "+
" where to_char(write_date,'yyyymmdd') = to_char(sysdate,'yyyymmdd') ";
String sql3 = " select distinct(a.articleid) from (select*from board where type = 'l')a, " +
" (select * from board where type = 'R')b " +
" where 1=1 " +
" and a.articleid = b.parent_articleid(+) " +
" order by a.articleid desc ";
String sql4= " select articleid,nvl(title,' '),nvl(user_name,' '),to_char(write_date, 'yyyy/mm/dd hh:mi'),hits,type from board " +
" START WITH 'articleid' in ('"+rs.getString(1)+"') " +
" CONNECT BY parent_articleid = prior articleid " ;