Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2002
    Posts
    98

    Unanswered: execute unix command in sqlplus

    how can I execute unix command in sqlplus?
    for example, if i want to copy a file to another in sqlplus, or display the UNIX date value?

    Thanks

    mark

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    host

    Use "HOST" or "!";


    [SYSTEM@ORCL.WORLD]
    SQL> HOST date
    Mon Nov 17 10:47:06 WEST 2003



    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Nov 2002
    Posts
    98
    is this the same command if i want to invoke some program at the server side?

    eg. i am at a windows terminal doing an update, and a trigger will invoke some program at the server side?

  4. #4
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    NO

    No

    It's CLIENT side.



    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296

    Re: host

    Originally posted by remivisser
    Use "HOST" or "!";

    [SYSTEM@ORCL.WORLD]
    SQL> HOST date
    Mon Nov 17 10:47:06 WEST 2003

    Remi
    Wow, I did not know this.
    Awesome.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Nov 2002
    Posts
    98
    I guess what i want to ask is:

    is there a command that invoke server-side program instead of client-side program?

Posting Permissions

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