Experts Exchange Search Results

Hi, I have a report (which for the sake of simplicity) displays the contents of a single table (Oracle 10G): SELECT * FROM PROCESS_CP WHERE UPDATE_PROC(&param_1) > 0 UPDATE_PROC is a fun...

http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23015692.html

Zones: PL / SQL, Databases, OracleDate Answered: 12/12/2007 Grade: B Views: 0

init.ora settings good or bad?

Tags: dml_lock

I use Oracle 8.0.5 on Solaris 2.6, with dual SPARC-cpu, 1 Gig of RAM and Raid 0,1 disk drives. Our anvironment is mixed, OLTP and large Batches. Are my locks, processes, MTS dispatchers, SGA ...

http://www.experts-exchange.com/Database/Oracle/Q_10233800.html

Zones: OracleDate Answered: 11/15/1999 Grade: A Views: 0

Silly Question but here goes, cannot see a certain type of...

Tags: dml, files

I'm Mac illiterate so this may be a silly question. I cannot see files on a PC server ending in dml. The files are there because I see them just fine in the PC world, but they are not displaying on...

http://www.experts-exchange.com/Apple/Operating_Systems/Q_20411085.html

Zones: Apple OS, Apple, AppletalkDate Answered: 12/02/2002 Grade: A Views: 0

Last DML Time

Tags: dml, last

Hi, Is there any way we can check when is the last DML performed in a table? Thanks.

http://www.experts-exchange.com/Database/Oracle/Q_20628334.html

Zones: OracleDate Answered: 06/02/2003 Grade: B Views: 50

ORA-14551: cannot perform a DML operation inside a query

Tags: dml, perform

I have a table, ssn_lookup, with two fields, ssn and fake_ssn. The fake_ssn field values are derived from a sequence, ssn_seq. I tried to write a function that would pass an ssn value in, look to s...

http://www.experts-exchange.com/Databases/Oracle/Q_21654882.html

Zones: OracleDate Answered: 12/07/2005 Grade: A Views: 130

Triggers: What is Actually Supposed to Happen?

Tags: audit_dml, trigger

Hello. I have this this project involving 5 tables for a simulated book company. I have a customer table, and an inventory, lineitem, address and orders table. I don't fully understand triggers. T...

http://www.experts-exchange.com/Database/Oracle/Q_10240319.html

Zones: OracleDate Answered: 12/11/1999 Grade: B Views: 0

Find the last of the DML

Tags: last, check, dml

I want to know if there is a view or a query i can run to retrieve the last DML that has occured on a table or a schema or something. I don't want to build in some triggers or anything, create a...

http://www.experts-exchange.com/Database/Oracle/Q_11509618.html

Zones: OracleDate Answered: 11/09/2000 Grade: B Views: 4

Open DML (.avi video) convert to MPEG utility ?

Tags: dml, avi, open

Hi I have a Ricoh RDC-7 Digital camera which takes AVIs in a format known as Open DML JPEG format (avi). Unfortunately the only thing that will open it is some versions of QuickTime, other apps ...

http://www.experts-exchange.com/Software/Photos_Graphics/Web_Graphics/Q_20382706.html

Zones: Web Graphics SoftwareDate Answered: 11/12/2002 Grade: A Views: 11

Developer 6i Dml Returning Value

Tags: returning, value, dml

Hi , Can anyone please help me out, There is an option in forms 6i 'DML REturning value' , which updates any changes in a record at the server side through on insert or on update database t...

http://www.experts-exchange.com/Database/Oracle/Q_20718029.html

Zones: OracleDate Answered: 09/19/2004 Grade: A Views: 0

Pl/SQL reuired for arranging a column value...

Tags: dml, inside, operation

Hi, I need a function in PL/SQL which alphabeticaaly arranges a column entry i.e. if the value of name is 'CABFG' then it is arranged alphabeticaaly as 'ABCFG'. I have written a procedure f...

http://www.experts-exchange.com/Database/Miscellaneous/Q_20767236.html

Zones: DatabasesDate Answered: 12/20/2003 Grade: B Views: 0