t.*?

[informer30]

Hi All,

I am new to oracle and programming...

Can someone tell me what t.*, means from the below statement?

select t.*, t.employee.id from hr.employees t

Many Thanks

 

[taupirho]

It means select all columns from table t


In order to understand recursion, you must first understand recursion.

 

[Beilstwh]

The part of the statement "employees t" means to assign the alias T to the employees table. As taupirho said, the * means everything in the table.

Bill
Lead Application Developer
New York State, USA

 

[SantaMufasa]

Actually, I'm puzzled by informer30's code:

select t.*, t.employee.id from hr.employees t

What does "t.employee.id" mean? I could believe the code if it read:

...t.employee_id

...where "employee_id" is a column in the table "hr.employees", but not as "t.employee.id".

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[informer30]

Santa,

it was a quick code compile, I was in a hurry....but I think I get the point of t*

Cheers