$sqlplus /nolog
SQL>conn user/password@service [as sysdba/sysoper]或
$sqlplus "user/password@serivce [as sysdba/sysoper]"
SQL>conn user/password@service [as sysdba/sysoper]或
$sqlplus "user/password@serivce [as sysdba/sysoper]"
解决方案 »
- 求一个应该很常见的SQL~
- select语句中的表名能不能用变量或者参数传递
- oracle9i中文教程
- [help]怎么建个表,数据是update的数据
- 谁有10204_vista_w2k8_x64_production_client.zip?
- 急急急,查詢結果格式顯示問題 在線等,請幫忙看看 謝謝
- 请问:删除表中的记录,为什么表空间的占用率没有变化?
- oracle中显示时间格式
- ora-12571怎么处理
- oracle 怎么实现update set
- 请各位高手帮一下忙,在oracel数据库里的表里,我怎样才能选择最前的或最后的5条记录呀?在线等你们的回复
- java 里头对ORACLE中的自增字段如何插入呀?
如果是从前台程序如java,delphi则要配置相关jdbc或者ado驱动
--参考:--模块
Public Conn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public cmd As New ADODB.CommandPublic Function DBPath() As String
'DBPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\inventory_MS.mdb"
DBPath = "Provider=MSDAORA.1;Password=romasys;User ID=apps;Data Source=demo;Persist Security Info=True"
End Function
Private Sub Form_Load()
On Error GoTo Err
Dim ConnStr As String
ConnStr = DBPath
With Conn
.ConnectionString = ConnStr
.ConnectionTimeout = 10
.CursorLocation = adUseClient
.Open
End With
Set cmd.ActiveConnection = Conn
cmd.CommandText = "select * from t_User"
rs.CursorLocation = adUseClient
rs.Open cmd, , adOpenStatic, adLockBatchOptimistic
rs.MoveFirst
Exit Sub
Err:
MsgBox ("连接数据库失败!")
End
End Sub