none
multiple SQL statements in dynamic SQL RRS feed

  • Question

  • Hello experts,

    is there a possibility in Oracle (in sybase and ms sql there is one) to place in dynamic query several SQL (e.g. SELECT) statements and to execute them additionally?

    Example:
    v_sqlQuery :='
    SELECT column_1
    FROM table_a

    SELECT column_1
    FROM table_b'
    open cv_1 for to_char(v_sqlQuery);

    or

    v_sqlQuery='
    SELECT x, y INTO #temp_table FROM table_x
    SELECT y FROM #temp_table';

    Thank you in advance!
    Thursday, November 22, 2007 4:27 PM