10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi ,
i have written below piece of code to meet the requirement but i am stuck in the logic here.
the requirement are:
1) to send the sql out put to email body with proper formatting.
2) if count_matching = Yes then mail should triggered with the subject line ... (10 Replies)
Discussion started by: itzkashi
10 Replies
2. Shell Programming and Scripting
Hi,
i need a string that take from a log file just two words (ngwan0) and his related ip address and then execute 2 commands in a shell. Any ideas where to start?
Thanks (3 Replies)
Discussion started by: Board27
3 Replies
3. Programming
Hello All,
I hope I'm posting this in the right section.
I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,... (8 Replies)
Discussion started by: bbbngowc
8 Replies
4. Shell Programming and Scripting
Please advice to rectify below error
#!/bin/ksh
X=$(sqlplus -s user/pass << EOSQL
set serveroutput on;
set heading off feedback off serveroutput on trimout on pagesize 0
INSERT INTO TEST(df)
VALUES('a');
COMMIT;
EXIT;
EOSQL)
echo $X
echo $?
ERROR at line 2: ORA-00984: column not... (1 Reply)
Discussion started by: mirwasim
1 Replies
5. Shell Programming and Scripting
Hi,
I have a file in which I have database information along with 1 SELECT statement. Only 1 statement would be there. I want to grep this SELECT STATEMENT only and write into a separate file.
Input File format:
Database_Name:<database>
Schema_Name:<schema>
Table_Name:<table>
Select *... (3 Replies)
Discussion started by: ustechie
3 Replies
6. Shell Programming and Scripting
I'm having problems with writing my sql results to a file:
sqlplus -S username/password@DB <<!!
set echo off
set verify off
set showmode off
set feedback off
set timing off
set linesize 250
set wrap off
set pagesize 0
set newpage none
set tab off
set trimspool on
set colsep... (1 Reply)
Discussion started by: avillanueva
1 Replies
7. Homework & Coursework Questions
1. The problem statement, all variables and given/known data:
Write a script that will perform the grep command on a user defined file and a user defined pattern
2. Relevant commands, code, scripts, algorithms:
must use grep command (that is the only piece of information that was given)
... (2 Replies)
Discussion started by: akjim101
2 Replies
8. Shell Programming and Scripting
Hi All,
Please help me writing the below script.
I have two sql queries.
1. Select count(1),Client_id from TABLE_A group by Client_id;
2. Select count(1),Client_id from TABLE_B group by Client_id;
I need the output of above two sql queries in a single file. The output 2nd query should be... (4 Replies)
Discussion started by: 46019
4 Replies
9. Programming
Hi I am new to using pl/sql on a unix platform and am having trouble writing to a file from within a block. Below is an example of the code that I have. I know that I need to use UTL_FILE to accomplish this; however, I keep getting errors. Can someone please help me?
I am trying to create a... (1 Reply)
Discussion started by: stky13
1 Replies
10. Shell Programming and Scripting
suppose by writing this code
"$ /sbin/ifconfig eth0| grep 'inet addr:' "
i've got this output
"inet addr:192.168.2.1 Mask:255.255.255.0"
now if i want to see the output like this
"IP address: 192.168.2.1
Subnet Mask: 255.255.255.0"
what is the code should be?
can anyone... (3 Replies)
Discussion started by: shelly
3 Replies