One more problem....I am pulling data into a text file but along with data a new line and tab is coming...
Eg:
But I want it to be like
so that can use it in a variable each separately as i need to send this in a tabular form as mail using script only.
Also please let me know how to assign same and then arrange it in table form, it will be around 20 or so numbers and aranged like this...
Dear friends,
please help me to solve following problem.
I'm running a frontend application from which i'll be invoking the shell script with arguments as given below
-driver -w -p "ABC XYZ" -S -ds con -dn "abc xyz"
i am getting
$1=-driver
$2=-w
$3=-p
$4="ABC
$5=XYZ"
$6=-S
$7=-ds... (3 Replies)
Hi guys,
I have searched all the forums and searched the net as much as possible, but I carn't find any tutorials about shell scripting with Oracle. Has anyone come across any?
Thanks for reading and in advance of posts,
B14... (2 Replies)
I have a file that has text in the format below
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
ABC
/ Some text /
How can I seperate the text between a pair of 'ABC' into seperate files ???
any information would be of great help. Thanks (8 Replies)
Dear All,
I have an input file like this
interface Serial10/0/7:11.1 point-to-point
description CLIENT:SA_INSTITUTO ANGLO MEXICANO Sitio Metepec 104452:0,165
bandwidth 64
ip vrf forwarding INSTITUTO-ANGLO
ip address 192.168.148.217 255.255.255.252
no ip directed-broadcast
frame-relay... (2 Replies)
Hi all,
i m new to Unix shell scripting(ksh)
i have a requirement, can anyone help me out in this..
spec:
i need to move all the files landing in "X" directory to "Y" directory automatically everyday at a particular time.. (5 Replies)
Hi All,
I need to split a flatfile based on it's first character, I am using the following script
awk '{print > "TEST_substr($0,1,1).txt"}' PROVIDER.txt
It is returning files
TEST_1 and
TEST_2
But I am not getting the .txt file extension.
I need the files like
TEST_1.txt and ... (1 Reply)
Can anyone please help me to create the output file based on the attached input files using ksh script.
I have 2 input files
1) inputfile1.txt
2) inputfile2.txt
The script should accept 2 parametes:
1. Inputfile2.txt with 1-10,000 values ( sample file contains only 4 records)
2. Script... (5 Replies)
Discussion started by: vinus
5 Replies
LEARN ABOUT SUSE
savepoint
SAVEPOINT(7) SQL Commands SAVEPOINT(7)NAME
SAVEPOINT - define a new savepoint within the current transaction
SYNOPSIS
SAVEPOINT savepoint_name
DESCRIPTION
SAVEPOINT establishes a new savepoint within the current transaction.
A savepoint is a special mark inside a transaction that allows all commands that are executed after it was established to be rolled back,
restoring the transaction state to what it was at the time of the savepoint.
PARAMETERS
savepoint_name
The name to give to the new savepoint.
NOTES
Use ROLLBACK TO SAVEPOINT [rollback_to_savepoint(7)] to rollback to a savepoint. Use RELEASE SAVEPOINT [release_savepoint(7)] to destroy a
savepoint, keeping the effects of commands executed after it was established.
Savepoints can only be established when inside a transaction block. There can be multiple savepoints defined within a transaction.
EXAMPLES
To establish a savepoint and later undo the effects of all commands executed after it was established:
BEGIN;
INSERT INTO table1 VALUES (1);
SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (2);
ROLLBACK TO SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (3);
COMMIT;
The above transaction will insert the values 1 and 3, but not 2.
To establish and later destroy a savepoint:
BEGIN;
INSERT INTO table1 VALUES (3);
SAVEPOINT my_savepoint;
INSERT INTO table1 VALUES (4);
RELEASE SAVEPOINT my_savepoint;
COMMIT;
The above transaction will insert both 3 and 4.
COMPATIBILITY
SQL requires a savepoint to be destroyed automatically when another savepoint with the same name is established. In PostgreSQL, the old
savepoint is kept, though only the more recent one will be used when rolling back or releasing. (Releasing the newer savepoint will cause
the older one to again become accessible to ROLLBACK TO SAVEPOINT and RELEASE SAVEPOINT.) Otherwise, SAVEPOINT is fully SQL conforming.
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], RELEASE SAVEPOINT [release_savepoint(7)], ROLLBACK [rollback(7)], ROLLBACK TO SAVEPOINT [roll-
back_to_savepoint(7)]
SQL - Language Statements 2010-05-14 SAVEPOINT(7)