Visit Our UNIX and Linux User Community


trimming lines


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting trimming lines
# 1  
Old 09-26-2009
Error trimming lines

hi have output as
Quote:
SQL> select DBMS_METADATA.GET_DDL('INDEX','I_QOSSYSTA2IRAQOS_____N') from dual;

CREATE INDEX "UMTSD26"."I_QOSSYSTA2IRAQOS_____N" ON "UMTSD26"."QOSSYSTA2IRAQOS
_____N" ("UNID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT) LOCAL
(PARTITION "PARTITION_ON_2009_09_21"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_21_SP1"
TABLESPACE "MUSE") ,
PARTITION "PARTITION_ON_2009_09_22"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_22_SP1"
TABLESPACE "MUSE") ,
PARTITION "PARTITION_ON_2009_09_23"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_23_SP1"
TABLESPACE "MUSE") ,
PARTITION "PARTITION_ON_2009_09_24"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_24_SP1"
TABLESPACE "MUSE") ,
PARTITION "PARTITION_ON_2009_09_25"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_25_SP1"
TABLESPACE "MUSE") )



SQL> prompt ;;
;
SQL> spool off;

i have trim of lines before CREATE statement and lins after last ")"


any idea how to achieve it ?
# 2  
Old 09-26-2009
you can put your select statement into a script which calls, amongst other things:
Code:
set echo off
set feedback off
spool out.sql
select ...
spool off

then call your script from the prompt:
Code:
SQL> @myscript;

You can probably get your semicolon on the end of the result with concatenation:
Code:
select DBMS_METADATA.GET_DDL('INDEX','I_QOSSYSTA2IRAQOS_____N')||';' from dual

check out this site for more info on sqlplus set: sqlplus set command

hth,
dv
# 3  
Old 09-26-2009
code ==>
Quote:
$ORACLE_HOME/bin/sqlplus $userName@$dbSID/$passWord <<EOF
set pagesize 0;
set long 90000;
set term off echo off;
set heading off;
set feedback off;
set trimspool on;
spool /alcatel/test/Corrupted.txt;
select DBMS_METADATA.GET_DDL('INDEX','I_QOSSYSTA2IRAQOS_____N') || ';' from dual;
spool off;
SET ECHO ON
EOF
output ==>
Quote:
SQL> select DBMS_METADATA.GET_DDL('INDEX','I_QOSSYSTA2IRAQOS_____N') || ';' from dual;

CREATE INDEX "UMTSD26"."I_QOSSYSTA2IRAQOS_____N" ON "UMTSD26"."QOSSYSTA2IRAQOS
_____N" ("UNID")
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT) LOCAL
(PARTITION "PARTITION_ON_2009_09_21"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_21_SP1"
TABLESPACE "MUSE") ,
PARTITION "PARTITION_ON_2009_09_22"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_22_SP1"
TABLESPACE "MUSE") ,
PARTITION "PARTITION_ON_2009_09_23"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_23_SP1"
TABLESPACE "MUSE") ,
PARTITION "PARTITION_ON_2009_09_24"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_24_SP1"
TABLESPACE "MUSE") ,
PARTITION "PARTITION_ON_2009_09_25"
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
( SUBPARTITION "PARTITION_ON_2009_09_25_SP1"
TABLESPACE "MUSE") )
;

SQL> spool off;
# 4  
Old 09-26-2009
don't think this works
Code:
set term off echo off;

try this
Code:
set term off;
set echo off;


Previous Thread | Next Thread
Test Your Knowledge in Computers #445
Difficulty: Easy
Scientific Linux has been loaded onto systems at the International Space Station.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Trimming ends

My files look like this I need to remove the sequence GGGAAA and anything before that I also need to remove the sequence AGCCCTA and anything after that So I will end up with something like this The left side is done but I cannot get the right side correctly. I would like to use... (3 Replies)
Discussion started by: Xterra
3 Replies

2. Shell Programming and Scripting

Trimming in between the words

Hi i have a log file P12345_15728710:DEBUG:Begin P12345_15728710:DEBUG:Being P12345_15729310:DEBUG:GetAgen P12345_15726510:DEBUG:end i want to trim this file and i want like this 15728710 15728710 15729310 15726510 i tried sed ..but not working.. sed "s/.*P12345__ \(.*\)... (4 Replies)
Discussion started by: navsan420
4 Replies

3. Shell Programming and Scripting

Trimming a string

Hi I need to trim white spaces from strings in a file. Input file is like this: 1_rrc_CatalogGroups.csv = 607 1_rrc_Sales_TopCatalogGroups.csv = 4 1_rrc_Sales_CatalogEntries_CatalogGroup_Rel.csv = 7 Need to trim space before and after = symbol. This is my script: #!/usr/bin/ksh ... (2 Replies)
Discussion started by: sukhdip
2 Replies

4. Shell Programming and Scripting

trimming sequences

My file looks like this: But I would like to 'trim' all sequences to the same lenght 32 characters, keeping intact all the identifier (>GHXCZCC01AJ8CJ) Would it be possible to use awk to perform this task? (2 Replies)
Discussion started by: Xterra
2 Replies

5. Shell Programming and Scripting

Trimming output

I'm trying to parse an output log and I've managed to reduce the output to the lines I need. But I'm having trouble pulling out only the info I'm interested in. The output is 40+ lines and here is a sample Installing AppFresh 0.8.5.pkg from ./InstallerFiles/CustomPKG/26 (26) Installing... (2 Replies)
Discussion started by: kaltekar
2 Replies

6. Shell Programming and Scripting

trimming out spaces in solaris

friends, I have a script in solaris 10 SPARC system which is like this date '+Time: %m/%d/%y %H:%M:%S' echo " GDBRR GDLRR GDBWR GDLWR GDRRR GDRWR " sar -b 10 10 |/usr/xpg4/bin/awk '!/Average/ && !/SunOS/ && !/bread/ {$1="";T=$2;T1=$3;T2=$5;T3=$6;T4=$8;T5=$9}{print(T"\t",... (1 Reply)
Discussion started by: achak01
1 Replies

7. UNIX for Advanced & Expert Users

Trimming the spaces

Hi, How can I remove the unwanted spaces in the line. 123456 789 ABC DEF. - I wanna remove the sapces in this line, I need the output 123456789ABCDEF. Pls help me...... (3 Replies)
Discussion started by: sharif
3 Replies

8. UNIX for Advanced & Expert Users

trimming zeros

Hi, I want to trim +with leading zero's with amount fields.I know using awk for trimming leading zeros with +,but I want get the entire row itself. cat file_name |awk -F " " '{printf "%14.4f%f\n",$4}' ex: 10 xyz bc +00000234.4500 20 yzx foxic +002456.000 Expexted 10 xyz bc... (3 Replies)
Discussion started by: mohan705
3 Replies

9. Shell Programming and Scripting

Trimming a string

Hi, I am trying to find a script command that will let me trim leading and trailing space from a string. I have coded a SQL Select and sending the output to a file. Later I am parsing the file and reading each field. The problem is that each field uses the same size as the DB2 type it was defined... (2 Replies)
Discussion started by: fastgoon
2 Replies

10. UNIX for Dummies Questions & Answers

trimming a file...

Hi everyone I have this script that appends a line to a file to log the running status of an application. I need to write another script to run as a scheduled job in cron to trim the first x number of lines of this file. Could someone give me an idea how to do this? Regards (1 Reply)
Discussion started by: alwayslearningunix
1 Replies

Featured Tech Videos