maverick
Reputation: 1484
difference between varchar2 in oracle sql and pl/sql
Is there any difference between varchar2 in oracle sql and pl/sql or both are same or there are some implementation difference.
Upvotes: 3
Views: 593
Answers (1)
ErikL
Reputation: 2041
There is at least one difference: the length.
in Pl/sql, it can have a maximum length of 32,767 bytes, while in sql it can only be 4,000 bytes long.
Upvotes: 4
Related Questions
- Difference between VARCHAR2 and LONG datatype on Oracle PL/SQL
- What is the max size of VARCHAR2 in PL/SQL and SQL?
- What is the difference between varchar and varchar2 in Oracle?
- What is the major difference between Varchar2 and char
- VARCHAR2 datatype in ORACLE
- Oracle datatype: Should I use VARCHAR2 or CHAR
- Varchar2(CHAR) always in PLSQL?
- Difference between varchar and varchar2 in SQL
- Why does an oracle plsql varchar2 variable need a size but a parameter does not?
- Oracle SQL difference between varchar2(n) and varchar2(n char)