Search Results

I know. But what i mean is how can i create a file like this? A kind o table i mean.. Is there some specific command?

What you can see from my first post.

I don't know how start.. How can i create for example the structure of the file? I tried with a echo "| TAB_NAME | STATE | RECORDS |" >> ${REPORT} So in this way i have the report file in...

I have some insert in my unix shell script. This every insert has a spool (a file with datas) and a sql file with the query. I have to create a report file with three columns:
The first(TAB_NAME)...

I'm looking for SQL*Plus solution. The insert i'm going to do takes a file. This file has no duplicate rows. The problem is in the oracle. Not in the file. The recors could be duplicated.

I know that in oracle the is a way to write to ignore the dupkey, something like

/*+ ignore_row_on_dupkey_index(tab, index_tab) */

Is there a way to do the same thing but with unix commands? I...

tmp.dat? i don't understand, sorry i'm new in bash script.. i have one file: the first one is ${FILE_OUT1} and inside there is the data (the example data i posted for example), in the other...

I have to put the result in an other file sorry.. so.. something like this :

awk -F";" '!A[$2]++' OFS=";" ${FILE_OUT1}> ${FILE_OUT2}?

But nothing change.. :(

This is an example of data:


ID COD1 DATA COD2 COD3 DATA2

;0@13013008021958146502;2@*;3@MGF;4@30-JAN-13...

I have an output file .dat. From this file i have to do a distinct of the ID using the sort uniq command in bash script. How can i do it? i found :
sort -u ${FILEOUT_DAT}

but i don't think is my...

For now i need only connect with sqlplus my db to the shell and see what there is in that field.. The db is dynamic so i have n rows. If i want to see what there is in the 4 row of the Date_elab...

Hi I'm new in shell scripting and i have a problem.. I've got a DB with a column names Date_elab (this is a field with the dates of a partition that must be cancelled). In my shell i have to get an...