smartzhang的专栏

select clob_Field from table where rownum = 1union allselect null as listtypecontent from dual

DBMS_LOBCREATE TABLE lob_table (      key_value      INTEGER,       b_lob          BLOB,       c_lob          CLOB,       n_lob          NCLOB,       f_lob          BFILE);INSERT INTO a_table valu

SQL中的单记录函数1.ASCII返回与指定的字符对应的十进制数;SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;        A         A      ZERO     SPACE--------- --------- --------- ---------