ORA-00933: Oracle8i

Question

我想在Oracle 8i中使用join。我的问题如下。我使用一个join从两个表中获取数据，但是我得到了错误SQL command not properly ended。

    private List<StamfordProdRelease> GetStamfordProdReleases()
    {
        List<StamfordProdRelease> list = null;

        string srtQry = "SELECT NVL(NULL, 0) ID," +
        "                DLOG.RELEASEID AS RELEASE_BUILD," +
        "                TRUNC (DLOGDET.DEPLOYDATE) AS PROD_DEPLOY_DATE," +
        "                DLOGDET.DEPLOYREQUEST AS BAAR_RFD," +
        "                DLOG.FILENAMEEXT_VC AS SCRIPT_NAME," +
        "                DLOG.VERSION," +
        "                DLOG.REQUEST," +
        "                DLOG.NOTE AS COMMENTS" +
        "                FROM ADM_DEPLOYMENTLOGDETAIL DLOGDET" +
        "                JOIN ADM_DEPLOYMENTLOG DLOG ON DLOG.LOGNO = DLOGDET.LOGNO;";

        using (OracleConnection conn = new OracleConnection(Globals.Constants.AppConnectionStringReadOnly))
        {
            using (OracleCommand objCommand = new OracleCommand(srtQry, conn))
            {
                objCommand.CommandType = CommandType.Text;
                DataTable dt = new DataTable();
                OracleDataAdapter adp = new OracleDataAdapter(objCommand);
                conn.Open();
                adp.Fill(dt);
                if (dt != null)
                {
                    list = ConvertToStamfordProdRelease(dt).ToList();
                }
            }
        }
        return list;
    }

我的目标是将记录插入到表中。

Answer 1

不要把所有的字符串组合在一起。

Answer 2

将所有内容保存在一组"中，而且您只需要一个;就可以结束双引号之外的查询。

    private List<StamfordProdRelease> GetStamfordProdReleases()
    {
        List<StamfordProdRelease> list = null;

        string srtQry = "SELECT NVL(NULL, 0) ID, 
DLOG.RELEASEID AS RELEASE_BUILD, 
TRUNC (DLOGDET.DEPLOYDATE) AS PROD_DEPLOY_DATE, 
DLOGDET.DEPLOYREQUEST AS BAAR_RFD, 
DLOG.FILENAMEEXT_VC AS SCRIPT_NAME, 
DLOG.VERSION, 
DLOG.REQUEST, 
DLOG.NOTE AS COMMENTS 
FROM ADM_DEPLOYMENTLOGDETAIL DLOGDET 
JOIN ADM_DEPLOYMENTLOG DLOG ON DLOG.LOGNO = DLOGDET.LOGNO";

        using (OracleConnection conn = new OracleConnection(Globals.Constants.AppConnectionStringReadOnly))
        {
            using (OracleCommand objCommand = new OracleCommand(srtQry, conn))
            {
                objCommand.CommandType = CommandType.Text;
                DataTable dt = new DataTable();
                OracleDataAdapter adp = new OracleDataAdapter(objCommand);
                conn.Open();
                adp.Fill(dt);
                if (dt != null)
                {
                    list = ConvertToStamfordProdRelease(dt).ToList();
                }
            }
        }
        return list;
    }

Answer 3

Oracle8i不支持标准的ANSI SQL JOIN语法。

该特性在Oracle 9i第2版(又名Oracle 9.2)中引入。

引用“SQL引用中的新内容”一章

选择。具有新的符合ANSI的连接语法。