Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    113

    Unanswered: It is me again having multiple table deletion problems....

    DELETE from tinfo_req_hist i, tquery_text_hist q
    where i.caller_rec_no=q.caller_rec_no
    and i.info_req_no=q.info_req_no
    and i.caller_rec_no=8888
    and info_req_start_time='19-Aug-2004';

    I am getting the error ora-00933 sql command not properly ended.

    I have even tried to put a select in it:

    DELETE (select * from tinfo_req_hist i, tquery_text_hist q
    where i.caller_rec_no=q.caller_rec_no
    and i.info_req_no=q.info_req_no
    and i.caller_rec_no=8888
    and info_req_start_time='19-Aug-2004');

    and then I get the error

    ora-01752 cannot delete from view without exactly one key-preserved table

    Please help me.....

  2. #2
    Join Date
    Feb 2004
    Posts
    108
    What table you want to delete from ?

    DELETE FROM OnlyOneTable
    WHERE EXISTS ( YourJoinCondition )
    ... is this what you're trying to do ?

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    one table at a time my friend.
    ONE table ...
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Apr 2004
    Posts
    113

    Talking

    Thank you so much pinkadb and The Duck,

    I changed my query to one table and it is working nicely!!!!

    I want to be like you two when I grow up!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •