SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL query to return a table of static values

454636Sep 16 2005 — edited Sep 16 2005

How would I write a SQL query to return multi-column, multi- row static data (i.e., strings that I enter into the query). For example, I want to return the following data that is not in a table:

NAME DESCR
Shrimp Survey The Shrimp Survey was conducted... yada, yada, yada...
Scallop Survey yada, yada...
Mackerel Survey yada, yada...

Thanks,

Joe

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2005

Added on Sep 16 2005

4 comments

1,746 views