03-07-2008
Truncating the last character
Hi all ,
I am creating the file which holds the create query to run in the sql prompt:
so when i am creating:
create table XXX( SD Varchar2(10),
DF Varchar2(10),)
I am getting one comma at the last ,before i am inserting the closing bracket i need to delete that? kindly provide me the solution to delete that comma??
Please help me out.
Thanks in advance.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have some processes that show a long file path as part of the process name and the process name gets truncated off.
Does anyone know how to get the full output from the `ps`command so that I can see the whole process name? (9 Replies)
Discussion started by: keelba
9 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
I'm trying to truncate a number like the following:
0001060407013900501048239559900600504083525826350002050354795057
I would like to create an output which puts carriage returns every so many characters, giving an output such as:
0001
060407
0139
0
05
010482395599
0060... (4 Replies)
Discussion started by: michaeltravisuk
4 Replies
3. Shell Programming and Scripting
I have a variable that is a full path name and I just want the file name with out the extension. I have figured out how to do this using some temp files but I would really like to avoid that if possible.
I know I can do
echo ${TMPNAME%.*} to drop the extension is there a similar way to drop... (3 Replies)
Discussion started by: whdr02
3 Replies
4. Shell Programming and Scripting
I am trying to truncate a table using below script. When I ran the script it runs fine but table was not truncated and the spool is empty. I am not sure what is wrong with pl/sql block.
#!/bin/ksh
# ----------------------------------------------------------------------
#
# Created by: XXXX... (2 Replies)
Discussion started by: gunaah
2 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I need to truncate a file based on date.Suppose i have a log file which is getting updated every date,i need to keep 7 days worth of data(like sysdate-7) and rest i want to truncate it.Can some help me? (5 Replies)
Discussion started by: Param0073
5 Replies
6. Shell Programming and Scripting
Hi,
I have a Unix mail file that I need to truncate, based on the date of the messages. For those not familiar with the format, it is a single file for each user, with the first line of the mail message looking like the following:
From user@sitename.com Thu Apr 21 05:40:33 2011
Each... (3 Replies)
Discussion started by: joed
3 Replies
7. Shell Programming and Scripting
I'm using plink.exe on WinXP to run some commands on Z/OS BASH. My commands are interspersed with echo commands so that I can parse the output and work out what is where.
The first hundred or so commands run fine, but then one of them gets truncated. For example:
Input:
echo :end_logdetail:... (6 Replies)
Discussion started by: PhilHibbs
6 Replies
8. Shell Programming and Scripting
Legends,
I have 2 files f1 and f2. when i use nawk to compare the difference(subtraction) from 4th column of the file, it truncates the output.
can you please help to resolve this.
subtraction is (4th col of f1 - 4th col of f2). but it gives only below lines out of 116. I want to print all... (7 Replies)
Discussion started by: sdosanjh
7 Replies
9. Solaris
Hello,
This is Solaris 10 (x86)
bash-3.2# cat /etc/release
Solaris 10 5/09 s10x_u7wos_08 X86
Copyright 2009 Sun Microsystems, Inc. All Rights Reserved.
Use is subject to license terms.
Assembled 30 March... (5 Replies)
Discussion started by: solaris_1977
5 Replies
10. Shell Programming and Scripting
Hey Folks - I'm trying to pass a list of To address using sendmail command but upon executing the script the to list gets truncated and not able to send the last
sender :
-bash-4.3$ ./akt.sh
Date : 03-JUL-18
aaaaa.sss#bgttecre.bom trcikant.shrivas#bgttecre.bom abc#xyz.bom pqr#lmn.bom lion... (0 Replies)
Discussion started by: vyomdev
0 Replies
LEARN ABOUT HPUX
elf_getphdr
elf_getphdr(3E) elf_getphdr(3E)
NAME
elf32_getphdr, elf32_newphdr, elf64_getphdr, elf64_newphdr - retrieve class-dependent program header table for elf32 and elf64 files,
respectively
SYNOPSIS
[flag... ] file... [library] ...
DESCRIPTION
For a 32-bit class file, returns a pointer to the program execution header table, if one is available for the ELF descriptor elf.
allocates a new table with count entries, regardless of whether one existed previously, and sets the bit for the table (see elf_flag(3E)).
Specifying a zero count deletes an existing table. Note this behavior differs from that of (see elf_getehdr(3E)), allowing a program to
replace or delete the program header table, changing its size if necessary.
If no program header table exists, the file is not a 32-bit class file, an error occurs, or elf is null, both functions return a null
pointer. Additionally, returns a null pointer if count is zero.
The table is an array of structures, each of which includes the following members.
The ELF header's member tells how many entries the program header table has (see elf_getehdr(3E)). A program may inspect this value to
determine the size of an existing table; automatically sets the member's value to count. If the program is building a new file, it is
responsible for creating the file's ELF header before creating the program header table.
For a 64-bit class file, returns a pointer to the program execution header table, if one is available for the ELF descriptor elf.
allocates a new table with count entries, regardless of whether one existed previously, and sets the bit for the table (see Specifying a
zero count deletes an existing table. Note this behavior differs from that of (see elf_getehdr(3E)), allowing a program to replace or
delete the program header table, changing its size if necessary.
If no program header table exists, the file is not a 64-bit class file, an error occurs, or elf is null, both functions return a null
pointer. Additionally, returns a null pointer if count is zero.
The table is an array of structures, each of which includes the following members.
The ELF header's e_phnum member tells how many entries the program header table has (see elf_getehdr(3E)). A program may inspect this
value to determine the size of an existing table; automatically sets the member's value to count. If the program is building a new file,
it is responsible for creating the file's ELF header before creating the program header table.
SEE ALSO
elf(3E), elf_begin(3E), elf_flag(3E), elf_getehdr(3E).
elf_getphdr(3E)