Login or Register to Ask a Question and Join Our Community


Programming

Shell programing to implement SQL package

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Programming Shell programing to implement SQL package
# 1  
Old 08-10-2010
Shell programing to implement SQL package
hi all,
i have a table with employee details like his name,addr,DOB etc.
i need a shell program which takes one date as input from user and print the employees whose DOB is less than that date.
in sql package the select query is written
# 2  
Old 08-10-2010
Hi

You can check for the examples here: connect to sqlplus and retrieve data and modify according to your needs.

Guru.
# 3  
Old 08-10-2010
If I understood you correctly, and your data resides in a text file, shql can help you with this, it is a simple SQL engine written as a shell script. You can get it from here
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to implement one check in shell script

Hi, I am facing one issue.I am working on one script where I want to implement one check PSS/TFM/Coupon/trunk/CouponProject/CouponService/src/test/java/com/travelport/service/pss/coupon/validator/CouponValidationReqValidatorTest.java Now my problem is or requirement is if the above... (1 Reply)
Discussion started by: anuragpgtgerman
1 Replies

2. Homework & Coursework Questions

need help with shell programing script

1. The problem statement, all variables and given/known data: Write a Shell script to automatically check that a specified user is logged in to the computer. The program should allow the person running the script to specify the name of the user to be checked, the frequency in seconds at... (5 Replies)
Discussion started by: operator
5 Replies

3. Shell Programming and Scripting

Select query implement in a shell

I have been asked to create a shell script that accepts a number of SQL select queries as input, runs them in sequence, spools the output to an EXCEL workbook, where, each worksheet is an output of a Select statement run above. The workbook should be in a .XLS format. If a particular select... (2 Replies)
Discussion started by: ShellNovice1
2 Replies

4. Shell Programming and Scripting

Shell quiz: implement a mutex

How would you make sure that a shell script (or a portion thereof) does not run (it waits or it terminates with error) when another instance of it is already running? (11 Replies)
Discussion started by: colemar
11 Replies

5. Shell Programming and Scripting

Shell Programing with awk Tool

I'm working on a program in with shell programming and it needs to be able to delete the contents of files in the Home directory on certain days of the week.(like tuesday). Can anyone help me with this? Thanks in advance, Taffy. (7 Replies)
Discussion started by: Taffy
7 Replies

6. Shell Programming and Scripting

shell programing...

Hi... i need to write a shell script wich shows the full name and station of every logged user in the system. pls help! (1 Reply)
Discussion started by: relu89
1 Replies

7. Programming

A C++ programing Shell on Win

Hello I need to translade the power of unix command shell (grep, sed, awk, wc, etc..) to windows. In my work every day I administrate 15 unix server ans 18 windows server, and I have the problem the absolutly limitation of windows shell. I´m a system administrator but I know programming. I... (2 Replies)
Discussion started by: dalmus
2 Replies

8. Linux

Linux game programing or just shell scripting

Well Acording to my job... Anyhelp plz. I need some basic scripting stuff. (3 Replies)
Discussion started by: Irish Jimmy
3 Replies

9. Shell Programming and Scripting

Editing files in shell programing

Hi folks, In our product installation program we edit xml files by deleting lines and appending new lines instead of them. For example: update_Log4plsql_xml() { machineName=`uname -n` hostIP=`cat /etc/hosts | grep ${machineName} | cut -f1` trap 'clean_up | tee -a $installLog ; exit' 1 2... (0 Replies)
Discussion started by: nir_s
0 Replies

10. Shell Programming and Scripting

mutex in shell programing

A shell in crontab per 5 min write a file B shell in crontab per 6 min read a file how to lock the share file a ;avioid confilict in write and read? Thx : -) (1 Reply)
Discussion started by: zz_xm
1 Replies
Login or Register to Ask a Question