Deveel.Data.Sql.Statements.PlSqlBlockStringFormatTests.CodeBlock_Nolabel C# (CSharp) Method

        public static void CodeBlock_Nolabel()
        {
            var block = new PlSqlBlockStatement();
            block.Statements.Add(new AssignVariableStatement(SqlExpression.VariableReference("a"), SqlExpression.Constant(2)));

            var sql = block.ToString();
            var expected = new StringBuilder();
            expected.AppendLine("BEGIN");
            expected.AppendLine("  :a := 2");
            expected.Append("END");

            Assert.AreEqual(expected.ToString(), sql);
        }