How can I go about exporting DDL of all my schema views in single .sql file ?
I've read there is a function
DBMS_METADATA.GET_DDL But I can't figure out how to use it for my case.
I know how to do this for one view (Oracle Entreprise Manager->MySchema->Views->Selecting my view->show object DDL->Save..)
I'm using SQL*Plus