½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
HTML
asp
mysql
css
mobile
jquery
image
slide
�޴�
������Ʈ
¸Þ´º
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 174 | Á¶È¸¼ö 7,774 | µî·ÏÀÏ 2006-01-23 23:48:07

´Ð³×ÀÓ

ktx7662

À̸ÞÀÏ

quink2004@yahoo.co.kr

Á¦¸ñ

ORA-00933 SQL¸í·É¾î°¡ ¿Ã¹Ù¸£°Ô Á¾·áµÇÁö ¾Ê¾Ò½À´Ï´Ù
³»¿ë

ºê¶ó¿ìÀú¿£  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 " ;

Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
HappyCGI 2006-01-24 22:03:39
´ä±Û

CGI ÀÔ´Ï´Ù. Á˼ÛÇÕ´Ï´Ù¸¸ ÀúÈñÂÊ¿¡´Â ¾Æ´Â Áö½ÄÀÌ ¾ø½À´Ï´Ù.

ÀÌÀü°Ô½Ã±Û phpÀε¥¿ä ¸Ç³¡¿¡ ³»¿ë ÃßÃâÇÏ´Â ÇÔ¼ö°¡ ÀÖ³ª¿ä? 2006-01-21 12:35:05
´ÙÀ½°Ô½Ã±Û jsp Á¶È¸ °ü·Ã Áú¹®ÀÔ´Ï´Ù. 2006-01-24 22:12:13