daoshud1的专栏

oracle查询数据库连接数：select username,count(username) from v$session where username is not null group by username;

首先要登录导入的用户 选择 工具选择导入表选择需要导入的文件即可   大小: 10.1 KB 大小: 7.5 K

修改列类型alter table met_down modify model varchar2(50);增加一列alter table met_page add(vendor varchar2(50));去空格select replace(name,' ','') from tablename

第一步要先建立包create or replace package pkg_query istype cur_query is ref cursor;procedure met_down_query( m_tablename in varchar2,--表名 m_strwhere in varchar2,--查询条件 m_ordercolumn in varcha

Oracle数据库中的Blob字段转成字符串的函数：1、Utl_Raw.Cast_To_Varchar2(blob_var)只支持Blob长度小于2000的字段：[code="java"]--Mysql Select Count(*) From Score_News_Online A Where A.Onlineflag=1 And Trim(Unhex(Hex(A.Onetitl...