SQL for table with column (varchar2 2000) and line break in it
Hi,
I need a sql statement for a table, which simply stores a text. It has a column ID, key1, key2, ..., text, date etc. The text can be entered using a line break (return) in an oracle form.
Assuming there are line breaks in the text column, the statement should show the result as follows:
Any ideas? Thanks in advance!
Hello
As per requirements, can i Install a MSSQL SERVER on UNIX ,
is it possible., can i install or not.., could u plz give me reply with
some installation details..........
Regards&Thanking You
sreedhar G (1 Reply)
Hi folks
I have mysql dump which having insert queries, i want to break that file when 10 complete "INSERTS" lines so extract that line and store in 1.sql and 2.sql and for next 10 insert lines.
pls guide me how can i do that.
Regards,
Bash (2 Replies)
:rolleyes: hi there everybody,
i need help,... thanks anyway!
i am working on a very huge table with the name table1. the problem is that i know only one field name in this table...,
working with a ksh environment i don't know how to view the table to check out the field names :confused:.
... (4 Replies)
Hi...
i have currently installed db2 version 9.1.2 on my AIX machine...
No matter what i do,.... VARCHAR2 just doesn't seem to be working!
This is the error i ketp getting after i ran a simple create statement...
$db2 "create table tst (name VARCHAR2(30));"
DB21034E The command was... (2 Replies)
i have a one column txt file, which has a large amount of data which look like this
a
11
3
b
45
77
r
7
9
blah
blah
blah
what i am trying to do here is for every 3 lines, i want to move the 2nd and 3rd line to the first line, so it will look like this
a 11 3
b 45 77
r 7 9 (8 Replies)
...when the lines use both a colon and commas to separate the parts you want read as information.
The first version of this script used cut and other non-Bash-builtins, frequently, which made it nice and zippy with little more than average processor load in GNOME Terminal but, predictably, slow... (2 Replies)
Hi,
I have urls in my input file like this
http://unix.com/abc/def
http://unix.com/kil/min
I want to use the / as separator and print the last content as another column like this
http://unix.com/abc/def def
http://unix.com/kil/min min
I was using awk -F option and then joining the... (3 Replies)
please write a shell script
Table
--------------------------
1 2 3 a b c
3 4 5 c d e
7 8 9 f g h
Output should be like this
---------------
1 2 3
3 4 5
7 8 9
a b c
c d e
f g h (1 Reply)
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Hi,
I have urls in my input file like this (1 Reply)
Discussion started by: tmonk1
1 Replies
LEARN ABOUT SUSE
mail::dkim::privatekey
Mail::DKIM::PrivateKey(3) User Contributed Perl Documentation Mail::DKIM::PrivateKey(3)NAME
Mail::DKIM::PrivateKey - a private key loaded in memory for DKIM signing
SYNOPSIS
my $key1 = Mail::DKIM::PrivateKey->load(
File => "/path/to/private.key");
my $key2 = Mail::DKIM::PrivateKey->load(
Data => $base64);
# use the loaded key in a DKIM signing object
my $dkim = Mail::DKIM::Signer->new(
Key => $key2,
);
CONSTRUCTOR
load() - loads a private key into memory
my $key1 = Mail::DKIM::PrivateKey->load(
File => "/path/to/private.key");
Loads the Base64-encoded key from the specified file.
my $key2 = Mail::DKIM::PrivateKey->load(Data => $base64);
Loads the Base64-encoded key from a string already in memory.
my $key3 = Mail::DKIM::PrivateKey->load(Cork => $openssl_object);
Creates a Mail::DKIM::PrivateKey wrapper object for the given OpenSSL key object. The key object should be of type Crypt::OpenSSL::RSA.
METHODS
cork() - access the underlying OpenSSL key object
$openssl_object = $key->cork;
The returned object is of type Crypt::OpenSSL::RSA.
sign_digest()
Cryptographically sign the given message digest.
$key->sign_digest("SHA-1", sha1("my message text"));
The first parameter is the name of the digest: one of "SHA-1", "SHA-256".
The second parameter is the message digest as a binary string.
The result should be the signed digest as a binary string.
AUTHOR
Jason Long, <jlong@messiah.edu>
COPYRIGHT AND LICENSE
Copyright (C) 2006-2008 by Messiah College
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.6 or,
at your option, any later version of Perl 5 you may have available.
perl v5.12.1 2010-03-01 Mail::DKIM::PrivateKey(3)