oracle/SQL server笔记(二)
整数位,
b.DATA_SCALE 小数位,
a.comments 列描述
from all_col_comments a,all_tab_columns b,all_tab_comments c
where a.table_name=b.TABLE_NAME and a.table_name=c.table_name
and a.column_name=b.COLUMN_NAME
and a.owner=b.OWNER and a.owner=c.owner
and lower(a.table_name)='表名'
--create user yuan identified by orcl account unlock
--grant create session to yuan
--create role name
--create Table T_a
--(
--name char(50),
--age int
--);
--drop user yuan
desc T_a
create table T_calendar
(
dateid number(8),
dateItem date constraint nn_calendar_dateItem not null,
itemcount number(3),
constraint pk_calendar_calendar primary key(dateid ),
constraint ck_itencount check(itencount > 0)
);
string connectionString = ConfigurationManager.ConnectionStrings["orcl"].ConnectionString; www.2cto.com
//连接
数据库
Oracle.DataAccess.Client.OracleConnection connection
= new Oracle.DataAccess.Client.OracleConnection(connectionString);
try
{
connection.Open();
Console.WriteLine("连接成功");
}
catch (Oracle.DataAccess.Client.OracleException e)
{
Console.WriteLine(e.Message);
}
finally
{
connection.Clone();
Console.WriteLine("关闭成功！");
}
}
作者 勇往直前102002