Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
sqlplus userid/password @test.sql 'SCHEMA1','SCHEMA2','SCHEMA3'
DEFINE SCHEMAS="&1" PROMPT &&SCHEMAS prompt SCHEMAS select table_name from all_tables where owner in (&&SCHEMAS);
SCHEMA1 select table_name from all_tables where owner in (SCHEMAS1); ERROR at line 3: ORA-00904: "SCHEMAS1": invalid identifier
Add your voice to the tech community where 5M+ people just like you are talking about what matters.