Print Thread
Feature request: column name in RECORD, VARRAY and TYPE
#23365 07/26/06 02:02 PM
Joined: Dec 2003
Posts: 14
T
TMoore Offline OP
Member
OP Offline
Member
T
Joined: Dec 2003
Posts: 14
Hi

One of the horrible thing is rewrite column in RECORD, VARRAY, for example:

declare
my_rec emp%ROWTYPE;

begin
select * into my_rec from emp;

dbms_output.put_line( my_rec. <- PLSQL dev should assist you selecting column name in RECORD

This functionality is normal in JAVA IDE, so we need them in PL/SQL

Re: Feature request: column name in RECORD, VARRAY and TYPE
#23366 07/26/06 06:31 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
This works fine for me. Are you using the latest release?


Marco Kalter
Allround Automations
Re: Feature request: column name in RECORD, VARRAY and TYPE
#23367 07/31/06 08:43 PM
Joined: Dec 2003
Posts: 14
T
TMoore Offline OP
Member
OP Offline
Member
T
Joined: Dec 2003
Posts: 14
Ok, it work in procedure window but not in usual sql window when I write some test and develop custom PL/SQL piece of code.

Re: Feature request: column name in RECORD, VARRAY and TYPE
#23368 07/31/06 09:46 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
This does indeed only work in the Test Window and Program Window.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.032s Queries: 14 (0.005s) Memory: 2.5041 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-03-29 05:03:28 UTC
Valid HTML 5 and Valid CSS