-
Debug PL SQL
How can we generate debugging output from PL/SQL?
-
What is the need of primary key as opposed to using not null and unique ?
we can create a column with' not null+unique' with out using primary key
-
Problem with Utl_file.fopen
Hi,There is problem with ult_file.fopen. When I run from the server side, there is no issue with utl_file and it is working fine.If I run the same procedure from Client machine, I am facing problem. It throws an exception Invalid_operation.I am using Oracle 8.2 and Unix server.Can you please let me know what change needs to be done? Is this related to permission issue.Thanks & Regards,Ananth P
-
-
Diffence arrays and pointers?
Ø Pointers are used to manipulate data using the address. Pointers use * operator to access the data pointed to by themØ Arrays use subscripted variables to access and manipulate data.Array variables can be equivalently written using pointer expression.