[andrew]

I have successfully installed DBD::Oracle, however when running the query below I am seeing errors, can anyone tell me what Perl is complaining about?

SQL:
my $sql = qq{SELECT FROM sched_table from def_tables where user_daily=’SYSTEM’};

Error:
DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD ERROR: error possibly near <*> indicator at char 7 in 'SELECT <*>FROM sched_table from def_tables where user_daily=’SYSTEM’') [for Statement "SELECT FROM sched_table from def_tables where user_daily=’SYSTEM’"] at ./dbscript.pl line 26.


Many Thanks,
Andrew