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
0answers
4 views
How to catch error in cursor declaration?
I have a need to write PL SQL that fetches data from another database over a DB link and perform some actions on it.
DECLARE
CURSOR cur_progs
IS
SELECT *
FROM ...
0
votes
2answers
23 views
How to find duplicate data
I am writing an sql query, where my goal is to find the duplicate values based on the column names:
SELECT a.PROJECTNAME
, a.OBJECTTYPE
, a.OBJECTID1
, a.OBJECTVALUE1
, a.OBJECTID2
, ...
0
votes
0answers
6 views
How to declare ConfigurationManager.ConnectionStrings?
hello i'm using visual studio 2008, vb.net and oracle as my db.
this is what i save in my apps.config
<appSettings/>
<add key="SMSDW_connection" value="server=abc;database=efg;User ...
0
votes
2answers
25 views
How with COUNT() and/or AVG() in my Select
I have a table that I want to run for a months worth of data based on my mopactivity.calldate field. I want to be able to get the average of the daily calls as daily count for each day of the month. ...
0
votes
1answer
22 views
Oracle - View function body from a package
I have a function inside of a package in Oracle and am wanting to view the implementation or the body of one of the functions.
I can find the package in the all_source view but cannot find the ...
0
votes
0answers
12 views
connecting a oracle database to a sql server database on different VM's
i need to connect a database adventureworks on a sql server database on a VM with ip address XXX.XX.XX.X port XXXX
to an oracle database ORCL with an ip address XXX.XX.XX.XXX port XXXX
i will need to ...
0
votes
0answers
8 views
Select a BLOB column from Oracle DB using mybatis
I'm trying to retrieve the contents of a BLOB column from an Oracle Database using mybatis. There is a table 'Demo' that contains a column 'binfile' of type BLOB. I would like to select the BLOB ...
1
vote
1answer
15 views
SQL Retrieving varray elements of a subobject in Oracle 11g Database
I am building a SQL query of a database where I am trying to retrieve an element of a VARRAY that is a subobject of several objects that is an element of another VARRAY. I can successfully query ...
-1
votes
1answer
24 views
ORA-00984: column not allowed here
I am doing a simple Oracle INSERT and I keep getting this error:
[Err] ORA-00984: column not allowed here
INSERT INTO MY.LOGFILE
(id,severity,category,logdate,appendername,message,extrainfo)
VALUES
(
...
0
votes
2answers
25 views
filter gridview based on dropdownlist selected value
Im trying to do a exercise filter GridView based on selected value in DropDownList.
I have a list of names in dropdownlist and when i click in the name i want that information of persons appears in ...
0
votes
0answers
8 views
CodeIgniter - ActiveRecords and Oracle - configuration
I had a problem with ActiveRecords - CI add brackets to the table names - so oracle returns errors.
Here is some info how to fix it :)
first configure your database
My old dns config looks like ...
0
votes
2answers
32 views
SQL - how to use joins instead of EXISTS and NOT EXISTS in an Idempotent insert example
I came across this github SQL code example for doing idempotent inserts. Works exactly how I want it. I don't want to use EXISTS though because I feel its a bit confusing. Can the same operation be ...
1
vote
2answers
32 views
What does &1.. mean in Oracle database
I saw this line in an oracle script
SELECT COUNT(*) INTO version1 FROM &1..xxdt WHERE version = 3310;
I don't understand the &1.. part. I think xxdt is the name of the table, so what is ...
0
votes
0answers
37 views
Access file from logical directory using java program
I m back with new question..it may be help full to others and me also
I have created a java application and the use of the application is to generate pdf according to user selection. but i have use ...
0
votes
1answer
26 views
CURSOR function equivalent in SQL Server
I would like to ask regarding a code equivalent in SQL Server
I'm working on a project wherein we will be converting unix batches to windows batches due to database migration. Since I'm on shell ...
