oracle 6i..set_block_property
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle 6i..set_block_property

  1. #1
    Join Date
    Dec 2005
    Posts
    2

    Question oracle 6i..set_block_property

    i've tried to display a few records for a particular emp_id.if i wanted to display the records in la_date desc what should i write.

    SET_BLOCK_PROPERTY
    ('leave_appl',DEFAULT_WHERE,'emp_id='||:PARAMETER.teka);

    is there ordery by clause in set_block_property??

    set_block_property
    ('leave_appl',DEFAULT_order_by,'la_date='||desc);

  2. #2
    Join Date
    Jan 2006
    Posts
    1
    set_block_property
    ('leave_appl',order_by,column);

Posting Permissions

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


Click Here to Expand Forum to Full Width