Search Results

Hi,

Please guide me where i am doing wrong, i am getting
ORA-01756:quoted string not properly terminated when i am trying to insert file into CLOB cloumn of Oracle DB.

Please find below...

Hi All,

I want to insert xyz.log file in CLOB field of Oracle DB. The log file increases its size dynamically. When i am inserting the file into DB i have to check the size of the file, if its...

Hi All,

I want to store 32KB of file in Oracle DB into CLOB field. I am not able to insert more than 32KB of file into CLOB. So i want to put a limit on the file size. I am using k shell.

My...

Hi All,

Please help me in writing data to a file in one row.

In database there is a column which contains large data which does not fit in the file in one row. The column contains list of...

Please find below the out that i am getting right now. But i want to write the same in one ROW

1=XP|external_component|com.adp.meetingalertemail.processing.MeetingAlertEmail|EMAILALERTPUSH|32|4#XP...

Hi All

I am reading data from the database and writing to temporary file in the below format....

Thank You Its Working.

One more question.

I am reading data from the database and writing to temporary file in the below format....

Hi All

I am trying to split a string which is like below

-p/usr/home/dfusr/adm/props/Comments.properties_-iPEL17

i want to split "_" as delimiter.

Please find the code below
...

Hi All,

I have String i want to tokenize based on one delimiter.

Original String is -pComments.properties,-iPELF4

i want to tokenize the original string based on ',' (comma) as...

Hi,

It not working it is giving me unusually result. please find below

This word is  bold  and this is not

It is not making bold as bold

i am using k shell.

Please advice
...

Hi All,

I want to make some characters to be bold in a file.

I have a file e.g aa.log which contains

rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
gfgfgdaerqrqwrqerqwrwqwrqrqwrqr...

Hi All,

How to make the characters bold in k shell.

like for example

"File is too large to view" to "File is too large to view"

is it like echo "File is too large to view"

Please...

Hi,

What does it mean what is n and length in the sample.

Can you be specific please.

Thanks-
Rajesh

Hi,

I have a log file whose size is number of characters in the file with multiple lines.

Example:
SQL*Loader: Release 10.2.0.4.0 - Production on Sat Sep 12 07:55:29 2009
Copyright (c)...

Hi Methly,

Thanks for your response,

The log file length varies.

some log files are 32765 B and some are 58853.
But what i want to do is..

If log file size exceeds 32767 B i want to...

Hi Thanks for your quick replay.

It is not deleting the charaters between nth character to nth character.

example:

123456789
abcdefghijklmnopqrst
xyzumnopqrst


i want to delete all...

Hi All,

I have a big log file i want to delete all characters (between 350th to 450th characters) starting at 350th character position to 450th character position.



please advice or...

Hi All,

Please tell me how to append some text message at the end of the file.

"File too large to view"

example: xyz.log contains
hhhhhhhhhhh
hhhhhhjjjjjjjjj
jjjjjjjjjjjjjjjjjjjjjj
"File...

Hi All

I am not able to delete few line from long file.

I have a big file which is of 53998 B in size i want to delete lines starting from 32768 to 53998 and collect remaining file in new file....

Hi All,

I have a long log file (abc.log) which contains large volume of data that need to be inserted into the database as clob.

I am having problem in inserting the long log file into the...

Yes,

I have a huge log file i want to store it into the Oracle Database using unix shell script.
Log file is siting in unix file server,
pick that file and prepare clob (as we do in java...

Hi all,

Does unix has any commands for creating BLOB and CLOB objects.

Please forward me any sites or samples

Hi

I have a log file stored in unix file server i need to prepare the clob object of that and store in Oracle Database.

Please suggest me or give me some examples

Thanks
Raj

Thanx it is working

Hi All,

I have a big file (basically .log file) want to store in oracle database.

Please help me in preparing CLOB object in unix.

The log file is stored in some location on unix file...