摘要：
string connStr = @"Data Source=XE;User ID=AI;password=sa"; OracleConnection conn = new OracleConnection(connStr); Ai dt = new Ai(conn); var result = from t in dt.Platform join c in dt.Car on t.PlatID equals c.PlatID ... 阅读全文
摘要：
https://forums.oracle.com/forums/thread.jspa?threadID=2177895&tstart=90As far as i have worked on EF4 using Oracle , Function importing doesn't seems to work here. I faced the same problem few months back and tried many ways to import a function but without any luck. But during searching I f 阅读全文
摘要：
createorreplace package body package_user AS PROCEDURE PERSON_QUERY(RS OUT MY_RESULTSET_CURSOR,C OUTINTEGER) AS BEGIN OPEN RS FORselect * from emp; update A set ename='AAA'; SELECTCOUNT(*) INTO C from emp; END PERSON_QUERY; END; 阅读全文
摘要：
alter table imcc.agentstatuslog add primary key (id)select count(1) from imcc.agentstatuslog where id is nulldelete from imcc.agentstatuslog where id is null 阅读全文