This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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: 15662
    
  15

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: http://aspose.com/file-tools
 
subject: database access in shell script
 
Similar Threads
How can I apply a XSL to the result of another XSL?
FTP
what shell is this
Running Unix commands thru Java
read large CSV file and update the database