Go to advanced search

by marchello
Sat Dec 06, 2014 10:51 am
Forum: General programming discussion
Topic: generate sql result into xml
Replies: 10
Views: 2118

Re: generate sql result into xml

Before:

Code: Select all

awk -F\t
now:

Code: Select all

awk '-F\t'
Works great.
Thanks for attention.
by marchello
Fri Dec 05, 2014 9:17 pm
Forum: General programming discussion
Topic: generate sql result into xml
Replies: 10
Views: 2118

Re: generate sql result into xml

I've use both shells a lot, but not Oracle. I don't really think it is oracle question at all. However, I think the issue here is the XML output and how to generate multi-column data from the text input. Yes, exactly. What does the XML need to look like? It should look like Excel file. The first ro...
by marchello
Fri Dec 05, 2014 7:14 pm
Forum: General programming discussion
Topic: generate sql result into xml
Replies: 10
Views: 2118

Re: generate sql result into xml

DougieLawson wrote:
marchello wrote:Well, it is not Oracle question. It is linux scripting question.
Scripting in what language?
This script has

Code: Select all

#!/bin/ksh
in the beginning.

So it needs to be run using the ksh interpreter.
That's all I know at a moment.
Any help?
by marchello
Fri Dec 05, 2014 6:31 pm
Forum: General programming discussion
Topic: generate sql result into xml
Replies: 10
Views: 2118

Re: generate sql result into xml

Well, it is not Oracle question. It is linux scripting question. I updated my first post above, added more lines of actual code. We have columns in result file: RB FB FBH AB ABH FBAD FBHAD FBAC FBHAC ABAA ABHAA and values of these columns are all inserted into single RB column 941 189 211 2 3 0 0 0 ...
by marchello
Fri Dec 05, 2014 12:02 pm
Forum: General programming discussion
Topic: generate sql result into xml
Replies: 10
Views: 2118

Re: generate sql result into xml

DougieLawson wrote:What database are you using?
Oracle 11g.
by marchello
Tue Dec 02, 2014 10:56 pm
Forum: General programming discussion
Topic: generate sql result into xml
Replies: 10
Views: 2118

generate sql result into xml

Hi all, Hope it is correct thread... How do I generate sql result into xml ? Tried this way (shown below), but it generates all data into single column. Tell me kindly what else should I post here to get help. Please help. Thanks ahead. generate_xml() { f1=_tmp1 f2=_tmp2 cat $SQL_QUERY_OUT |sed -e '...
by marchello
Thu Nov 27, 2014 5:15 pm
Forum: Beginners
Topic: network issue - can't ping host only under linux
Replies: 3
Views: 807

Re: network issue - can't ping host only under linux

Is it possible to turn off using 8.8.8.8 somehow at my side?
by marchello
Thu Nov 27, 2014 4:41 pm
Forum: Beginners
Topic: network issue - can't ping host only under linux
Replies: 3
Views: 807

network issue - can't ping host only under linux

Hi all, Got wierd issue. I can not ping local host by its dns name under linux. But I do can ping it under my windows xp machine! Our admin says it can be because I got 8.8.8.8 in list of dns $ nm-tool DNS: 10.51.0.9 DNS: 10.100.100.10 DNS: 10.100.100.11 DNS: 8.8.8.8 I receive list of dns from dhcp,...
by marchello
Tue Nov 18, 2014 1:44 pm
Forum: General programming discussion
Topic: where does my script spend the most of time?
Replies: 1
Views: 846

where does my script spend the most of time?

Hi all, I'd like to know where does my script spend the most of time. Please find code below. I'm newbie and would like to know how do I start script debugging? Any suggestion is appreciated! $ less /QA/u01/oracle/admin/plsdw/plsdw_scripts/nag_pls_exec_sql_ftp.ksh #!/bin/ksh #***********************...
by marchello
Tue Nov 18, 2014 12:32 pm
Forum: General discussion
Topic: get top 10 cronjobs for last week
Replies: 1
Views: 467

get top 10 cronjobs for last week

Hi all,

How do I get top 10 cronjobs for last week?
Thanks ahead.


Upd: Speaking of top 10 cron jobs I mean
1) top 10 time consuming
2) top 10 cpu consuming.
Also I'd like to compare how jobs worked last time and month ago (if possible).
Any help?
by marchello
Mon Nov 17, 2014 9:54 pm
Forum: General discussion
Topic: checkpoint vpn client for raspbian
Replies: 0
Views: 1936

checkpoint vpn client for raspbian

Hi all, Does someone use checkpoint client for raspbian ? $ snx -s xxx.yyy.zzz.jjj -u user1 Check Point's Linux SNX build 800005013 Please enter your password: SNX: Connection aborted. My password is correct, because I use it also with checkpoint vpn client for windows and it works fine. Please help...
by marchello
Fri Sep 12, 2014 2:12 pm
Forum: Networking and servers
Topic: Backup MX exchange
Replies: 5
Views: 1908

Re: Backup MX exchange

