What’s your favorite shell in Windows?

I just wrote one of my first powershell script yesterday, it has a pretty nice syntax actually, and no need to download anything like cygwin or other unix-like shell to your PC.

PS> $stmt  = "set hea off`n"
PS> $stmt += "select 'hello world' from dual;"
PS> $res = ($stmt | sqlplus -s scott/tiger)
PS> $res

hello world

Pretty cool :-)

9 thoughts on “What’s your favorite shell in Windows?”

  1. One I like is

    PS> $dbs = ‘db1 db2 db3 db4′.split()
    PS> $dbs | foreach { ‘select count(*) from v$session;’ | sqlplus -s system/pw@$_ }

    Neat :-)

  2. Laurent & Paul. Thanks for sharing this. Will make my life easier on windows to control remote databases ;)

  3. I learnt a lot in the last week… from changing the icon to manipulating the clipboard, and all test different functions, it is really cool and the resource on the web are immense !

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>