-- 查询表中字段注释
select *
from user_col_comments
where Table_Name='sb_sbxx'
order by column_name;
-- 将sb_ysbtj表的权限给予zw_dxpt
grant select,insert,update,delete on sb_ysbtj to zw_dxpt;
--获取某个字段位置和截取
SELECT SB_YSBTJ.NSSBRQ,SB_YSBTJ.LRRQ
FROM SB_YSBTJ--for update
WHERE NSSBRQ is NULL
AND (substr(lrrq,4,3) = substr(trunc(sysdate, 'mm'),4,3)
OR substr(lrrq,4,3) < substr(trunc(sysdate, 'mm'),4,3));
-- 查询某个表属于某个用户(dba登陆)
select owner from dba_tables where table_name=upper('dj_nsrxx_kz')
-- 修改表中某个属性
alter table dxpt_dxcj modify cj_status default '0';
-- 查询本用户的表,视图等(所有用户改用 all_tab_comments )
select * from user_tab_comments where table_name like 'DXPT%';
select *
from user_col_comments
where Table_Name='sb_sbxx'
order by column_name;
-- 将sb_ysbtj表的权限给予zw_dxpt
grant select,insert,update,delete on sb_ysbtj to zw_dxpt;
--获取某个字段位置和截取
SELECT SB_YSBTJ.NSSBRQ,SB_YSBTJ.LRRQ
FROM SB_YSBTJ--for update
WHERE NSSBRQ is NULL
AND (substr(lrrq,4,3) = substr(trunc(sysdate, 'mm'),4,3)
OR substr(lrrq,4,3) < substr(trunc(sysdate, 'mm'),4,3));
-- 查询某个表属于某个用户(dba登陆)
select owner from dba_tables where table_name=upper('dj_nsrxx_kz')
-- 修改表中某个属性
alter table dxpt_dxcj modify cj_status default '0';
-- 查询本用户的表,视图等(所有用户改用 all_tab_comments )
select * from user_tab_comments where table_name like 'DXPT%';