I am sorry but I don't get your point. I already know what MX, DNS/DNS records and backup MX are. Maybe it is my fault because I did not make myself clear (english is not my mother tongue, sorry for that). So let me try to explain again my proposal. I run my personal MTA on the Raspberry Pi (yes, I...
by marchello
Mon Jun 23, 2014 9:18 am
Forum: Off topic discussion
Topic: mail @ rpi - backup mx
Replies: 0
Views: 849

mail @ rpi - backup mx

Hi all,

I'm running mail server, everything works fine.
I use free backup mx, it keeps my mail up to 24 hours.
Now I'm planning my vacations and the question is what backup mx service can I use to keep my mail up to 10 days.
Thanks for your attention.
by marchello
Tue Jun 10, 2014 12:41 pm
Forum: Off topic discussion
Topic: html5 - show hidden text upon loading page
Replies: 5
Views: 2600

Re: html5 - show hidden text upon loading page

Douglas6 wrote:Put a query parameter in the second link like index.htm#show_id5?spoil=5. Test for the spoil variable in a window.onload handler.
Could you please be so kind to give me more detailed example?
I'm very new to html5 ...
Thanks ahead!
by marchello
Tue Jun 10, 2014 10:09 am
Forum: Off topic discussion
Topic: html5 - show hidden text upon loading page
Replies: 5
Views: 2600

html5 - show hidden text upon loading page

Hi all, my need is to show my spoiler upon user's visit. It works fine when user opens link http://site.com/index.html#show_id5 and he or she can see only visible text, then user can click on spoiler link to see the rest. Now I'd like to give users "full link" so he or she can see full text without ...
by marchello
Mon Jun 02, 2014 8:01 am
Forum: Beginners
Topic: cron - run more often than once per hour
Replies: 2
Views: 703

cron - run more often than once per hour

Hi all,

when I need to run some script once per hour then I put it into /etc/cron.hourly directory and it works fine.
How do i run my script more often than once per hour?
Thanks ahead.
by marchello
Sat May 24, 2014 8:04 am
Forum: General discussion
Topic: pptp connection
Replies: 1
Views: 791

Re: pptp connection

This how I try to connect:

sudo pppd call work-kz
by marchello
Sat May 24, 2014 8:01 am
Forum: General discussion
Topic: pptp connection
Replies: 1
Views: 791

pptp connection

Hi all, help me please to understand what is going on with my pptp connection. sudo tail -f /var/log/syslog May 24 10:57:51 marchello pppd[4601]: pppd 2.4.5 started by root, uid 0 May 24 10:57:51 marchello NetworkManager[875]: SCPlugin-Ifupdown: devices added (path: /sys/devices/virtual/net/ppp0, if...
by marchello
Thu May 15, 2014 1:08 pm
Forum: Off topic discussion
Topic: vps with Red Hat or Suse
Replies: 1
Views: 600

vps with Red Hat or Suse

Hi all,

my need is to find vps with Red Hat or Suse.
Any suggestions?
Thanks ahead.
by marchello
Mon Apr 28, 2014 1:11 pm
Forum: Off topic discussion
Topic: html5 - spoiler
Replies: 1
Views: 769

html5 - spoiler

Hi all,

how do I create spoiler in html5 ?

What I mean...

Let's say we have text "My need is to create spoiler".
I want user first see "My need is ..." and when he or she clicks on it then it shows full text.

How do I perform it?
by marchello
Fri Apr 25, 2014 12:59 pm
Forum: General discussion
Topic: tiny mail sending package for web server
Replies: 4
Views: 1274

tiny mail sending package for web server

Hi all, my need is to find some tiny mail sending package for web server @ rpi. I rather don't need real mail server like postfix or sendmail here. It should just receive email messages from php and pass it to real smtp server. The best would be some package that I can install using apt-get. Any sug...
by marchello
Fri Apr 25, 2014 10:55 am
Forum: Python
Topic: python - find keyword in text file, get context (full line)
Replies: 1
Views: 717

python - find keyword in text file, get context (full line)

Hi all,

how do I find keyword in text file and then save context (full line) into other text file in python ?
by marchello
Thu Apr 24, 2014 7:56 pm
Forum: Python
Topic: python - compile my program to use it also at windows PC
Replies: 1
Views: 613

python - compile my program to use it also at windows PC

Hi all,

how do I compile my python program to use it also at windows PC ?
by marchello
Thu Apr 24, 2014 7:54 pm
Forum: Python
Topic: python - fetch url using wget without opening window
Replies: 4
Views: 2095

Re: python - fetch url using wget without opening window

Well, the way to use wget is enough. Thanks.
by marchello
Thu Apr 24, 2014 7:12 pm
Forum: General discussion
Topic: script in /etc/cron.hourly doesn't work automatically
Replies: 2
Views: 618

Re: script in /etc/cron.hourly doesn't work automatically

The problem was that my script "something_great" was not executable, I fixed it using this simple code:

sudo chmod +x something_great

Go to advanced search