Extract String with parentheses from DB

[erwin_16]

Hi,
I has been tried extract a Hebrew or English string that contain parentheses from table in Oracle DB and i got defective string that the parentheses are not in their original place.
anybody kmow the reason?
Thank's

[Sanjay Kumar Suri]

Can you share the SQL that being fired and the results returned by SQL?

sks

[erwin_16]

Statement s = con.createStatement();

ResultSet rs2 = s.executeQuery( "SELECT e.DESCRIPTION FROM equipment e,item i WHERE e.itemnum = i.itemnum and in2='Y' and i.itemnum='884841'" );

while (rs2.next()) {

System.out.println( "%%%%%%%%%%%%%% string=" +rs2.getString(1));

}

[H.Merijn Brand (procura]

is this Python?
It's not SQL. That's for sure.

Enjoy, Have FUN! H.Merijn [ who knows nothing about python ]

[Sanjay Kumar Suri]

What is result of following SQL and what was expected?

SELECT e.DESCRIPTION FROM equipment e,item i WHERE e.itemnum = i.itemnum and in2='Y' and i.itemnum='884841'

sks

[Alexander M. Ermes]

Hi there.
As far as i can see this is embedded sql.
Any result ? if yes, pls let us see for further examniation.
Rgds
Alexander M. Ermes

[Yogeeraj_1]

hi,

is this VB?

anyway, can you post the output of "describe" at the sqlplus level of both tables?

we would get an idea of the datatype for the "description" field.

If possible, let us also have a glimpse of the following PLSQL block execution at the sqlplus prompt.

begin
for r1 in (SELECT e.DESCRIPTION FROM equipment e,item i WHERE e.itemnum = i.itemnum and in2='Y' and i.itemnum='884841') loop
dbms_output.put_line(r1.description);
end loop;
end;

regards
Yogeeraj
ps. don't forget to issue a "set serveroutput on" before executing this plsql block.