|
|
Browse by Tags
- 00904
- 04098.00000 trigger %s.%s is invalid and failed re-validation
- 10
- 10.2
- 10.2.0.1
- 10G
- 10g or 11g
- 11G
- 8
- 8.5
- 9
- 9.0
- 9.2.0.6
- 9i
- aggregate
- all objects stored in one tablespace
- any
- APEX
- append
- Application Express
- argument
- array
- bind varialbe
- Bulk Collect
- CallableStatement
- character set
- characters encoding
- check
- Collection
- CONCAT
- CONSTRAINT
- COPY
- Corporate
- curson
- cursor
- cursors
- database
- datapump
- DBA
- dblink
- dbms_xmldom.newDOMDocument
- DECLARE
- DECODE
- didnt test on 11
- DISTINCT
- dom
- Dump
- DUPLICATE
- dynamic sql
- error
- Error 201 at line 6 column 8 identifier 'PARTY_SERVICE_EXCEPTIONS' must be declared
- file
- Firefox
- FireFox 3.0.1
- FOR
- forms
- Forms 9.0.4 against 10.2 dbase
- function
- Heirarchical
- Heirarchy
- Hex
- HL7
- How much does a database trigger slow down inserts and updates
- How to get the primary columns for a table with select statement in sqlplus
- How to pass array through callableStatement?
- identifier
- IE
- IE 6
- IE 6-7
- IE 7
- IE6
- IE7
- impdp
- insert
- insert into
- Internet Exloprer 7.0
- Internet Explorer
- Internet Explorer 7.0
- java
- loop
- n/a
- none
- oracle
- Oracle 10
- Oracle 10 g
- Oracle 10g
- Oracle 9i
- Oracle Forms
- oracle PL/SQL
- oracle10x
- package
- performance
- pivot
- PL/SQL Programming
- procedure
- sql
- table
- VB.NET
- xml
-
How to get the primary columns for a table with select statement in sqlplus
Have a table A. Would like to use a query to get the columns consisting of the primary key. A (col1 number, col2 varchar2(10), col3 timestamp, col4 varchar2(20) ) The primary key consists of col1 and col2. How to use a query to get the columns out? -
PL/SQL CASE with IF/THEN Problem
The following code works down to the CASE statement, then stops. Errors indicate that the CASE statement is not coded correctly or is syntactically incorrect. I've tried to follow the format for this statement as presented in the online Oracle documentation, but I still cannot get it to work. This... -
How to pass array through callableStatement?
I have a VARRAY type in oracle. Type ValueList is Varray(100) of varchar2(4000); and a procedure like this procedure proc_name(a number, b varchar2, vlist ValueList, c in out varchar2, d in out number, e in out varchar2); Both the package and procedure is in the pakackage say pack_a now I want to pass... -
Selecting distinct values n mysql query
I am querying a bug database to find out the no. of bugs marked as resolved within select p.reportername, sum(if(datediff(curdate(),ba.bug_when) sum(if(datediff(curdate(),ba.bug_when)> 7 ) as 'More than 7 days', count(*) as Total from bugs b, bugs_activity ba, profiles p where b.reporter=p... -
Can Oracle 10g PL/SQL send an single email with multiple recipients?
Can Oracle 10g PL/SQL send a email to multiple recipients on one email using UTL_SMTP? (UTL_MAIL is not an option.) My stored procedure is called by a CRON job to read a table of unsent emails. It works fine for one email address, but fails with two or more email addresses. The error I receive is : ORA... -
PL/SQL Declaring cursors with Parameters
Informational question I have a contractor coding a parameterized cursor like I've never seen before. Their claim is this how they teach it in class. That's their blanket response, but they can't explain why this is done or the performance implications. I would like to expand my knowledge... -
Processing large xml files using Oracle PL/SQL
Dear Experts, I am trying to load an xml file using pl/sql and process each node within. I have it working for a file that contains 19678 rows or less. Unfortunately, when I attempt to process a file containing 85000 rows my program stops processing at 19678 rows. Using another computer yields results... -
Concatenating clob, long and char?
I want to insert a value into a clob column in a table. The value should be concatenated using a clob value from another table, a long value and some characters. Like this: insert into mytable1 (myclobcol) select clobcol || longcol || ' }' from mytable2; I have tried all kinds of conversions... -
MaxDate and Second to max date
Hi all, Ok Ill provide 2 records to start the ball rolling Worksrollnumber Surname Latest Pay Date Amount Last Pay Date Amount 123456 Bloggs 21/10//08 890 21/09/08 890 789101 Doe 21/010/08 1000 21/02/08 650 Ok, the 2 records above are what I want to see, and a comparison will be done to highlight differences... -
LOV with select query and order by clause using P_ITEM
Hello guys! I have a special request that I'm focussing on. I have a couple of select lists in my application that contain tree species. On the first page the user has the opportunity to assign a ranking to the respective tree species. The database column storing that information is named INT_BEDEUTUNG...