10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies
2. Shell Programming and Scripting
Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for... (1 Reply)
Discussion started by: MrMagoo22
1 Replies
3. Programming
Hi ,
I have a data file in this format.
p1 p2 p3
10 0
10 0 1000
I am using a sqlloader script to load the data into the database table.There is a unique constraint on the columns p1 and p2.
So, sqlldr cannot load both the records. This eliminates duplicate records from being... (1 Reply)
Discussion started by: megha2525
1 Replies
4. Shell Programming and Scripting
Hello I am having a problem with a script. I try to run a store procedure from unix with sqlldr and shows me the following error.
begin
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "RNP.SP_ARCH_SALIDA", line 64
ORA-06512: at line 2
The sp... (1 Reply)
Discussion started by: Rodrih92
1 Replies
5. UNIX for Dummies Questions & Answers
In LINUX(CentOS, RedHat) is there a way to have the banner statement appear before the logon instead of after the logon? In UNIX and Windows the banner appears before a person actually logs on, what I'm seeing in LINUX is that it appears after the login(ftp, telnet, SSH).
Thanks (0 Replies)
Discussion started by: ejjones
0 Replies
6. Shell Programming and Scripting
Dear,
I must load a file in a table via sqlloader. I have also a column in this table which must contain the same value for all rows in this table. And this value is get from a shell script variable.
Can you give me a sort example on how to use a shell script variable as a paramter in a CTL... (1 Reply)
Discussion started by: yeclota
1 Replies
7. Shell Programming and Scripting
Hi all,
I am very new to shell scripting.I have the requirement like
one program is there, if it is running leave like that only and if it is stopped it has to be restart and once again keep watching and it is stopped we a have to restart once agian.I want a shell script for this.Please help me... (10 Replies)
Discussion started by: bhas85
10 Replies
8. Programming
Hi ,
I have a dellimited .dat file and a sqlloader.
I want to call the sqlloader from a oracle stored procedure.
The procedure should return the result of sqlloader's execution. (3 Replies)
Discussion started by: Haque123
3 Replies
9. Shell Programming and Scripting
Hello there,
I'm writing a shellscript and it uses sqlloader, it works good coz load the data into the DB. But I'm runing the shell from a java program with Runtime(). It does execute the shell but the sqlloader doesn't seem to be working!!
Does anybody out there knows why?? (0 Replies)
Discussion started by: ying_dav
0 Replies
10. Shell Programming and Scripting
Hi,
I have a shell scripting. This will take 7 digit number in each line and add 7 digit number with next subsequent lines ( normal addition ).
Eg:
0000001
0000220
0001235
0000022
0000023
...........
.........
........
Like this i am having around 1500000 records. After adding... (23 Replies)
Discussion started by: thambi
23 Replies