Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic printing of contents of tables
Dynamic printing of contents of tables [message #233252] Wed, 25 April 2007 06:50 Go to next message
gustav80
Messages: 1
Registered: April 2007
Junior Member
Hello,

Is it possible to write a dynamic procedure that takes as parameters:
* table_name
* column_string (on f.ex. on format: "id,name,phone")

.. and have the procedure print:
id = [the value]
name = [the value]
phone = [the value]

?

I need such a general procedure to easily print some of the values in records in different tables.

Note: The number and types of the columns inputted will vary


Thanks in advance.

/Gustav
Re: Dynamic printing of contents of tables [message #233253 is a reply to message #233252] Wed, 25 April 2007 06:58 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

take a look at this

http://orafaq.com/node/1836

regards
shanth
Re: Dynamic printing of contents of tables [message #233255 is a reply to message #233252] Wed, 25 April 2007 07:06 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have a look at Tom Kyte's print_table function.

Regards
Michel
Previous Topic: Packages
Next Topic: generating text file using PL/SQL
Goto Forum:
  


Current Time: Fri Dec 06 02:36:37 CST 2024