topic Re: Extract String with parentheses from DB in Operating System - HP-UX

Extract String with parentheses from DB

erwin_16 — Mon, 28 Jun 2004 01:01:23 GMT

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

Re: Extract String with parentheses from DB

Sanjay Kumar Suri — Mon, 28 Jun 2004 01:04:51 GMT

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

sks

Re: Extract String with parentheses from DB

erwin_16 — Mon, 28 Jun 2004 01:49:19 GMT

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));

}

Re: Extract String with parentheses from DB

H.Merijn Brand (procura — Mon, 28 Jun 2004 02:07:14 GMT

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

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

Re: Extract String with parentheses from DB

Sanjay Kumar Suri — Mon, 28 Jun 2004 02:17:28 GMT

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

Re: Extract String with parentheses from DB

Alexander M. Ermes — Mon, 28 Jun 2004 02:17:42 GMT

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

Re: Extract String with parentheses from DB

Yogeeraj_1 — Mon, 28 Jun 2004 04:24:28 GMT

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.