Pl/sql works on early binding,means the objects refererences and the privileges will be checked at compiled time. Hence if your program has to compile without errors,the tables which you are creating in the pl/sql block should exists, but until unless it runs, the table doesnot exists...
Hai,
As per my knowledge, you cannot use export.EXPORT AND IMPORT output cannot be readable by us i believe. Export can only understand import data and vice versa.
If your output file contains only few rows, then you can very well spool the file in the sqlplus prompt Like the one mentioned...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.