Skip to Main Content

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!

Oracle 10g - Using wildcard with inner join

450825Aug 20 2005 — edited Aug 20 2005
I need to create a stored procedure that retrieves all the columns in one table using some columns in a second, related table as criteria. I only want columns from the first table to be included in the resulting rowcursor, but the first table has many dozens of columns, and I'm going to have to write many similar stored procedures, so I don't want to explicitly list out all the columns names unless absolutely necessary. My first approach was something like this:

SELECT TblBillGrouper.* FROM
TblBillGrouper INNER JOIN TblGroup
ON (TblBillGrouper.Group_Id = TblGroup.Group_Id)
WHERE TblGroup.Group_Name = p_Group_Name

where p_Group_Name is a parameter.

However, Oracle 10g reports a syntax error on the wild card, TblBillGrouper.*, even though I can do this in some other DBMS.

Thanks in advance,
Bob Gardner
wanderingbob@ev1.net
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2005
Added on Aug 20 2005
3 comments
686 views