Results 1 to 2 of 2

Thread: hello

  1. #1
    Join Date
    Oct 2005
    Posts
    92

    Unanswered: hello

    HI All

    i have a query

    select directory_nm, file_nm from file control;

    result:

    directory_nm file_nm

    /home/ss abc
    /home/kk xyz
    /home/kg stz


    but my requirement is:

    result:

    /home/ss abc
    /home/kk xyz
    /home/kg stz

    i do not want directory_nm and file_nm to be on the result. i am looking only for below in the result.

    /home/ss abc
    /home/kk xyz
    /home/kg stz

    can anyone help me how to change my sql query to get the above result.

    thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You could try with SET HEADING OFF before executing the query.

Posting Permissions

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