SQL & PL/SQL :: How To Store Spanish Content In A Table

Jul 29, 2011

The requirement is to store "Spanish" content in a table. The input will be passed from the web page. What settings do i need to make in the database to store the Spanish content. Will a varchar2 accept Spanish text ? I need to retrieve back the content and send to web page based on request.

View 6 Replies


SQL & PL/SQL :: How To Store Content Of CSV File Into Array In Oracle

Mar 25, 2010

How to store the content of a csv file into an array in oracle and then get the distinct values from the array in oracle. The requirement is only to extract the first column value into an array.

View 39 Replies View Related

SQL & PL/SQL :: External Table And Spanish Characters

Sep 27, 2011

I am having difficulty importing Spanish text files into my Oracle 11g XE database. Below is my external table declaration code. The external file is attached.

CREATE OR REPLACE DIRECTORY xtern_data_dir AS 'C:/.../';



All 406 rows seem to import fine, but do not display the Spanish accent characters correctly. Note the strange characters:



SQL> select * from et_slblwd0_spnsh_desc;

---- ---------- ------------------------------------------------------- - - - -
0001 1 Puede causar somnolencia. El alcohol puede intensificar
0001 2 este efecto. Tenga cuidado cuando conduzca veh¿los
0001 3 automotores u opere maquinaria peligrosa.
0002 1 Importante: Acabe todo este medicamento a menos que
0002 2 quien le escriba la receta le indique lo contrario.


I tried modifying my external table declaration by adding CHARACTERSET WE8ISO8859P1 and CHARACTERSET WE8MSWIN1252, but that just seems to cause the system to throw out ALL the rows containing Spanish characters:

COUNT(*) ---------- 197

SQL> select * from et_slblwd0_spnsh_desc;

---- ---------- ------------------------------------------------------- - - - -
0001 1 Puede causar somnolencia. El alcohol puede intensificar
0001 3 automotores u opere maquinaria peligrosa.
0002 1 Importante: Acabe todo este medicamento a menos que
0002 2 quien le escriba la receta le indique lo contrario.
0005 1 Debe tomar este medicamento con mucha agua.
0006 1 Puede descolorar la orina o las heces.


The log file specifies the following error on the bad rows:

error processing column LBL_DESCS in row xxx for datafile ...SLBLWD0_CRLF.TXT ORA-12899: value too large for column LBL_DESCS (actual: 55, maximum: 55)

What can I do to import these Spanish characters correctly?

View 3 Replies View Related

PL/SQL :: Join Between Table With User Based Content And Base Table

Jul 30, 2012

I stumbled about some weird 11gR2 behavior (running on AIX).When I performed a join between a table with user based content (parts belonging to an sourcing scope) and a base table (parts available) whereas the parts have to fulfill a special regular expression, it showed that the same query is faster when using outer join than inner join (about 0.7sec vs. 20sec; which makes me believe that regexp_like works wrong when involved in an inner join).

i tried the same statement with a standard like (but not fulfilling the same condition).This time performance was as expected (inner join outperforming outer join).

Oracle version information
Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE     Production
TNS for IBM/AIX RISC System/6000: Version - Production
NLSRTL Version - Production

I can see it, the execution plan for the "inner join" doesn't show so much more costs than the one for the outer (but why at all is does an inner join cost more?) ...The execution plan for both "not like" is the same and (surprisingly ;-) ) similar to "outer-regexp".

I hope sample data are not needed as there would be needed a lot...this is the second time I came across the "plan worse but execution time better" phenomenon.

View 10 Replies View Related

Security :: Spanish Character Encryption In UTF8

Jan 9, 2012

Recently the Oracle10g database has been migrated to UTF8 character set and the following have failed.

1. The password applied is not getting encrypted and the password contains a spanish characters.

Getting the below error.

"10057:ERROR WHILE ENCRYPTING GIVEN STRING:String:Uñomasuño5.::ORA-28232: invalid input length for obfuscation toolkit:-28232:ORA-28232: invalid input length for obfuscation toolkit"

The algorithm used for encryption DES. I tried with DESENCRYPT , DES3ENCRPYT and MD5 and it failing.

View 5 Replies View Related

Server Utilities :: External Table Definition And Content Of CSV File

May 26, 2010

Below is the external table definition and the content of csv file, why the first record fails ?

0546-0*LB-CRP*16*"Tech", ZAO*29-DEC-2009*29-DEC-2010***A051453*RU*29-DEC-2009*0***21-MAY-2010*21-MAY-2010 --FAILED
0546-0*LB-CRP*16*ID"Tech", ZAO*29-DEC-2009*29-DEC-2010***A051453*RU*29-DEC-2009*0***21-MAY-2010*21-MAY-2010 -- SUCCESS
0546-0*LB-CRP*16*"Tech, ZAO"*29-DEC-2009*29-DEC-2010***A051453*RU*29-DEC-2009*0***21-MAY-2010*21-MAY-2010 -- SUCCESS

