xxxx.scr select * from abc; exit Use Oracle user, and run the following command sqlplus -S -M “HTML ON TABLE ‘BORDER=”2″‘” [username]/[password] @xxxx.scr > xxxxx.html
Reference: http://www.oracle.com/technology/pub/articles/saternos-ror-faq.html#4-4 Download ruby-oci8: http://rubyforge.org/frs/?group_id=256&release_id=31170 Download ruby-gems: http://rubyforge.org/frs/?group_id=126&release_id=27655 1. Install Ruby Installing Ruby on Linux requires a few extra steps that may not be familiar to those new to Linux. After downloading the appropriate files, follow the same basic steps of installing Oracle client software, Ruby, Gems, OCI8, and Rails (and its dependencies) described in [...]
Export data exp [username]/[password] tables=[tablename] file=xxxx.dmp Import data imp [username]/[password] file=xxxx.dmp
Start isqlplus isqlplusctl start or su – oracle cd /space/oracle/9.2.0/Apache/Apache/bin ./apachectl start Start Listener lsnrctl start
http://www.techonthenet.com/oracle/questions/script.php To execute a script file in SQLPlus, type @ and then the file name. SQL > @{path}{file}
