1 // 查询所有表(分号一定要有)
2 select table_name from all_tables;
3 
4 // 查询用户下的所有表
5 select table_name from user_tables;
6 
7 // 显示表内数据
8 select * from myoracle;

 1 # listener.ora Network Configuration File: D:\MySoftware\app\gomez\product\12.1.0\dbhome_1\network\admin\listener.ora
 2 # Generated by Oracle configuration tools.
 3 
 4 SID_LIST_LISTENER =
 5   (SID_LIST =
 6     (SID_DESC =
 7       (SID_NAME = CLRExtProc)
 8       (ORACLE_HOME = D:\MySoftware\app\gomez\product\12.1.0\dbhome_1)
 9       (PROGRAM = extproc)
10       (ENVS = "EXTPROC_DLLS=ONLY:D:\MySoftware\app\gomez\product\12.1.0\dbhome_1\bin\oraclr12.dll")
11     )
12   )
13 
14 LISTENER =
15   (DESCRIPTION_LIST =
16     (DESCRIPTION =
17       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
18       (ADDRESS = (PROTOCOL = TCP)(HOST = WMW-PC)(PORT = 1521))
19     )
20   )

 1 # listener.ora Network Configuration File: D:\MySoftware\app\gomez\product\12.1.0\dbhome_1\network\admin\listener.ora
 2 # Generated by Oracle configuration tools.
 3 
 4 SID_LIST_LISTENER =
 5   (SID_LIST =
 6     (SID_DESC =
 7       (GLOBAL_HOME = orcl)
 8       (ORACLE_HOME = D:\MySoftware\app\gomez\product\12.1.0\dbhome_1)
 9       (SID_NAME = ORCL)
10     )
11     (SID_DESC =
12       (SID_NAME = CLRExtProc)
13       (ORACLE_HOME = D:\MySoftware\app\gomez\product\12.1.0\dbhome_1)
14       (PROGRAM = extproc)
15       (ENVS = "EXTPROC_DLLS=ONLY:D:\MySoftware\app\gomez\product\12.1.0\dbhome_1\bin\oraclr12.dll")
16     )
17   )
18 
19 LISTENER =
20   (DESCRIPTION_LIST =
21     (DESCRIPTION =
22       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
23       (ADDRESS = (PROTOCOL = TCP)(HOST = WMW-PC)(PORT = 1521))
24     )
25   )

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Text;
 5 using System.Threading.Tasks;
 6 using System.Data.Odbc;
 7 using Oracle.DataAccess.Client;
 8 
 9 namespace ConsoleApplication1
10 {
11     class Program
12     {
13         static void Main(string[] args)
14         {
15             // 连接数据库
16             string conn = "DATA SOURCE=ORCL;PERSIST SECURITY INFO=True;USER ID=SYSTEM;Password=Oracle12c";
17             OracleConnection odpCon = new OracleConnection(conn);
18             odpCon.Open();
19 
20             // 插入数据
21             string sqlinsert = "insert into myoracle values(6,'yh')";
22             using (OracleCommand comm_insert = new OracleCommand(sqlinsert, odpCon))
23             {
24                 using (OracleDataReader rdr_insert = comm_insert.ExecuteReader())
25                 {
26 
27                 }
28             }
29 
30             // 查询数据
31             string sqlselect = "select * from myoracle";
32             using (OracleCommand comm = new OracleCommand(sqlselect, odpCon))
33             {
34                 using (OracleDataReader rdr = comm.ExecuteReader())
35                 {
36                     while (rdr.Read())
37                     {
38                         Console.Write("ID ");
39                         Console.Write(rdr.GetString(0));
40                         Console.Write(", NAME: ");
41                         Console.WriteLine(rdr.GetString(1));
42                     }
43                 }
44             }
45         }
46     }
47 }