View 8 Replies View Related

SQL & PL/SQL :: Store Image In Oracle 9i Table

Jan 3, 2012

I want to store Image file in Oracle table without storing it physically in the system. how can i store the image file into the oracle table and also retrieve it without storing it physically in the system at any path.

View 5 Replies View Related

SQL & PL/SQL :: How To Store Images In Table Column

Dec 21, 2011

How to store images in table column. I have table called emp with datatype empno,name,photo_id(long raw)
i want to store image in table for each record.

View 3 Replies View Related

PL/SQL :: Store Substring Output To A Table

Oct 23, 2012

declare Input VARCHAR(10) :='011000141'
declare rt StringOutput%rowtype;
SELECT SUBSTR(Input , SumOfLength - ColLength + 1, ColLength) FinalOutput INTO rt FROM mytable ;

I need to store the result to a temp table rt.

View 10 Replies View Related

SQL & PL/SQL :: Trigger To Store Session Detail In Table?

Aug 30, 2012

Is it possible to write a trigger to store the session detail in a table, only if any session deletes more than 10 records on particular tables?

View 6 Replies View Related

PL/SQL :: How To Compress Multiple Files And Store In Table

Apr 9, 2013

I am having many different files and i want to use pure plsql to get these files stored as blob from a table then compress them into 1 files and store that into another table. I did some search and its like possible but didnt get conclusive solution

View 4 Replies View Related

Convert Same Image To Blob - Store In A Dummy Table?

Jun 4, 2013

I have a table where user can store images in clob format.Need to convert the same image to blob and store in a dummy table.

I tried using this
--function creation
BUFFER RAW(32767);


View 4 Replies View Related

Oracle Store Procedure - Table Or View Does Not Exist

Nov 21, 2011

I have created this store procedure:

PrimaryKey IN NUMBER

And I get this error: Error(15,13): PL/SQL: ORA-00942: table or view does not exist

View 1 Replies View Related

SQL & PL/SQL :: Cursors To Update Data And Store It Back To Same Table

Sep 4, 2010

I'm using few cursors to update my data and store it back to the same table. But for some reason the cursor seems to be picking obsolete data.

cursor c1
select distinct roles
from table1
where flag = '1';

cursor c2
select distinct roles
from table1
where flag = '1';
for i in c1

here im updating the roles im picking to to a suffix and role.

update table1
set role = suffix_role
where 'some condition';
end loop;
commit; -- committing so changes are visible for my next cursor.

for j in c2

here im deleting all the roles that are not part of my comparing table.

delete from table1
where role = 'something';

But in my debugging table i see that its deleting roles present as input for first cursor, whereas it should actually pick data with suffix_roles.

View 12 Replies View Related

SQL & PL/SQL :: Query To Store Results - Update Values In Another Table?

Feb 22, 2010

I have a query like this -


When I execute the query, it returns the data (approx - 40,000 rows) in 1 min.But when I try to insert this data into another table (or create a table of this data) it takes me about 2 hours.

Tried using Materialized view, its again the same the refresh takes 2 hours.Basically here, what I am trying to do is the data from the above query is used to update the values in another table.What ever the procedure I am trying it takes 2 hours.

View 6 Replies View Related

XML DB :: Find Size Of Table With XML Type Column Store As Binary XML

Dec 21, 2012

I have a table with structure as:


- So HOW do I find the total size occupied by this table. Does BINARY storage work as LOB storage. i.e. I need to consider USER_LOBS as well for this. OR foll. will work

select segment_name as tablename, sum(bytes/ (1024 * 1024 * 1024 )) as tablesize_in_GB
From dba_segments
where segment_name = 'XML_TABLE_1'
group by segment_name ;

- Also if I am copying it to another table of same structure as:

Insert /*+ append */ into XML_TABLE_2 Select * from XML_TABLE_1.

Then how much space in ROllbackSegment do I need. Is it equal to the size of the table XML_TABLE_1?

View 2 Replies View Related

Forms :: PDE-PLI011 A Tools Common Schema Table Missing From Object Store

May 26, 2011

while trying to open an exisitng Form, an Error message appears as:

PDE-PLI011 A tools common schema table is missing from the object store.

and failed to open. what's the problem ? what i have to do ? it was working fine before.

View 2 Replies View Related

SQL & PL/SQL :: How To See Content Of View (deep Down)

Sep 30, 2011

a query or function which can be used to see the content of deep down view.

For Example :- create view fist as select * from second;
create view second as select * from third;
create view third as select * from fourth;

