Refresh Your Java - Before Java Interview
We are Agile, believe in less Documentation - Only Quick notes (Java Interview Questions) of Java/J2ee Read more....
This is sample Shell Script gives us an idea on how
to write a
Shell Script to Run a SQL Script.
Please examples meant for giving an idea , you need to
customize these
your needs.
RunSQL.sh:
setenv ORACLE_HOME
/export/apps/oracli/cust/10.1.0.3
setenv
TNS_ADMIN /export/apps/oracli/cust/admin/network
setenv PATH
/export/apps/oracli/cust/10.1.0.3/bin:${PATH}
setenv LD_LIBRARY_PATH
/export/apps/oracli/cust/10.1.0.3/lib
sqlplus @[DB_USER]@@[DB_INSTANCE_NAME]/@[DB_PWD] @$HOME/bin/ProductLoad.sql
ProductLoad.sql :
delete "SalesOrder"."SELR_SRVR";
insert into
"SalesOrder"."SELR_SRVR"
select unique PRODUCT_ID,
PRODUCT_NME,NVL(SUBSTR(ENTY_NO,1,5),PRODUCT_ID),NVL(ENTY_NME,SUBSTR(PRODUCT_NME,1,60)),
PRNT_SELR_STAT,PRNT_SRVR_STAT from
SalesOrder.X_SELR_SRVR_STGG
where PRNT_SELR_STAT = 3 or
"PRNT_SRVR_STAT" = 5;
exit
This Portal is intended to put all Java/J2ee related topics at one single place for quick referance, not only Technical , but also the Project Management Related thing such as Development Process methodoogies build process, unit testing etc.,
This Portal has More than 500 Java Interview Questions (also could be Considered as Quick Notes) very neatly separated topic by topic with simple diagrams which makes you easily understandable. Importantly these are from our Realtime expericance.