sql-- 디스크 테이블스페이스 이름과 데이터 파일 경로와 이름을 출력합니다.
set linesize 1024
set colsize 100
SELECT T.NAME TBS_NAME, D.NAME DATAFILE
FROM V$DATAFILES D, V$TABLESPACES T
WHERE D.SPACEID = T.ID
ORDER BY D.SPACEID, D.ID
SQL_SUCCESS
completed successfully.
OCI_ERROR
SQL_ERROR
The function failed.
OCI_SUCCESS_WITH_INFO
SQL_SUCCESS_WITH_INFO
completed successfully with information.
OCI_NO_DATA
SQL_NO_DATA_FOUND
The function completed, and there is no further data.
OC
SQL statement, the conversion of a character string
into a number fails because the string does not
represent a valid number.
INVALID_PATH
201237
Invalid directory path(exception is not handled in the stored procedure or function)
INVALID_MODE
201235
SQL statements were written in the program source, but using iBATIS, the SQL statements are separated from the program and written separately in the XML file. This reduces the burden of programmers programming when using existing JDBC. In addition, if the use
sql.
It provides three methods to perform according to the purpose
All database objectsBy database userBy object
Example of aexport execution result and file contents.
bash$ ls -l | head
Total 60
-rw-rw-rw- 1 eheejung eheejung 303 2019-07-12 13:15 ALL_ALT_TBL
SQL(APRE*C/C++) 로 작성된 경우 확인할 수 있는 값은 다음과 같습니다.
sqlca.sqlcode (쿼리 수행 리턴값 - SQL_SUCCESS, SQL_ERROR, etc)sqlca.sqlerrm.sqlerrmc (에러메시지)SQLCODE (에러코드)SQLSTATE (상태코드)
응용프로그
SQL 문장 및 수행 시각SQL 문장 수행 여부
트랜잭션 별 언두 테이블스페이스 사용량 조회 쿼리sqlSELECT RPAD(DECODE(TX.LOG_TYPE, 1, REP.REP_NAME, TX.SESSION_ID), 10) SESSION_ID -- 트랜잭션을 수행한 세션 ID.
, RPAD(TX.ID,
SQL AT clause.
String data right truncated. (SQLCODE=1)
This is the case when the length of the declared variable is small in the process of storing the value in the variable from the DB. Change the length of the DB variable as large as (data length + 1byte).
SQL. Please refer to Altibase Precompiler Guide for specific details such as usage of the function as a summary form.
Terms
Precompiler of Embedded SQL
The program that receives source code including embedded SQL and converts the embedded SQL into execution-t