Oracle Server is a relational DBMS (Database Management System) created by Oracle Corporation. Do NOT use this tag for other DBMS servers owned by Oracle (for instance MySQL, TimesTen and Berkeley DB).
0
votes
3answers
48 views
Multiple decimal string conversion to number
Working on 10g.
I have a regexp that returns the records numeric values, but in some cases returns multiple decimal points such as 68.70125195853.50
What I need is a way to only return the two ...
0
votes
0answers
6 views
IIS server reading oracle parameters differently than my local Machine
I'm having issues trying to move my website (asp.net) to the webserver. Locally everything works and the insert statements uploads into the database. When i move to the server the data types seem to ...
0
votes
2answers
25 views
Order by time for sysdate
I have date displayed like that :
So here is how it works, an user fills a form, when he cliks on submit button, I save the datas in my db with a procedure, and I add sysdate in order to make an id ...
0
votes
1answer
16 views
From XML to list of paths in Oracle PL/SQL environment
Please suppose you have a XML file (stored, for example, in an Oracle table which has also a CLOB column):
<ALFA>
<BETA>0123</BETA>
<GAMMA>2345</GAMMA>
...
0
votes
5answers
787 views
find the missing values from a set of values, using SQL
How can I find a missing values from a set of values, using SQL (Oracle DB)
e.g.
SELECT NAME
FROM ACCOUNT
WHERE ACCOUNT.NAME IN ('FORD','HYUNDAI','TOYOTA','BMW'...)
(The "IN" clause may contain ...
0
votes
1answer
34 views
SQL query within BASH
I have a BASH script like the below:
#!/bin/bash
email_template="Subject: Subject
From: [email protected]
To: %s
%s
%s
%s
"
cat test.out | while read num email limit orders; do
echo "Sending ...
4
votes
5answers
5k views
What is the best online SQL tutorial for learning to write complex reporting queries? [closed]
My SQL skills are rather limited and since I find myself working with a DB (Oracle) a lot lately I would like to get beyond the basic select statements.
I want to write queries that do things like ...
-2
votes
2answers
31 views
Single query to update records with different values based column value in oracle
I need to update a column person_id in a table based on the other column family_id. Multiple records can contain for each family id. I want to set person_id values starting with 1 and increment by 1 ...
2
votes
2answers
641 views
JDBC Oracle Query. Slow when executing with setInt() instead of setObject()
I have the following fragment of code:
public static void main(String[] args) throws SQLException {
Connection c = getConnection();
long time = System.currentTimeMillis();
...
0
votes
2answers
46 views
Creating Trigger that runs on two tables
I have two tables, COURSE and OFFERING. Their columns are:
COURSE (
courseId,
title,
cost,
duration
)
and
OFFERING (
offeringID,
instructor,
startDate,
...
-2
votes
0answers
19 views
download link for oracle 12 client [on hold]
We can't access to the www.oracle.com site in our network. (for each reasons)
I can just found this oracle link for download oracle 12 client:
...
12
votes
7answers
23k views
jdbc connection pooling
Can anybody provide examples or links on how to establish a JDBC connection pool?
From searching google I see many different ways of doing this and it is rather confusing.
Ultimately I need the code ...
0
votes
1answer
15 views
Insert SQL Command with dynamic Username and rowtypes
I'd like to generate a dynamic Insert statement with different Username and data from a rowtype
my snippet
create or replace procedure test()
is
TYPE cv_typ is REF CURSOR;
cv cv_typ;
stmt ...
1
vote
4answers
75 views
Not Equals (!=) not operating as expected
first off do you see a problem with this code;
SELECT num,
surname,
firstname,
ward
FROM doctor, ward WHERE num != consultant;
NUM SURNAME FIRSTNAME W
---------- ...
2
votes
1answer
1k views
INSERT INTO TARGET_TABLE SELECT * FROM SOURCE_TABLE;
I would like to do an INSERT / SELECT, this means INSERT in the TARGET_TABLE the records of the SOURCE_TABLE, with this assumption:
The SOURCE and the TARGET table have only a SUBSET of common ...
