DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Scripting Tools

  1. #1
    Join Date
    Feb 2014
    Posts
    4

    Question Scripting Tools

    What are some of the scripting tools commonly used in the industry?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by rishwish View Post
    What are some of the scripting tools commonly used in the industry?
    You need to start with what OS and version of Oracle you are using. Mostly the OS though. You should also mention any scripting tools that you have already used. However, if you use Linux or a more recent version of Unix, then you should start by learning Bash. You can do just about anything that you want with Bash. If there is something specific that Bash doesn't give you then there is either a Perl "one-liner" that you can find from Google, or a Perl library with numerous code examples.

    If you are using Windows, then you should download and install Cygwin for Windows. Then make sure that the C:\Cygwin\bin directory is always in your path. Assuming you install Cygwin to C:\Cygwin. Cygwin is not as good as Bash, but it allows you to do things that you can't do without Bash. With Cygwin utilities you need to use the Cygwin directory structure shown below. pwd is the command to show the current path.

    C:\Windows\system32>pwd
    /cygdrive/c/Windows/system32

    Then you need to look at other peoples code, try to understand all of the Linux commands and try writing your own scripts.
    Just don't start with writing scripts that do destructive things like delete, move files, etc. And find, grep, sed and awk are
    your friends use them often.

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Quote Originally Posted by rishwish View Post
    What are some of the scripting tools commonly used in the industry?
    Top tool is: vi
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by LKBrwn_DBA View Post
    Top tool is: vi
    vi?!?!?!?! Why not vim?
    That's fine as long as you aren't one of those emacs people!

  5. #5
    Join Date
    Feb 2014
    Posts
    4
    Thank you gandolf. I am a rookie and everything you said above is extremely helpful. Mucho Thanks!

  6. #6
    Join Date
    Feb 2014
    Posts
    4
    Thank you LKBrwn

  7. #7
    Join Date
    Feb 2014
    Posts
    4
    Thank you for all your help guys!

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