A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
EJB 3 in Action
this week in the
EJB and other Java EE Technologies
Linux / UNIX
database access in shell script
Joined: Nov 25, 2007
May 25, 2008 23:51:00
Can I access data base in shell script?
Joined: Jun 25, 2001
May 26, 2008 06:23:00
You certainly can. Almost all DBMS's have some sort of command-line utility and many of them are even powerfule enough to generate reports, HTML pages and even XML.
For the PostgreSQL DBMS, the basic command-line tool is "psql". For MySQL, it's "mysql". For Oracle, it's "sqlplus". I forget what DB2 uses.
For SQL Server, the command line tool is iSql, but of course, you have to be running a Windows client in order to use it. Microsoft lives in their own little world.
Customer surveys are for companies who didn't pay proper attention to begin with.
I agree. Here's the link:
subject: database access in shell script
read large CSV file and update the database
what shell is this
Running Unix commands thru Java
How can I apply a XSL to the result of another XSL?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014