Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011
    Posts
    32

    Cool Unanswered: is ORACLE like Function possible in DB2

    Hi All,

    In oracle , we can execute from sql prompt, the Following Command

    SQL>desc sapsr3.t000; or SQL>select mandt from sapsr3.t000;

    is the above sql commands possible in DB2,

    Table "t000" do exist in the db2 database



    Regards

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    select mandt from sapsr3.t000;
    This is a very simple query and almost every RDBMS will accept it.
    Where is special condition(or your worry)?

    desc sapsr3.t000;
    Try describe table sapsr3.t000;

Posting Permissions

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