Skip to Content
author's profile photo Former Member
Former Member

DELETE RECORDS FROM A TABLE VARIABLE

Hi All,

What is the syntax for deleting records from a table type variable?

The statement DELETE FROM :TABLE_1; is giving a syntax error when used in the script based calc view.

Goutham

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Jul 24, 2014 at 03:20 AM

    You can not do DELETE, INSERT on intermediate table variables.

    Specify your exact requirement why you want to DELETE on intermediate table variable.

    If you want to delete certain rows then you must write it as SELECT condition itself.

    Add comment
    10|10000 characters needed characters exceeded