ora-01747

Oracle 10g - ORA-01747 Error

My procedure: CREATE OR REPLACE PROCEDURE akcia_nepozicane_s_kurzorom (denny_poplatok IN NUMBER, kilometrovy_poplatok IN NUMBER) AS my_id_auto NUMBER(5); my_poplatok_denny NUMBER(4); my_poplatok_km NUMBER(2); CURSOR c1 IS SELECT id_auto, poplatok_denny, poplatok_km FROM Auta; BEGIN OPEN c1; LOOP ...

SQL Query Syntax : Using table alias in a count is invalid? Why?

Could someone please explain to me why the following query is invalid? I'm running this query against an Oracle 10g database. select count(test.*) from my_table test; I get the following error: ORA-01747: invalid user.table.column, table.column, or column specification however, the following two queries are valid. select count(test...