In otherwords say you want to login as sysdba then you just do this: sql / as sysdba And you […]
This one is powerful enough that I would just like to reference Jeff Smith’s post on the subject: Generating User
No it is not required to use sqlcl for this. sqlplus or any other sql execution tool of your choice
Here is a easy example of a sql script that generates sql statements and then executes them. Hope it helps.
The following controls both sqlDeveloper & sqlCL defaults. Select off the sqlDeveloper Menu: Tools->Preferences->Database-Utilities-Export or Tools->Preferences->Database-Utilities-Import