怎么知道我当前使用的数据表是属于哪个数据库中的 。。oracle;
解决方案 »
- 【求助】关于一对多表关联的查询问题,详细如下
- 请问这是为什么呢,为什么不只返回一行
- slf4j-nop-1.6.4.jar 和 slf4j-nop-1.6.4-sources.jar有什么不同
- 用户不存在?
- 请高手帮忙:还是10g ora-00205错误!!!!!!!!!!!!!!!!!!!!!!
- 如何直接修改oracle数据文件恢复被delete掉的记录
- oracle中sql语句出错!在线等,求救!
- 这个问题如何写sql语句
- 一个小小的查询就是出错~!高手速来帮忙~!
- 新手向各位大虾求救:启动oracle 8.1.5的server manager的问题
- oracle sql与标准的sql语句的区别?
- pl/Sql小编程
这些工具一登陆就要让你选用户!
懂了吗
在SQL/PLUS中:
conn / as sysdba;
select INSTANCE_NAME from v$instance;
已连接。
SQL> select INSTANCE_NAME from v$instance;INSTANCE_NAME
----------------
zy
还是看不懂,zy是一个数据库实例?
$sql="select * from login where userName='".$_POST['txtName']."'and usePwd='".$_POST['txtPwd']."'";
$user = 'scott';
$pass = 'oracle';
$conn =ocilogon($user, $pass,'orcl');//连接oracle数据库这里的ocilogon的第三个参数是些数据库的实例名吗?
Not logged onSQL> connect cvbom/******@oamis as sysdba
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as SYSSQL>
SQL> select *
2 from sys.obj$
3 where name = 'DEPT'
4 and type# = 2
5 ; OBJ# DATAOBJ# OWNER# NAME NAMESPACE SUBNAME TYPE# CTIME MTIME STIME STATUS REMOTEOWNER LINKNAME FLAGS OID$ SPARE1 SPARE2 SPARE3 SPARE4 SPARE5 SPARE6
---------- ---------- ---------- ------------------------------ ---------- ------------------------------ ---------- ----------- ----------- ----------- ---------- ------------------------------ -------------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------
30137 30137 59 DEPT 1 2 2002-5-12 2 2002-5-12 2 2002-5-12 2 1 0 6 1
30308 30308 61 DEPT 1 2 2009-3-13 1 2009-3-13 1 2009-3-13 1 1 0 6 1 SQL>
SQL> select *
2 from (select *
3 from sys.obj$
4 where name = 'DEPT'
5 and type# = 2) obj,
6 sys.user$ usr
7 where obj.owner# = usr.user#
8 and usr.name = 'CVBOM'; OBJ# DATAOBJ# OWNER# NAME NAMESPACE SUBNAME TYPE# CTIME MTIME STIME STATUS REMOTEOWNER LINKNAME FLAGS OID$ SPARE1 SPARE2 SPARE3 SPARE4 SPARE5 SPARE6 USER# NAME TYPE# PASSWORD DATATS# TEMPTS# CTIME PTIME EXPTIME LTIME RESOURCE$ AUDIT$ DEFROLE DEFGRP# DEFGRP_SEQ# ASTATUS LCOUNT DEFSCHCLASS EXT_USERNAME SPARE1 SPARE2 SPARE3 SPARE4 SPARE5 SPARE6
---------- ---------- ---------- ------------------------------ ---------- ------------------------------ ---------- ----------- ----------- ----------- ---------- ------------------------------ -------------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------- ---------- ------------------------------ ---------- ------------------------------ ---------- ---------- ----------- ----------- ----------- ----------- ---------- -------------------------------------- ---------- ---------- ----------- ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- ---------- ---------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------
30308 30308 61 DEPT 1 2 2009-3-13 1 2009-3-13 1 2009-3-13 1 1 0 6 1 61 CVBOM 1 A15041D3AB216019 12 2 2009-3-13 9 2009-3-13 9 0 1 0 0 DEFAULT_CONSUMER_GROUP SQL>
SQL> disconnect
Not logged onSQL>