摘要：
/* 获取字符串长度函数：length（char）select bookname ,length(bookname) from bookinfo; *//* 去除字符串首尾指定字符函数：trim([leading|trailing|both] [trim_character From] trim_source)select b_price2,length(b_price2),length(trim(b_price2)) from books5;leading 前缀字符trailing 后缀字符both 前后trim_character From 要删除的指定字符串select trim(tra 阅读全文
摘要：
/* sqlplus blis/blis@tbls40 @test.sq; *//* create table persons(id number(2),lastname varchar2(15),firstname varchar2(15));create table team(id number(2),teamname varchar2(15),teamleader varchar2(15)); *//* insert into persons values ('2','Adams','John');insert into persons v 阅读全文