CTLLIN的专栏

Class.forName("oracle.jdbc.driver.OracleDriver");             conn = DriverManager.getConnection(                     "jdbc:oracle:thin:@localhost:1521:orcl", "scott", "Admin518");  create s

Windows Registry Editor Version 5.00[-HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE][-HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in OraDb11g_home1][-HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\

create user test identified by root;grant create session,resource to root;alter user test account unlock;grant create view to test;grant any sequece to test;grant create synonym to ich;--创建别

package com.ctl.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.Random;import java.util.concurrent.LinkedBlockingQueue;import java.ut

package com.ctl.util;import java.awt.Color;import java.awt.Font;import java.awt.Insets;import java.awt.event.MouseAdapter;import java.awt.event.MouseEvent;import java.io.*;import java.lang.ref

(1)、首先用 sqlplus /nolog 命令 (2)、然后用 connect sys/密码 as sysdba; 来进入oracle命令行中select userenv('language') from dual;shutdown immediate;停止oracle服务以及监听。如果服务停止，这部可省略 startup mount; alter system

Windows Registry Editor Version 5.00[-HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\OracleOraDb11g_home1TNSListener][-HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\OracleMTSRecoverySe

请输入用户名: sqlplus/as sys输入口令: passwordSQL> create user lin identified by 518;用户已创建。SQL> alter user lin account unlock;用户已更改。SQL> grant all privilege to lin;授权成功。SQL> grant

//注意:一定要添加这个://项目->添加引用->.NET->System.Data.OracleClient.dllusing System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.OracleClient;using System.Data;na

package connect.orcale;import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class li

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException;   public class Test {     public st

在cmd命令中输入sqlplus username/password@localhost/database例如 sqlplus scott/Admin518@localhost/ORCl即可进入oracle数据库然后出来sql>，就可以输入各种语句了select * from all_tables WHERE owner='SCOTT' ;//显示scott中所有的表CREAT

--root执行groupadd -g 1010 oinstallgroupadd -g 1020 dbauseradd -g oinstall -g dba -m oraclepasswd oracle--root执行----修改database的所有者 找到oracle11g的解压目录执行 chown -R oracle:dba database-