Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Location
    India
    Posts
    40

    Unanswered: Suggest pl/sql code for my sql code

    Hi all....

    I have following Query in .sql file and displays all the cd if that condition was ok...

    Now i have to use some of the PL/SQL features for this ... so can any one help me what best i can use PL/SQL feature for this...

    =======================
    SELECT cd
    FROM itm
    WHERE cd||
    des||
    id||
    sh||
    id2||
    siz
    LIKE '%~%' or
    cd||
    des||
    id||
    sh||
    id2||
    siz
    LIKE '%^%'
    ORDER BY cd;
    =======================

    thanks
    Suryadevara

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    58
    Why do you need the PL/SQL exactly? If you absolutely must do the same thing in PL/SQL then just create a cursor with your select statement and do the dbms.output putlime thing inside a loop displaying all values in the cursor till you reach the end of the cursor.

Posting Permissions

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