So my requirement is like dbms_metadata.get_ddl function to see the content of objects? to see the see the content of deep down view..

View 16 Replies View Related

Convert Content Of Blob Ansi To Utf-8?

Nov 25, 2011

I wondered the possibility of converting a content file in the format ansi to utf-8 directly from Oracle.

View 1 Replies View Related

JDeveloper / Java & XML :: Split HTML Content By Tag

May 15, 2012

I need to modify the content of all HTML content to be sent as response from our server according to the tag. say for example, only text content inside a td or div tag will be modified. As per solution we have thought the content will be captured in the Filter of the server. Here, we will split the content against tag and modify the desired text, and then merge them again.

So, for example, if my content is,
<td valign="center">Claim Event Code  </td>
<td><input type="text" class="field" name="EventCode"size="20"></td>
<td valign="center">
<SELECT name="pClaimStatus" >
<option value=""selected></option>
<option value="A">Notified</option>
<option value="B">Opened</option>

then my desired output (may be an array) will be like this --
1. <tr>
2. <td valign="center">
3. Claim Event Code  
4. </td>
5. <td>

so that now I can work upon item 3, 13, 16 and so on. Is this method is ok? if so how could we split and get such array in java.

View 8 Replies View Related

Forms :: Text Item Content Disappear

Mar 11, 2010

I have data Block with many Items, text item content disappear after when mouse down trigger fire on text item in the same block!!!!!!!!!

View 1 Replies View Related

Forms :: R12 Customization (content With Tab And 2 Stacked Canvas)

Mar 27, 2013

I have a requirement to create a new form in R12 . I need a tab page which has two scrollbars (both horizontal & vertical) . Hence I am using content canvas with tab canvas and 2 stacked canvas. The problem is that the design is looking ok on form builder but when I view the form on oracle ebs , I don't see the tabbed canvas .

View 4 Replies View Related

PL/SQL :: Escape HTML Content Without Escaping Tags

Jul 4, 2013

How can I escape HTML content without escaping the HTML tags?

View 4 Replies View Related

SQL & PL/SQL :: Comparing Schemas - Content (data) Identical

Jan 20, 2011

I have two schemas with 149 tables in each schema, what I need to do is to prove that the content(data) between the two schemas is identical. I know that all the table names between the two schemas are the same, just need to prove that there is no difference in data.

So the query needs to prove that Schema A content = Schema B content

I know I cant do a simple select from Schema A.tab1 minus select Schema B.tab1 but since there are 159 tables, I am not sure if this is an efficient way of doing it.

View 14 Replies View Related

How Long Does Content In Oracle Recycle Bin Stay

Oct 10, 2012

Using oracle long does the content in recycle bin stay?

e.g is it dependant on size of undo tablespace and expires after certain time? Also if drop table, then recreate table with same name will this wipe the dropped table from the recycle bin automatically?

View 4 Replies View Related

Save PDF File Content To BLOB Field In Oracle?

Dec 6, 2008

how to write a procedure in oracle to Save pdf file content to BLOB field in Oracle....

View 11 Replies View Related

SQL & PL/SQL :: Insertion Of Text Content Length Contains More Than 4000 Into CLOB?

May 31, 2011

i want to insert the text lenght containing more than 4000 characters, that column datatype is in CLOB Even though in CLOB we can able to store upto 4GB. Its not allowing me to insert more than 4000 characters at a time , but we can able to insert by splitting the data by 4000 and can append remaining characters But i am receving the text contains more than 4000, that how can i split the data upto 4000

View 6 Replies View Related

Reports & Discoverer :: Parameter Wise Report Content

Jan 10, 2012

I developed a report for bar code and it is running well.the contents in one bar code are Item name,code,price.I designed 4 pieces in a page and generate also 4 pieces in a page.

But Now I want to generate the report with a parameter where I can mention how many copies of bar code will generate in a page for this specific item.

If I put 3 pieces in parameter then bar code will generate 3 pieces. or so and so.

View 1 Replies View Related

Forms :: Alerting User When Changing Field Without Content?

Jan 5, 2012

I had created a form, in that i having two fields for username and password.

The problem is i want to make the fields as fill must.

if the user leaving the username field without entering anything trigger must raised. Otherwise if we are entering the data it should allow him to go for the next block without any raising of triggers.

View 8 Replies View Related

Reports & Discoverer :: Order Matrix By Cell Content?

May 30, 2013

I have a matrix report that shows production per year(horizontal) and per country(vertical). The customer's willing to see the data ordered by production, and not per country. I tried to add a CF containing the production in the country group and order by that one, but I'm getting a message saying that the field object cannot be contained into the frame. Both the field and the containing frame are set to Variable. how to get rid of the error or how to achieve the main goal of ordering by the cell content?

View 11 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved