sun-hchao

create table t0704_1(tn varchar2(1),fatherid number,childid number); insert into t0704_1 values('A',null,1); insert into t0704_1 values('B',1,2); insert into t0704_1 values('C',1,3); insert into t0704_1 values('D',2,4); insert into t0704_1 values('E',4,1); insert into t0704_1 values('F',4,5);...

Create type custom table type A as table of custom object type A 1.create or replace type deploy_env_record(dict_value varchar2(100) , dict_meaning varchar2(100) ,env_flag varchar2(100)) ; 2.create or replace type ctp_type_arraytype...

Syntax parsing: ① Create [or replace:] means that when creating a synonym, if the synonym already exists, the newly created synonym will replace the old synonym. ② Pulbic: the keyword...

Table join queries in Oracle can use (+) create table t_a(id int,name varchar2(99)); create table t_b(id int,name varchar2(99)); insert into t_a values(1,'a'); insert into t_a values(2,'b'); insert into t_a values(3,'c');...

1. EXTRACT（XMLType_instance，Xpath_string） This function is used to return the corresponding content under the PATH of the XML node. Example: SELECT extract(value(a),'/root/main') data FROM xmltable a ; 2. EXTRACTVALUE（XMLType_instance,Xpath_string) This function...

oracle=# create table test_like_number(id number(38),createtime date); insert into test_like_number values(1,sysdate); insert into test_like_number values(2,sysdate); insert into test_like_number values(3,sysdate); insert into test_like_number values(4,sysdate); insert into test_like_number values(5,sysdate); insert into test_like_number values(10,sysdate);...

In Oracle, the asciistr() function can convert strings from any character set to ASCII strings using the database character set. The following are some examples of using Oracle assiistr() functions:...

For example: 1. '', parameter default value '' and parameter definition default value '' in function parameters; 2. The default value '' and insert or update value '' of the...

ivorysql：  oracle： 

When the type is nvarchar2, the result of using the lengthb function is inconsistent with Oracle

1

for example： ivorysql： SELECT lengthb(cast('Highgo DB!' as nvarchar2(20))) from dual;  oracle： SELECT lengthb(cast('Highgo DB!' as nvarchar2(20))) from dual;