일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 | 31 |
- vaadin
- hadoop
- SQL
- es6
- MSSQL
- GIT
- xPlatform
- react
- Spring
- JavaScript
- 보조정렬
- Express
- R
- IntelliJ
- Kotlin
- Android
- SPC
- mybatis
- mapreduce
- table
- Python
- Sqoop
- 공정능력
- maVen
- 정렬
- Java
- NPM
- window
- tomcat
- Eclipse
- Today
- Total
목록database (60)
DBILITY
독거 가능성 100% 노후에 라면값이라도 하게 센스를 발휘합시다!😅
Please click on the ad so that I can pay for ramen in my old age!
点击一下广告,让老后吃个泡面钱吧!
老後にラーメン代だけでもするように広告を一回クリックしてください。
Master Note for Oracle Gateway Products 1. Concepts and Availability Oracle Gateway products are based on Heterogeneous Services and allow access to non-Oracle databases from Oracle products.Heterogeneous Services provides the generic technology for connecting to non-Oracle systems. As an integrated component of the database, Heterogeneous Services can exploit features of the database, such as t..
오라클에서 테스트되었습니다. 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..