Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database access in shell script

 
Minal Silimkar-Urankar
Ranch Hand
Posts: 136
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can I access data base in shell script?
 
Tim Holloway
Saloon Keeper
Pie
Posts: 18152
52
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic