Help with Pl/SQL

Hi

I have a table with 3 columns .

name, type and IP

Is there a way , I can update Name = ' Name' (witha leading space where type =PRINTER.

Regards

How many places are you going to post this question?

No more !!

Thanks

That's okay - I was getting ready to give you five different answers - one for each forum!

Just for your ref

I have 368 rows with Printers in them .

Regards

Alrighty then.

Here is one way: use SQL to write SQL for you and spool the output to a file.

select 'update table_name set name = '||chr(39)||chr(32)||name||chr(39)||'
where name = '||chr(39)||name||chr(39)||' and
type = '||chr(39)||'PRINTER'||chr(39)||';' from table_name;

This generates

update table_name set name = ' ATKINS'
where name = 'ATKINS' and
type = 'PRINTER';

How does that work for you?

Sorry to say that...But your quastion is so funy for a site called (DBA SUPPORT)...I Think you are not even related to ORACLE software...dont get offended PLZ..

Thank you for your contribution, dba_junior. You were more than helpful. I can only hope that my suggestion is up to the lowest standard you have for development.