Home
Level Extreme platform
Subscription
Corporate profile
Products & Services
Login
FRANÇAIS
Home
FRANÇAIS
Level Extreme platform
Login
Best practices
Testimonials
Downloads
Articles
Subscription
Subscribe or renew
Benefits
Donate 5$
Donate 10$
Donate 15$
Donate 20$
Donate 25$
Corporate profile
Overview
Portfolio
Products & Services
Consulting services
Enterprise hosting
Web Site Hosting
Graphic design
Book publishing
Support
Troubleshooting
Problem with logins
Contact us
Legal
Copyright
Privacy policy
Terms & Conditions
Français
Fetch all columns of a cursor's row into a variable
Message
From
11/01/2002 07:49:29
Tim Mcconechy
Runtime
Vejle
,
Denmark
To
09/01/2002 15:17:02
Christian Cote
Les Logiciels Onoma Inc.
Longueuil
,
Quebec
,
Canada
General information
Forum:
Oracle
Category:
PL/SQL
Title:
Re:
Fetch all columns of a cursor's row into a variable
Miscellaneous
Thread ID:
00602646
Message ID:
00603412
Views:
29
>HI,
>I would like to fill varchar variable with values of all columns of a single row. Once I get this row, I can do something like :
>
>myColumnsValues VARCHAR2(2048);
>BEGIN
> myColumnsValues :=
> EXECUTE IMMEDIATE('INSERT INTO MY TABLE(myList) VALUES (:1)' USING myColumnsValues;
>END;
>
>Is there a package (dbms_sql) that can do it or another way to get all values into a single variable ?
>
>Thank you for your help,
>Christian Cote
Hi!
Check out DESCRIBE_COLUMNS in DBMS_SQL
Here's an example:
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/dbms_sq2.htm#1004872
Of course you'll have to work it through.
Previous
Next
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only
Click here to load this message in the networking platform
Level Extreme platform
Best practices
Testimonials
Downloads
Articles
Subscription
Subscribe or renew
Benefits
Donate 5$
Donate 10$
Donate 15$
Donate 20$
Donate 25$
Corporate profile
Overview
Portfolio
Products & Services
Consulting services
Enterprise hosting
Web Site Hosting
Graphic design
Book publishing
Support
Troubleshooting
Problem with logins
Contact us
Legal
Copyright
Privacy policy
Terms & Conditions
Login
Google
Copyright © 1993-2024 by Level Extreme Inc. All rights reserved · Website by
levelextreme.com