| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 |
- react
- es6
- table
- 보조정렬
- vaadin
- Java
- 공정능력
- Eclipse
- plugin
- xPlatform
- SSL
- Kotlin
- R
- Sqoop
- Python
- SPC
- mapreduce
- MSSQL
- Android
- window
- IntelliJ
- tomcat
- Spring
- Express
- NPM
- mybatis
- JavaScript
- GIT
- SQL
- hadoop
- Today
- Total
목록database (64)
DBILITY
oracle unpivot string comma separate to row
오라클에서 테스트되었습니다. UI에서 comma로 연결된 argument를 입력받아 분리 후 행으로 변환하여 조건으로 공급하는 SQL에 응용하였던 적이 있습니다. WITH T1 ( CN ) AS ( SELECT ','||TRIM('A1,A2,A3,A4,') FROM DUAL ) SELECT SUBSTR(T1.CN,INSTR(T1.CN,',',1,LEVEL)+1,INSTR(T1.CN,',',1,LEVEL+1)-INSTR(T1.CN,',',1,LEVEL)-1)CN FROM T1 CONNECT BY LEVEL
IBM공식사이트에서 다운로드하였습니다.
Oracle 10.2.0.3 and lower NOTE: this tip was written with Oracle DBMS version 10.2.0.2.0 How can you know if your Oracle server is correctly configured for XA? The simplest and usually the most effective way is the following: logon to SQLPlus (or use another tool if you like); make sure to use the user/password that you are using for your application execute the query: select * from SYS.DBA_PEND..
[SQL0418] Use of parameter marker not valid. Cause . . . . . : Parameter markers and the RAISE_ERROR scalar function are not allowed: -- As a value in a VALUES INTO statement. -- As an operand of a concatenation operation. -- As the operand of a scalar function. If the scalar function is VALUE, COALESCE, IFNULL, MIN, MAX, LAND, LOR, or XOR, then at least one of the arguments must not be a parame..