问题是:把职工信息表中的职工姓名的姓改为另一个.如:把张某改为王某,只改姓而不改名字:
update 表名 set 字段名 = '王' || substr(字段名,2,length(字段名)) where 字段名 like '张%';
表名是recv，里面有字段no让no字段为递增:
create sequence
start with 1
increment by 1;
查询所有用户表及其相应字段的类型:
select *From user_tab_columns;
Oracle使用SQL查询表字段列的备注信息:
select comments
from user_col_comments
where table_name = 'dept'
and column_name = 'DEPTNO';
用SQL语句获取Oracle指定表的表结构:1、SELECT * FROM ALL_TAB_COLUMNS where owner='USE1' and table_name ='B'; 2、desc 表名 3、SELECT column_name AS FIELDNAME,data_type AS TYPE,data_length AS SIZE,nullable AS ISNULL FROM user_tab_columns where table_name = 'tablename'
Oracel中查询用户表中某表某列的字段类型:
select *from user_tab_columns where table_name='dept' and column_name='DEPTNO';
