Pl/SQL How-to

[TMoore]

Hi all

I download trial developer I have 2 question:

1. When I try to use command *copy to excel*, field type VARCHAR2 it convert to number in EXCEL so when I have '00004342' it convert to '4342'. How to prevent this??

2. How to update, edit values, records in table after select command without horrible ROWID??
In SQL navigator this is done more convenient way

cheers
Tomasz

 

[hbar]

Can you append a single tick to the leading edge of your varchar2/number column?

SELECT chr(39) ||x.object_id
FROM all_objects x
WHERE owner = USER;

The leading tick is supposed to tell XL not to do anything with the value. But it's not quite working....if I paste it, the tick appears in the cell. But if I just type a tick followed by a number with leading zeroes, it works perfectly.

So I guess this post is nearly useless.

 

[Marco Kalter]

1. When I try to use command *copy to excel*, field type VARCHAR2 it convert to number in EXCEL so when I have '00004342' it convert to '4342'. How to prevent this??

This should be fixed in 5.1.4. Perhaps you are using 5.1.3 or earlier?

2. How to update, edit values, records in table after select command without horrible ROWID??

You can't, the rowid is currently required to identify the record.

 

[fraenkg]

may be you can use

select t.* from table for update;

istead of

select t.*, t.rowid from table t;

Then no rowid is shown in editable grid.

fraenk

 

[TMoore]

I downloaded version 5.1.3.704 and trial ends for 2 day. Can I uninstall it and install 5.1.4 with new period of trial?

Option *for update* lock records!! it is not usefullf for me.

 

[Marco Kalter]

That will not reset the trial period, but if you send me an e-mail I will arrange a trial extension.