Good evening, experts!
I have a table and a view on that table.
i've created a fga policy on my view and policy handler in package.
first field of view is a function which gets a value of packag...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23087652.html
I need to get the "date modified" from a file using pl/sql. I've looked at UTL_FILE, but I can't seem to find anything there. Is there a way to retrieve this date?
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23131759.html
I'm trying to perform a decode on a date field. If the field resolves to 12/31/9999, I want to save the date as a NULL. The record is saved in the table as a DATE in the following format: MM/DD/YYY...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23404894.html
Hi guys,
I am trying to use UTL_FILE in Oracle 10g to be able to read BLOB fields that store .PDF, .RTF, and .HTML data. Once retrieved, I want to be able to open them in their native programs....
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23428365.html
I am developing a way to generate xml files from tables information in oracle 10g. I found the pipeline table function a good manner of doind this king of job.
The problem is that I have some tabl...
http://www.experts-exchange.com/Database/Oracle/Q_23566702.html
The subject basically covers the question.
Is it possible to display a .xsql page with dbms_output.put_line?
http://www.experts-exchange.com/Database/Oracle/Q_23690521.html
Below is my code !
With the one row , i use the first code , it is okie and function Take_main_f() can work .
Because, maybe appl_slip.target_idt returns more than 2 rows so i use Loop as second ...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23730979.html
I have used bind variable in the past but it seems to have been awhile since I am not sure what the issue here is. Any help is appreciated.
When I run the following I get the below error (see co...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23118938.html
First question is; is this possible?
Next would be what am I doing wrong. Basically I am wanting to connect to http://www.webservicex.net/usweather.asmx?wsdl in order to query the web source and...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23638192.html
With Oracle 10.2.0.4 (Aix 5.3) The code attached returns
w_end_date 01-DEC-09
that is functionnaly incorrect (Char comparison)
With Oracle 8i the result is
w_end_date 21-OCT-08
that is funct...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23681376.html
