I'm new to PLSQL and I been testing some of its features. I need to select columns from a table and write them to an output file. How can I do this? For example, let say that I have an "EMP" table that has "NAME", and "Address" columns. How can I select both of these columns and write it to a file using PL-SQL?
(I've been trying to use a package called "logfilepkg.writelogline" which always seems to give me 21/13 PLS-00201: identifier 'LOGFILEPKG.WRITELOGLINE' must be declared
21/13 PL/SQL: Statement ignored.)
Can anyone provide me with a simple example just to get me started? Thank you very much for your time.
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…