I want to know if it's possible to evaluate (parsing) a query outside plsql (on a web page) and pass this querystring to a plsql code which contruct a cursor out of it. On the web-page there are d...
http://www.experts-exchange.com/Database/Oracle/Q_10452676.html
Zones:
OracleDate Answered: 07/17/2000 Grade: B Views: 0
Have a package that runs correctly on my PC / ORACLE 8.0
by the customer, working with ORACLE 8.1, i can start the package but every access to the DB returns value NULL.
I see two possible t...
http://www.experts-exchange.com/Database/Oracle/Q_20060566.html
Zones:
OracleDate Answered: 01/25/2001 Grade: B Views: 0
I want by a query using sql or pl/sql get the date of the current day in the previous year (without subtracting 365)
how?
for ex. the user enter the date 3/11/2001 in text item
how can i calcu...
http://www.experts-exchange.com/Database/Oracle/Q_20225571.html
Zones:
OracleDate Answered: 11/04/2001 Grade: A Views: 0
I create some tables which have the same columns. I think that it can increase query speed while the tablename is known.
But I have trouble while I insert the data.How to execute a DML in PLSQL wh...
http://www.experts-exchange.com/Database/Oracle/Q_20285871.html
Zones:
OracleDate Answered: 04/12/2002 Grade: B Views: 0
Hi Experts,
I'm debating as to whether the following can be done in an SQL statement or if I need to write some PLSQL to achieve my result:
I have 2 tables:
Districts (A district can appea...
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_20614539.html
Hi all,
I have a long running job that last for 9 days which is written by plsql (around 10 billion insert-update, no delete)
The program is designed to be commited around 20000 insert-update...
http://www.experts-exchange.com/Database/Oracle/Q_20656051.html
Zones:
OracleDate Answered: 06/23/2003 Grade: B Views: 0
How can I wrap this in an IF statement
alter table useroptions drop constraint FK_UserOptions_LastAssetSoryID
So that it doesn't error if the constraint has already been dropped or doesn't e...
http://www.experts-exchange.com/Database/Oracle/Q_21491152.html
Zones:
OracleDate Answered: 07/14/2005 Grade: A Views: 0
Hi All,
I need to be able to write some plsql that will do the following:
plsql procedure or function that traverses more than 1 csv file looping through the filenames in a directory.
In anoth...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23097500.html
Please help sdstuber
What I mean by a generic csv reader is that when the PLSQL code is reading the data it might start of identifying that the first comma is at position 6 (meaning that the data ...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23106446.html
Hi sdstuber,
data file attached.
Your code that you had given me for previous question:
CREATE OR REPLACE PROCEDURE read_csv(
p_filename IN VARCHAR2,
p_ignore_headerlines...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23110403.html
