10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
select to_char(cre_on, 'ddmm hh24'), proc_flg, count(*) from ib_prd.tb_ibmh_msg_log where message_type = 'DECHECK_OUT'
and cre_on > to_date('27/08/2016 00:00:00', 'dd/MM/yyyy hh24:mi:ss')
group by to_char(cre_on, 'ddmm hh24'), proc_flg
order by 1;
1) what does order by 1 means
2) group by... (1 Reply)
Discussion started by: houmingc
1 Replies
2. Shell Programming and Scripting
My input is:
hello how are you
my chemistry book is lost
what is up
etc...
And I want the output to be:
you are how hello
lost is book chemistry my
up is what
....
I found an earlier response to a similar question but it was not accurate as it required a certain string length for each line (2 Replies)
Discussion started by: Heidi Heweidy
2 Replies
3. UNIX for Dummies Questions & Answers
I have a text file where I want to append a column of numbers in ascending orders.
Input:
57 abc
25 def
32 ghi
54 jkl
Output:57 abc
57 abc 1
25 def 2
32 ghi 3
54 jkl 4
How do I go about doing that? Thanks! (11 Replies)
Discussion started by: evelibertine
11 Replies
4. Shell Programming and Scripting
Hi,
I was trying to have an output as below :
1 | 2 | 3
aaa | bbb | ccc
| ccc
| ccc
... (2 Replies)
Discussion started by: scottralf
2 Replies
5. UNIX for Dummies Questions & Answers
Hi guru's :)
I am new to UNIX. requirement is merging all text files from one folder in the order which they have received.
EX: under /Test folder files received in certain intervals.
abc.txt @ 1:00 AM
123.txt @ 2:00 AM
xyz.txt @ 4:00 AM
.
.
.
456.txt @ 10:00 PM
... (4 Replies)
Discussion started by: arund_01
4 Replies
6. Shell Programming and Scripting
Hi There,
I am new to UNIX. requirement is merging all text files from one folder in the order which they have received.
EX: under /Test folder files received in certain intervals.
abc.txt @ 1:00 AM
123.txt @ 2:00 AM
xyz.txt @ 4:00 AM
.
.
.
456.txt @ 10:00 PM
so need to develop a... (3 Replies)
Discussion started by: arund_01
3 Replies
7. Shell Programming and Scripting
I try order the content from file by delimiters.
This is the text:
interface Loopback0
description !!!RID RR_SLT
ip address 172.31.128.19 255.255.255.255
interface GigabitEthernet0
description !!!P_SLT GI0/0/9
ip address 172.31.130.246 255.255.255.252
and the result that I need... (11 Replies)
Discussion started by: bobbasystem
11 Replies
8. Shell Programming and Scripting
I appreciate all the help that I've already received but am running into one problem. I can find how to add something before a file with ascending numbers but not like this. I basically have a file that looks like this:
100
101
102
103
104
I need to add the following before each line with... (5 Replies)
Discussion started by: kerpm
5 Replies
9. Shell Programming and Scripting
My shell script below for import data to Oracle
it run okay. but the text display not correct follow order command executed.
=========================Shell Script code=================
#!/bin/sh
#directory = ${1-'pwd'}
#run import data with SQLLoader
runSQLLoader()
{
... (2 Replies)
Discussion started by: raccsdl
2 Replies
10. UNIX for Dummies Questions & Answers
Hi all,
I want to do a command that list all files from a directory e subdirectories order by size (MAX to MIN)
Can you help me?
Tkz (2 Replies)
Discussion started by: sliver
2 Replies