Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Articles & Videos
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
I need to know how to write an Oracle function that will take an array of key/value pairs and insert items into a table.
The parameters need to be: FileName (VARCHAR2), Keywords(array of key/value …
My data looks like this:
I have an Oracle 10g database on my computer and I would like to extract some data via an SQL query. I do not know the database schema so I would first need to extract the schema and th…
My RMAN restore is failing. I am restoring from a Cold Backup made to a database on server A to a another server B.
Below the the complete RMAN session.
Please let me know if i am…
Can anyone provide steps to upgrade manually from Oracle Database 22.214.171.124 to Oracle 126.96.36.199?
I have installed 11g forms builder on my windows 10. Here I have created few forms. When I try to compile them in unix server using frmcmp command it says cannot open file.
( the form…
Guys I am working on a project to extract large amounts of BLOBS data back into their original file types, I have it where I can extract 1 BLOB but I'm looking at thousands here so any help is greatly…
I am using Aqua Studio, and am trying to create a new column in a database table. I have tried using both of the alter statements
below, but when I run them I get this error message:
> Script lin…
I need to only retrieve the last record when this Oracle 9.2 query executes.
DI 2016-09-26 168398 063848979 //SRC RMS
I would also like another Oracle query that only retrieves the fir…
I have 2 problems here.
Courses aren't grouping together. My results have the same course listed several times with different count(*) per row. Each identical course_name and course_number shou…
While trying to create a DB in Oracle 11G (0.3) , the DB creates , but with the error in attachment. I can see the Listener service and the DB service running correctly.
Any idea on wh…
Thanks to slightWv for the excellent solution copied herewith below
marked '-- Two PAYER_TYPE_CODES'.
count(case when payer_type_code …
Payers have PAYER_IDS and PAYER_TYPE_CODES.
Looking for Payers that have two PAYER_TYPE_CODES
where those two PAYER_TYPES_CODES are 17001 and 17002.
Tried the query copied herewi…
Experts, I have the basically two tables and one view to get the desired result set--
SOXDEFINITION, SOXPRICE and COMPVIEW
need to tie "SOXDEFINITION" to "COMPVIEW" by using the VALUE of the Alias…
ORA-00900 : invalid SQL statement
Script line 3, statement line 1, column 0
I can create the simple stored procedure below. However if I try an execute it, I get the error messages shown below. …
I have a function that politely pads input with trailing spaces to match the length of the column specified. It looks like this:
This function works fine in Oracle 11g but when I try to run i…
This post first appeared at Oracleinaction (http://oracleinaction.com
I will demonstrate that undo for DML’s is stored both in undo tablespace and …
I would like to create a Linked Server from a SQL Server 2008 Database to an Oracle 11g Database using my OPS$ Windows Authenticated account.
However, no matter what I try it doesn't want to work. …
I'm trying to create a report in Oracle APEX (version 3.2.1) and the report should retrieve values from a database view based on what the user selects into the shuttle box.
I created …
Can someone tell me how I can only return results when the total of a column is greater than 5 when the values in the column use 2 decimal places?
I have a column called earnedcredits where there m…
Hello experts, I need your help,
I have two different databases: Oracle and Pervasive; each database have a table that it "supposed" to have the same information.
Both tables have the same column…
Additional help on the existing question
I was trying the code with sprof_id = 12031757458 and Tail = XXYYZZ and pspec…
I have a select stmt with the following output.
empID FirstName LastName Work_type Rate
00001 John Smith RE 20
00001 John Smit…
I have a few questions regarding Pfile and SPfile. I am a bit confuse.
a) How can i check if my database was started using spfile or pfile ?
b) How can i check if both the Pfi…
How Oracle Stores Passwords Sean D. Stuber 2009-06-09 Up to date through Oracle version 11g Overview: Many times a DBA may want to replicate a user from one syste…
How to Send Email Attachments with Oracle PL/SQL
By Sean D. Stuber
Part I: How to Authenticate to an SMTP server with Oracle PL/SQL (http://www.experts-exchan
slightwv (䄆 Netminder)
13,600 points this week
6,000 points this week
Cliffside Park, New Jersey, United States
4,000 points this week
3,600 points this week
3,600 points this week