Name of the column in the SELECT:: CHANGE

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc

Poston Fri, 11 Feb 2005 1:43 pm

Guys, good afternoon.

Would I give a select on a table, and the result of the column be her name?

Ex: table cars (1 line) cod description 001 Monza (COMES OUT TODAY): Select cod, description from cars cod description 001 Monza (LIKE so): Select cod, description from cars cod Monza Monza 001 many thanks.

Location: Araraquara - SP

Poston Fri, 11 Feb 2005 2:16 pm

Why do you want this?
And if the table has two rows? (Monza and Fusca) How would the name?

I don't understand ... : roll:
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

Poston Tue, 15 Feb 2005 4:38 pm

The only way I know to make something Hash table is where the name of the index would be equal to the INDEX VALUE of what you could do is create something dynamic and something like the Execute Immediate and assemble the sql string and pass a variable with the name of the column ... dae quando você run the name will be the one ... but a também know if it works ... the version of oracle that I have at the moment a supports the Execute Immediate ... otherwise I would try to make an example, but if you want to see how it works, ... h_901.html low the Guide to PL/SQl and take a look at part of dynamic SQL .... I think will help you ...
[] 's
Location: Videira - SC

  • See also
    Last Post

      Return to PL/SQL

      Who is online

      Users browsing this forum: No registered users and 10 guests