728x90
VARCHAR2와 VARCHAR data type은 같다.
그리고 공식 문서에서는 VARCHAR2 사용을 권장한다.
The VARCHAR datatype is synonymous with the VARCHAR2 datatype. To avoid possible changes in behavior, always use the VARCHAR2 datatype to store variable-length character strings.
https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#i1835
Oracle Data Types
33/35 26 Oracle Data Types This chapter discusses the Oracle built-in datatypes, their properties, and how they map to non-Oracle datatypes. This chapter includes the following topics: Overview of Character Datatypes The character datatypes store character
docs.oracle.com
VARCHAR Data Type Do not use the VARCHAR data type. Use the VARCHAR2 data type instead. Although the VARCHAR data type is currently synonymous with VARCHAR2, the VARCHAR data type is scheduled to be redefined as a separate data type used for variable-length character strings compared with different comparison semantics.
SQL Language Reference
docs.oracle.com
728x90
'Programming > Database' 카테고리의 다른 글
| [Influx DB] .bat 파일로 정기적으로 DB 백업(+ 복원) (1) | 2024.11.23 |
|---|---|
| [Oracle DB] BLOB이 차지하는 저장 공간 용량 조회 (0) | 2024.11.19 |
| [SQL] WHERE 절 조건에 IF/ELSE 조건 넣기 (0) | 2022.11.02 |
| [MS-SQL] Alter Constraint (0) | 2022.07.10 |
| [MS-SQL] SQL로 파일 이동/삭제하기(xp_cmdshell) (0) | 2022.03.06 |
댓글