ChinaUnix.net
相关文章推荐:

oracle 查询 表的 对象id

A id name 1 tom 2 jack 等等记录 B id1 id2 mess 1 2 某某说明 如何写个sql查询得到 ‘tom, jack,某某说明’ 这样的记录呢?

by wienne - MySQL - 2005-12-31 19:28:46 阅读(853) 回复(0)

相关讨论

用户aa中有一些被授权查询,我怎么知道那些被授权给了此用户。

by 余金 - Oracle - 2005-03-02 16:25:14 阅读(1801) 回复(2)

$ sqlplus "/as sysdba" Connected to: oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> select * from sm$ts_used; TABLESPACE_NAME BYTES ------------------------------ ---------- SYSTEM 510197760 USERS 3080192 TBS_1 ...

磁盘阵列

by xiaomao2006 - 存储文档中心 - 2008-02-02 12:38:10 阅读(758) 回复(0)

[code] if(!conn->;IsConnected()) { connect(conn) } OCIStmt* stmthp; stmthp=NULL; char query[2048]; char err_msg[512]; char* name; tableName=new char[32]; sprintf(query,"Select LAYERNAME From TABLE1"); OCIHandleAlloc((dvoid *)conn->;envhp, (dvoid **) &stmthp, (ub4) OCI_HTYPE_STMT, (size_t) 0, (dvoid **) 0); OCIStmtPrepare(stmthp, conn->;errhp, (t...

by tonyutada - Oracle - 2004-06-25 16:38:39 阅读(700) 回复(0)

请问如何在oracle中用sql语句查询某个空间中包含那些?谢谢了

by seanyu - Oracle - 2006-06-19 14:47:07 阅读(2245) 回复(2)
by anqua - Oracle - 2004-07-20 21:29:36 阅读(6409) 回复(7)
by tongyan - Oracle - 2005-11-10 13:30:19 阅读(974) 回复(4)

我要查一个中的两个属性需要什么语句 如我要查POLE中的POLE_CODE和BUILD_UNIT如何查

by georgewcl - Oracle - 2003-08-06 21:50:44 阅读(750) 回复(2)

名每天都变化,如abc0601 abc0602,abc0603等 想写一个脚本,每天定时运行,查询前一天中的数据,请问如何在oracle中根据时间查询 如select * from

by emperoryang - Oracle - 2009-06-02 17:58:42 阅读(1342) 回复(3)

我用java程序查询oracle数据库的v$session,select * from v$session; 但是返回有问题。请各大侠不吝赐教。 [code]java.sql.SQLException: ORA-00600: 内部错误代码,参数: [ttcgcshnd-1], [0], [], [], [], [], [], [] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdb...

by YeLLoW - Java - 2007-01-22 14:06:53 阅读(1489) 回复(2)

google无果,遂求教,谢谢! [ 本帖最后由 niuji 于 2006-8-15 10:09 编辑 ]

by niuji - Oracle - 2006-08-15 11:14:25 阅读(6274) 回复(2)