Hi,
I want to extract data from database table to a flat file using shell scripting. For loading data from file to a table, I had used SQL Loader. How can I do the vice versa using shell scripting.
Thanks in advance (3 Replies)
Hi,
I have a file that has contents like this:
SQL> select * from details;
NAME REG
-------------------- ----------
Mani 1
Santosh 2
Manju 3
Mukesh 4
SQL> spool off;
... (5 Replies)
hi
iam new of scipiting.give me the some Material of regarding sql in scripting.
and i have no backup's in 3 severs.how to write script in dirctory.
please give me some usefull information
cheers
Naveen.g (2 Replies)
Hi,
I am looking for some books that have examples of both Oracle SQL and Shell script being used together. For example, to insert 500 rows into a table using a script. I already have books that cover Shell scripting or SQL, but as separate subjects. I am looking for books that have both of... (3 Replies)
Hi,
I need to write a shell script file that does
1)Connects to DB using SQL plus
2)Do some SQL query like select * from....
3)Based on the output that I got from the sql query I will have to write a if else loop.
Plz let me know how to write the shell scripting for this.
Thanks for... (1 Reply)
I am trying to assgn the output of the select statement to a variable, like this
"VARIABLE_NAME=$ db2 "select COLUMN_NAME_1 from TABLE_NAME where COLUMN_NAME_2='VALUE_TO_CHECK'"; "
but the value that is getting into VARIABLE_NAME is
"COLUMN_NAME_1
-----------------
VALUE
1... (3 Replies)
HI friends , i am also facing an issue in mysql
i ma trying to insert detail in a variable but not got success
#!/bin/sh
mysql -u<username> -p<password> <dbname> << EOF
DEV=`mysql --skip-column-names <dbname> -e "SELECT timestamp from process_record where id = 1"`
EOF
echo $DEV
ERROR... (3 Replies)
hey i am using this code to connect to sql , store the value in variable and then
compare it with another variable after some time by executing the same query
but the desired result is not coming
#!/bin/bash
val=$(sqlplus -s rte/rted2@rel76d2 <<ENDOFSQL
set heading off
set feedback off... (11 Replies)
I have a situation where I have a list of airplanes that make a series of flights.
Therefore I am looking up the different flights that each airplane makes based on a postgres sql query:
select flightid from plane where airplane='DELTAx'
As a result I get a series of flight numbers... (0 Replies)
Can anyone please assist me?
I have attached 2 input files and one output file. I need to generate the sql update statements using the above 2 input files. if inputfile2 has 5 rows, then we should generate 5 update statements because column1 is unique. inputfile1 and inputfile2 may contain more... (10 Replies)
Discussion started by: vinus
10 Replies
LEARN ABOUT DEBIAN
val-and-rick
Val & Rick(6) Val & Rick(6)NAME
val-and-rick - shooter game
DESCRIPTION
Val and Rick is probably the precursor to Gunroar, featuring similar controls but in a different environment. Only 2D sprites and back-
grounds are used in what seems like a tribute to Xevious and Star Soldier.
OPTIONS
These options are available:
-brightness n
Set the brightness of the screen.(n = 0 - 100, default = 100)
-luminous n
Set the luminous intensity.(n = 0 - 100, default = 50)
-nosound
Stop the sound.
-window
Launch the game in a window.
-fullscreen
Launch the game in fullscreen.
-res width height
Sets the resolution of the screen in pixels.
-nosound
-nowait
-accframe
USAGE
Press the Z key to shoot and hold down the X key to fix the direction of your aim.
A power-up icon in the shape of a tiny ship named Rick will appear if you collect enough blue orbs from defeated enemies, which is indi-
cated at the bottom left of the screen. This will cause your ship to go into hyperdrive, that is until all energy is spent or your space-
craft takes damage from enemy bullets. Each successful hyperdrive attempt increases the counter by another hundred.
The X key can also be used to drop bombs on grounded objects. Tap the P key to pause. The closer your ship is to the top of the screen, the
faster it scrolls.
AUTHOR
This game has been written by Kenta Cho <cs8k-cyu@asahi-net.or.jp>
Val & Rick(6)