![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Database
sinat_40251690
这个作者很懒,什么都没留下…
展开
-
SQL Exists Condition
The exists condition is considered to be met if the subquery returns more than one row. It always used to test whether relevant recrods exist and filter out those extraneous results. The common case...原创 2012-01-17 17:54:38 · 89 阅读 · 0 评论 -
SQL Transaction Isolation Level
Introduction Transaction is a mechanism to ensure a bunch of database operations be performed in an atomic way. Either all of the operations succeed(committed) or nothing will be persisted(rollback)....原创 2011-12-10 17:38:30 · 115 阅读 · 0 评论 -
How to change the XMLDB Http and FTP Ports for Oracle
To change the HTTP and FTP ports for Oracle XMLDB, we only need to call the following command in Oracle with DBA role. change HTTP port from 8080 to 9999 call dbms_xdb.cfg_update(updateXM...原创 2012-11-10 12:18:08 · 87 阅读 · 0 评论 -
TNS:no appropriate service handler found
Error Message: Caused by: java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the ...原创 2012-11-16 16:47:53 · 97 阅读 · 0 评论 -
Oracle Common Commands
Import/Export Database: exp username/password@tns name FILE=D:\pub.dump OWNER=(username) imp username/password name FILE=D:\pub.dump TOUSER=(username) FROMUSER=(username) Query all users i...原创 2012-11-16 16:53:22 · 80 阅读 · 0 评论