fei7837226的博客

1.创建虚拟表的视图，返回字符串CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (4000);2.切割函数（参数：1.要分割的字符串；2.分割符号）CREATE OR REPLACE FUNCTION split_str (p_str IN VARCHAR2, p_delimiter IN VARCHAR2) R...

1.新建用户和表空间：create tablespace ECAS_DATA datafile 'D:\app\Administrator\oradata\orcl\XPADS.DBF' size 50m autoextend on next 50m maxsize 20480m extent management local;create user newxpads_ecas identi...

SQL> show user USER is "TEST"SQL> create table t (id number);Table created.SQL> create user u1 identified by u1;User created.SQL> grant create session to u1;Grant succeeded.S...

CREATE OR REPLACE TYPE str_split IS TABLE OF VARCHAR2 (4000);CREATE OR REPLACE FUNCTION splitstr(p_string IN VARCHAR2, p_delimiter IN VARCHAR2) RETURN str_split PIPELINEDAS v_length ...

1.NVARCHAR2(size)与VARCHAR2(size CHAR)相似，唯一的区别是NVARCHAR2(size)的最大长度是4000字节（实验测试结果是，在utf8的字符集下，最大长度为2000字符），而VARCHAR2(size CHAR）的最大长度是4000字符。2.NVARCHAR2和VARCHAR2存储字符有点小区别比如：1、NVARCHAR2(10)是可以存进去10个汉字的，如...