03-18-2007
It is very useful. Thanks a lot.
Regards,
Kousikan
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Is it possible to create a dynamic array in shell script. I am trying to get the list of logfiles that created that day and put it in a dynamic array. I am not sure about it. help me
New to scripting
Gundu (3 Replies)
Discussion started by: gundu
3 Replies
2. Shell Programming and Scripting
hi,
iam new of unix.
how to call sql script in ksh script (1 Reply)
Discussion started by: naveeng.81
1 Replies
3. Shell Programming and Scripting
Hi Forum,
Im trying to write some code to read a file, take a certain dynamic value and write it back to the file at the front of every line.
For example, file.txt is:
SIMPLE=HELLO
CONFIDENTIAL=false
SENDER=false
REQUIRED=true
FEEDBACK=false
UPDATE=false
REQUIRED=false
MAPPING=true... (9 Replies)
Discussion started by: ocelot
9 Replies
4. Shell Programming and Scripting
Hi,
I have an app which user can query the database based on 4 criteria, that is Field1, Field2, Field3 and Field4
Mya I know how to write a dynamic SQL where I can choose to retrieve data based on their selected value.
eg. where Field1=AAA
eg. where Field1=AAA and Field2=BBB
eg.... (1 Reply)
Discussion started by: TeSP
1 Replies
5. UNIX for Advanced & Expert Users
I have a file that reads File (X.txt)
Contents of record 1:
rdrDESTINATION_ADDRESS (String) "91 971502573813"
rdrDESTINATION_IMSI (String) "000000000000000"
rdrORIGINATING_ADDRESS (String) "d0 movies"
rdrORIGINATING_IMSI (String) "000000000000000"
rdrTRAFFIC_EVENT_TIME... (0 Replies)
Discussion started by: magedfawzy
0 Replies
6. Shell Programming and Scripting
Hi,
I need a script that will run a dynamic Oracle SQL. Dynamic meaning the SQL statement depends on the parameter.
For instance, something like this:
#!/bin/ksh -x
# Set environment
. /home/mine/set_vars
sqlplus $LOGINID <<! >> /home/mine/log.txt
select count(1) from $1
where... (2 Replies)
Discussion started by: laiko
2 Replies
7. Shell Programming and Scripting
Hi all,
I need to add the contents from a file into a sql stament in the where clause.
file1:
id
1
2
3
10
11
...
script should look like :
select name from tab_user tus where tus.id in (1,2,3,10,11..)
any ideas or suggetions will be appreciatte. (5 Replies)
Discussion started by: valigula
5 Replies
8. Shell Programming and Scripting
Hi Forum.
When I run the following find command, I get the desired results:
find . \( -name a.out -o -name '*.o' -o -name 'core' \) -type f -ls
I want for my script to dynamically calculate and assign a variable var1 to contain all the files that I want to search instead of hard-coding.
... (2 Replies)
Discussion started by: pchang
2 Replies
9. Linux
Hi All,
Can anyone give me Shell script sample script to generate Param file by Reading Values from SQL Plus query and it should assign those values to variables like..
$$SChema_Name='ORCL'
Thanks in Advance... Srav... (4 Replies)
Discussion started by: Sravana Kumar
4 Replies
10. Shell Programming and Scripting
Hi Guys,
I am using a function to replace the values dynamically to frame sql query by reading a file. My file will have column names like
file.txt
col_1
col_2
expected output:
select id,col_1,col_2 from (
select a.id,
a.col_1,
rank() over (ORDER BY cast(a.col_1 AS double)... (5 Replies)
Discussion started by: Master_Mind
5 Replies