查询oracle中所有用户信息 1. 查询oracle中所有用户信息 select * from dba_users; 2. 只查询用户和密码 select username,password from dba_users; 3. 查询当前用户信息 select * from dba_ustats; 4. 查询用户可以访问的视图文本 select * from dba_varrays; 5. 查询数据库中所有视图的文本 select * from dba_views;
oracle 查询oracle数据库 select name from V$database(select * from dba_users where username='GXPT') 查询oracle中所有用户信息 1. 查询oracle中所有用户信息 select * from dba_users; 2. 只查询用户和密码 select username,password from dba_users; 3. 查询当前用户信息 select * from dba_ustats; 4. 查询用户可以访问的视图文本 select * from dba_varrays; 5. 查询数据库中所有视图的文本 select * from dba_views;查询表名 select * from dba_tables where owner =(select username from dba_users where username='GXPT')查询列名 select * from user_tab_columns where table_name=(select table_name from dba_tables where owner =(select username from dba_users where username='GXPT') and table_name='GXPT')
string conn="Data Source="+a+"; Integrated Security=SSPI;Initial Catalog="+b;
为a、b赋值就行了
a=textBox1.text;b=textBox2.text;
string conn="Data Source="+a+"; Integrated Security=SSPI;Initial Catalog="+b;
string comm1 = "SELECT * FROM users";
SqlDataAdapter da = new SqlDataAdapter(comm1,conn);
DataSet ds = new DataSet();
da.Fill(ds,"users");或者string conn="Data Source="+textBox1.text+"; Integrated Security=SSPI;Initial Catalog="+textBox2.text;
string comm1 = "SELECT * FROM users";
SqlDataAdapter da = new SqlDataAdapter(comm1,conn);
DataSet ds = new DataSet();
da.Fill(ds,"users");
抱歉,代码在家里,现在没有
http://topic.csdn.net/t/20041127/10/3593330.html
1. 查询oracle中所有用户信息 select * from dba_users; 2. 只查询用户和密码 select username,password from dba_users; 3. 查询当前用户信息 select * from dba_ustats; 4. 查询用户可以访问的视图文本 select * from dba_varrays; 5. 查询数据库中所有视图的文本 select * from dba_views;
查询oracle数据库
select name from V$database(select * from dba_users where username='GXPT')
查询oracle中所有用户信息
1. 查询oracle中所有用户信息 select * from dba_users; 2. 只查询用户和密码 select username,password from dba_users; 3. 查询当前用户信息 select * from dba_ustats; 4. 查询用户可以访问的视图文本 select * from dba_varrays; 5. 查询数据库中所有视图的文本 select * from dba_views;查询表名
select * from dba_tables where owner =(select username from dba_users where username='GXPT')查询列名
select * from user_tab_columns where table_name=(select table_name from dba_tables where owner =(select username from dba_users where username='GXPT') and table_name='GXPT')