Is it possible to know when a stored procedure was last executed? I'm using Oracle 11g.
I've got an old app that has many years of procedures in it. The goal is to quickly identify candidates for retirement.
Thanks,
Mike
...
Is there some limit on the maximum total amount of data that can be stored in a single table in Oracle?
I think there shouldn't be because tables are anyways stored as a set of rows and rows can be chained as well. Does such a limit exist?
...
I'm trying to write a query in Oracle SQL to access a particular substring in a CLOB field.
To use the SUBSTR function, I need to come up with a starting point in the CLOB using the INSTR function.
The CLOB contains X12 data that is delimited with hexadecimal characters.
To find the starting offset for my substring, I'd like to do som...
Hi,
What I'm trying to do is copy the result of a query in oracle into table in a MySQL database. The reasoning behind this is not important to the question, and I can't really take a different approach.
What I am doing is running the query though php, then copying the result into a newly created table in oracle. I know this is not very...
Here's the situation, hugely grateful for any input anyone may have:
I have a table of about 100m rows, with (among several other fields), a text field that we can call 'product'. The product field is about 200 chars long, and contains details of, yes, products.
I want to give users the ability to search through these items by entering...
In my company they are finally (about time...) considering to convert one of our best selling apps from a 2-tier to 3-tier architecture, both on logical (Presentation, Business and Data layers) as well as physical level. Probably we will go for either a Delphi-Delphi-Oracle or a Delphi-Java-Oracle approach for the change.
This is a rel...
Hi
I want to write a query to get the names of tables of a specific database, but I don't know how can write it.
I want to execute this query for MS Access 2007 and Oracle 11g.
Thanks
...
Hi,
I'm trying to return an XML file based on my query results. I'm very new to this so I'm not really sure where I'm going wrong. Is this a realistic way to go about doing this or is there something simpler? Right now I'm getting these exceptions:
Error performing query: javax.servlet.ServletException: org.xml.sax.SAXParseException: Co...
I have an app where depending on the type of transaction being added or updated, the ticket number may or may not increment. I can't use a SERIAL datatype for ticket number because it would increment regardless of the transaction type, so I defined ticket number as an INT. So in a multi-user environment if user A is adding or updating a ...
I'm trying to load data from a file and I want to set CREATED_DATE and UPDATED_DATE to SYSDATE and CREATE_BY and UPDATED_BY to USER
Here the table that I'm working with:
CREATE TABLE CATALOG
(CNO NUMBER,
CTITLE VARCHAR2(25),
CREATED_BY VARCHAR2(10) NOT NULL,
CREATED_DATE DATE NOT NULL,
UPDATED_BY VARCHAR2(10) NOT NULL,
UPDATED_DATE DAT...
I am trying to query a SQL Server & Oracle database to get table data that would indicate if a column is auto increment or or not. I would assume you would look at the "information_schema.columns" and "user_tab_cols" tables but it doesn't seem to hold this information. Does anyone know where I can retrieve this information?
...
Hi
Currently I have three tables.
GrandParent( tel int, G_Counter int, GField varchar(10));
Parent( tel int, G_Counter int, P_counter int, PField Varchar(5));
Child(tel int, G_counter int, P_counter int, C_Counter int, CField Varchar(3));
These tables are all flat tables. And these tables loop itself and the loop is determined by the...
I have a field in my table having text data type.
Is there a difference in performance for the following two sql queries:
select * from tablename where fieldname="xyz%";
select * from tablename where fieldname="%zyx";
If we were to implement the execution of these queries, this is what I think we would need to do:
We have to match...
With Oracle suing Google over Dalvik's patent infringements, I'm wanting to get off the Java bus I've been on for 10+ years. I really enjoy coding in Java, love the tools (eclipse, profilers, etc...), cross platform, garbage collection, etc... What is the best alternative out there? I'd like to build cool gui's, mobile apps, web apps,...
Is it better to use cursor or analytical functions in a stored procedure for performance improvement?
...
Hi,
I'm trying to do a data pump export for metadata on a tablespace (COURSE). Am I on the right track? My data pump directory was created as:
CREATE DIRECTORY dpump_dir AS '/mydata/data';
Please keep in mind that I'm a beginner. This may or may not be the best way to go about this, but I'd like to try to get this working. Thanks very ...
My query:
UPDATE I_USER
SET END_DATE = (select ENDDAT
FROM TEMP_USER
WHERE USERNAME = 'ABC')
where USER_NAME = 'ABC';
This is the code for updating one row with where condition.If i want to update all the records in I_USER with the ENDDATE as per the TEMP_USER ,WHAT SHOULD I DO..?
...
We are building a client program where parameters for storage in a web server with Oracle backend are set in the .Net client program and uploaded as a dataset via webservice.
In the webservice code, data is read from the dataset and added to UPDATE statements on the web server (Oracle backend).
Because the server will run on the custom...
I don't know if thats right but for some reason my stored procedure is not rolling back after an exception occurs. So my insert statement is commited even when i get an exception
Did i forgot something?
PROCEDURE SP_USUARIO_INSERT
(
pUSU_IDUSUARIO IN OUT ENG.USU_USUARIO.USU_IDUSUARIO%TYPE,
pUSU_CDUS...
I just created a new user, it DOES have create session, but everytime i try to connect on PLSQL Developer I get ORA-00604, ORA-01722 and ORA-06512
However, if i grant DBA access, i can log on with no problems.
Hints?
I don't have any connection trigger.
...