Oracle 10g - Using wildcard with inner join
450825Aug 20 2005 — edited Aug 20 2005I 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