Tora's Kingdom of IT

ora 검색 결과

해당 글 4건

[Oracle] 4. ORA-00933 sql command not properly ended

if you faces this error, check for next things.1. , 2. ; 3. '' 4. "" 5. space 6. SQL query (AND, OR, , WHERE, ORDER BY ...) 7. typo 출처 : 본인 Github 블로그 - Tora's Programming World주소 : syjkim0125.github.io

Oracle/Oracle Error 2017. 11. 10. 12:44

[Oracle] 3. ORA-00923 from keyword not found where expected

If you faces this error, Check out follow things.Checks the SELECT portion of COLUMN between SELECT and FROMEx)GENDER AS g, LAST_VISIT_DT AS l, FROM table_name -> you must delete ‘,’ where in front of FROMGENDER AS g, LAST_VISIT_DT AS l FROM table_name Check the alias.Ex1) where you put the '', delete or change that. Ex2) as the game -> never put the space. -> as tg Syntax check.Ex) The part tha..

Oracle/Oracle Error 2017. 11. 10. 12:43

[Oracle] 2. ORA-01861 literal does not match format string

If you faces this error, Check out the following.To store a string (String type) in a NUMBER type columnTo store a string (String type) in a DATE type columncheck your Date formEx1)schemacolumn_name data_type id varchar2 last_login_date Date UPDATE LOGIN_TABLE SET LAST_LOGIN_DATE = #login_date# WHERE ID = #id# -> ERROR!! Cast typeUPDATE LOGIN_TABLE SET LAST_LOGIN_DATE = TO_DATE(#login_date#, ‘YY..

Oracle/Oracle Error 2017. 10. 18. 10:05

[Oracle] 1. ORA-01722 invalid number

if you faces this error, check this 4 cases.you put the invalid parameter.miss the quotation marks.When passing values from java, Without clearing the “+…+”put wrong type.Ex1)user_id = 'user_id' -> user_id = '123' Ex2) 1 -> '1' Ex3)'"+id+"' -> '1122' you must change next all thing : Ex4)schemacolumn_name data_type emp_no varchar(20) emp_nm varchar(20) tableemp_no emp_nm AA00001 Tora 1200002 Jame..

Oracle/Oracle Error 2017. 10. 18. 09:58