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).
1
vote
1answer
14 views
oracle database and users
Hi!
I'm just starting to learn about databases, oracle in general. I messed around in the Oracle SQL Developer and a very very basic question arose in my mind :)
In Oracle SQL Developer, you have to ...
0
votes
0answers
3 views
Load CLOB into Column from Local File (not oracle server)
I would like to load a txt file into a CLOB field. The catch is that the file resides on the local disk (not on the oracle server). Is it possible to do this with pl/sql, running windows, perhaps ...
2
votes
1answer
33 views
populating missing rows in oracle sql
I have following data:
date product amount
2013-01-31 a1 100
2013-02-28 a1 200
2013-01-31 b1 700
2013-04-30 b1 100
2013-06-30 b1 ...
0
votes
0answers
16 views
ASP Checkbox boolean value
My ASP detailsview and Gridview have a bunch of checkboxes bound to fields right now that are in an Oracle database. To my knowledge, Oracle doesn't actually have a Boolean value (Y/N instead).
Right ...
0
votes
0answers
11 views
Oracle - Create two tables of different schema with same name in same table space. Is it valid? Does not produce any errors?
I Understand that we can have tables with same name as long as they are in different schema. Let say, both schema tables are dumped to same tablespace even then it is valid? I think as per my ...
0
votes
0answers
14 views
concatenation of CLOB using FOR LOOP in PL/SQL and storing in a table taking longer time than expected
This procedure is being called from a script. In Dev, ST, UAT it's completing very fine. In PROD the control is not coming out. May be issue with the CLOB's. How to use temporary CLOB in this case to ...
0
votes
1answer
42 views
Database Link to access Columns in Table SQL
I am trying to update a table in my SQL database using a datalink to another DB.
I am using:
update TestTable
SET some_column1=table.ColumnName1@dataBaseLink,
...
1
vote
4answers
36 views
SQL - Insert Using Column Name as Value
I am trying to do an insert into table2 based on a select from table1, but I can not get the correct syntax. The column names from table1 will drive the value being inserted into the PD_NO column in ...
0
votes
0answers
18 views
Error message with Oracle odbc while opening connection to database
I have a method below. I am using odbc to communicate with Oracle. I actually do not have problems with other methods while deleting data and using select statements.
I kept getting the error message ...
1
vote
1answer
19 views
ORA-00923: FROM keyword not found where expected, but it works in Oracle Toad
I'm using VS2010 and Oracle as my database in a x64 machine, but I'm having problems with my .NET code. Here it is:
It's just a function called from a webservice of a DataGrid Selecting function.
...
-2
votes
0answers
8 views
Pre-req to use oracle ADF [on hold]
I would like to know what I will need to know to use Oracle ADF. I would classify myself as an intermediate Java programmer with very good knowledge from data structures, objects, inheritance, ...
0
votes
0answers
9 views
Not reading the first line in the XML file using Ganymed SSH-2
enter code here
Session sess2 = conn.openSession();
sess2.execCommand("cd /export/apps/oracle/ && ls|cat "+file);
System.out.println("Reading file: "+file);
InputStream ...
1
vote
2answers
35 views
Optimizing aggregate function in Oracle
I have a query for pulling customer information, and I'm adding an max() function to find the most recent order date. Without the aggregate the query takes .23 seconds to run, but with it it takes ...
0
votes
1answer
19 views
create oracle procedure if table fails to compile send email otherwise something else
I want to send an email if the field in the table equals to FAIL.
So what I have so far:
CREATE OR REPLACE PROCEDURE DAILY_REFRESH
IS
BEGIN
FOR i IN (SELECT RESULT FROM SOURCE.REFRESH_LOG@DB_LINK)
...
0
votes
1answer
24 views
Unit Testing Oracle PL/SQL
What are the advantages / disadvantages of the various Unit Testing frameworks for Oracle PL/SQL? For example:
utPLSQL
PL/Unit
Pluto
SqlDeveloper Unit Testing
any other options?
This type of ...
