Search Results

Search: Posts Made By: hanu_oracle
3,242
Posted By hanu_oracle
[/COLOR] If u have Database access, you can...
[/COLOR]

If u have Database access, you can simply fetch details using:
select OBJECT_NAME, OBJECT_TYPE from dba_objects where OBJECT_TYPE in ('TABLE', 'VIEW', 'PROCEDURE', 'PACKAGE') order by...
2,050
Posted By hanu_oracle
If u are using Bash, Please try this one .. ...
If u are using Bash, Please try this one ..

user_option=`echo $user_input | tr '[:lower:]' '[:upper:]'`
4,222
Posted By hanu_oracle
Before executing your main script, Just add...
Before executing your main script,
Just add the one more if condition for TimeStamp checking.

If [ $CurrentTimeStamp == "00:10 MST" ]
then
exit
echo "Execution of...
3,884
Posted By hanu_oracle
First Check `mailx` service is enable on your...
First Check `mailx` service is enable on your server or not ?
If enable, U want database Query output in mail or Attachments in mail, confirm?
7,934
Posted By hanu_oracle
Once again thanks for your detailed explanation.
Once again thanks for your detailed explanation.
7,934
Posted By hanu_oracle
Thank you, it's working fine. But why we are...
Thank you, it's working fine.

But why we are giving the extra -- for creation of the -file.txt .
7,934
Posted By hanu_oracle
Not able to create any file name start with "-" hyphen in Solaris
Hi All,

I am not able to create any file name start with "-" hyphen. Any logical issue with these types of files creation in Solaris.

==============================
bash-3.00$ touch...
8,373
Posted By hanu_oracle
Thanks for your support. "-a" option will...
Thanks for your support.
"-a" option will work successfully. But we are not able to fix the "-a suffixlength". Any dynamic updation of the suffixlength for every time.
8,373
Posted By hanu_oracle
Other integration applications are not supported...
Other integration applications are not supported for the large size files. For that purpose we will split the large file into small once's and pass it.

We are using the SunSolaris5.10
8,373
Posted By hanu_oracle
I think splitting 2 times is the double work &...
I think splitting 2 times is the double work & there is no manual activity also. script will run in the cronjob.
8,373
Posted By hanu_oracle
split file problem
Hi All,

I have a parent file with 10 million records. I want to split the parent file in to child files.

Each child file contains 5000 records.

I am using the following command for...
2,896
Posted By hanu_oracle
DECODE file field is required in Bash
Dear All,

I want to decode the one of the file field.

Input file:
9393939393|999|2009-02-20 00:00:01|2||4587|2007-02-28 00:00:01|0
9393939393|2001|2009-02-20 00:00:01|2||4587|2007-02-28...
4,969
Posted By hanu_oracle
Thanks to all, I got the output from tr...
Thanks to all,

I got the output from tr command..

cat i/p file |tr '|' ' '|awk '{print $1"||"$3"||"$5"|"}'
4,969
Posted By hanu_oracle
awk Problem while insert null field to file
Dear All,

I have the following input file. I want to replace data with null values.

I/P File:
9022334455|2008-12-06 06:10:21|2|Error@@@|esoo8erp|
9024334432|2008-12-06...
5,355
Posted By hanu_oracle
Check the script for execution permissions....
Check the script for execution permissions. Crontab required the execution permission..
6,656
Posted By hanu_oracle
I am asking not for me & not for the XManager...
I am asking not for me & not for the XManager Terminal host.

Suppose any new guy joined in the project, then how to control of script execution to that guy in the above case.
6,656
Posted By hanu_oracle
How to Open Shell Script from X-Manager Console
Dear All,

I have a shell script. which has the read, write & execute permissions.
I am entering from X-Manager Console.

OS Details are:
SunOS P382XLRTY 5.9 Generic_118558-34 sun4u sparc...
5,307
Posted By hanu_oracle
It will give the .pdf file. But it is not in...
It will give the .pdf file. But it is not in openable format.

At the start of the post "I will write the code. That is also give the same .pdf file"

That is also not in openable format..
5,307
Posted By hanu_oracle
bash-2.05$ bash -c 'x=OK.;echo ${x%.}' OK ...
bash-2.05$ bash -c 'x=OK.;echo ${x%.}'
OK
bash-2.05$
5,307
Posted By hanu_oracle
bash-2.05$ ps -p $$ PID TTY TIME CMD ...
bash-2.05$ ps -p $$
PID TTY TIME CMD
6934 pts/51 0:00 bash

Still it will give the same error message (: bad substitution)..
5,307
Posted By hanu_oracle
---------------------- Failed...
---------------------- Failed Output-------------------------
bash-2.05$ cat HelloPDF.sh

cd $HOME

for name in `ls -1 *.doc`
do
mv $name ${name%.doc}.pdf
done

bash-2.05$ sh...
1,710
Posted By hanu_oracle
REMOTESERVER=97.253.00.001 REMOTEPATH='/usr' ...
REMOTESERVER=97.253.00.001
REMOTEPATH='/usr'
LOGIN='oracle'
PASSWORD='oracle'
cd $LOCALDIR
ftp -n $REMOTESERVER << INPUT_END
quote USER $LOGIN
quote PASS $PASSWORD
hash
bin
cd $REMOTEPATH...
5,307
Posted By hanu_oracle
How to Rename/Convert Files in Shell Scripting?
Hi All,

I want to Rename/Convert all the .doc files in to .pdf format.
I am using the following Script. But the final output is not proper.

##########################################
cd...
4,536
Posted By hanu_oracle
################# FTP...
################# FTP #############################

USER_LOG='/u01/UAT/scripts/scriptslog/in_ftp_pushing.log'
`touch $USER_LOG`
REMOTESERVER=97.253.17.142 # Your...
31,917
Posted By hanu_oracle
Hi Hema, I had given choice to u only. U...
Hi Hema,

I had given choice to u only. U know oracle - - I am only executing the simple Stored Procedure{ODS_SP_REMOVE_PRE_SUB_DUP(OUT_STATUS, OUT_MSG)}. Instead of SP, You can use the simple...
Showing results 1 to 25 of 47

 
All times are GMT -4. The time now is 06:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy