e-·¯´×
  • ±³À°°úÁ¤ ¾È³»
  • ³ªÀÇ °­ÀǽÇ
  • °úÁ¤ Æò°¡
  • È®Àμ­ ½Åû
  • °øÁö»çÇ×
  • ÀÚ·á½Ç
  • Äü¸Þ´º
  • ¸¶ÀÌÆäÀÌÁö
  • ºÀ»çȰµ¿½Åû
ÀÌ·¯´×¼­ºñ½º
  • ³ªÀÇ °­ÀǽÇ
  • ÃֽŰúÁ¤ÆäÀÌÁöÀ̵¿ GO
ÃֽŰúÁ¤ ÃֽЏñ·Ï
  • Àαâ°úÁ¤ÆäÀÌÁöÀ̵¿ GO
Àαâ°úÁ¤ ÃֽЏñ·Ï
  • ±³À°°úÁ¤
ÀÌ·¯´× °³¼³°­Á ºÀ»çȰµ¿ È®ÀνÅû
  • Ä¿¹Â´ÏƼ
  • °øÁö»çÇׯäÀÌÁöÀ̵¿ GO

sql : select a.seq, a.reg_name, a.title, a.file_name1,a.hit_cnt,a.reg_date, a.state, a.doc_group, a.doc_pos, a.doc_step, a.user_id, a.password from (select seq, reg_name, title, file_name1, hit_cnt,reg_date, state, doc_group, doc_pos, doc_step, user_id, password, ceil( rownum / ? ) as page from (select seq,reg_name,title,file_name1,hit_cnt,reg_date,state,doc_group,doc_pos,doc_step, user_id, password from NOTICE_TBL order by doc_group desc, doc_step, reg_date desc ) x) a where a.page = ?
Error java.sql.SQLException: ORA-00904: "PASSWORD": ºÎÀûÇÕÇÑ ½Äº°ÀÚ
°øÁö»çÇ× ÃֽЏñ·Ï

¿©¼º°¡Á·ºÎ ±³À°°úÇбâ¼úºÎ °³ÀÎÁ¤º¸º¸È£Á¤Ã¥ ÀÌ¿ë¾à°ü À̸ÞÀϹ«´Ü¼öÁý°ÅºÎ À̸ÞÀϼ­ºñ½º Àç»ý Á¤Áö