aspose file tools*
The moose likes Linux / UNIX and the fly likes database access in shell script Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » Linux / UNIX
Bookmark "database access in shell script" Watch "database access in shell script" New topic
Author

database access in shell script

minal silimkar
Ranch Hand

Joined: Nov 25, 2007
Posts: 133
Can I access data base in shell script?


Minal Silimkar
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16065
    
  21

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: database access in shell script