Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle11g** are assumed to be specific to this version or features introduced in this version.
0
votes
1answer
10 views
oracle : query output not formated
SQL> SELECT TR_NAME,TR_VALUE FROM TBL;
TR_NAME
----------------------------------------------------------------------------------------------------
TR_VALUE
...
0
votes
1answer
16 views
If I run my Query in Oracle it is running without any error but when I run it inside C# gives ORA-00911: invalid character
using (OracleConnection conn1 = new OracleConnection(oradb1))
{
conn1.Open();
using (OracleCommand crtCommand = new ...
0
votes
0answers
18 views
Getting SQL query execution statistic from Oracle database
I came from a background of MSSQL into the world of oracle (11g).
Back in MSSQL I used to be able to query the sys.dm_exec_query_stats and sys.dm_exec_text_query_plan table for the stats of the sql ...
0
votes
0answers
12 views
Audit on oracle schema for dml statements
I need to secure an oracle user for doing inserts/updates/deletes from outside programs written by me.
I googled a bit around to find what I need. I know you can use own written db triggers.
And I ...
0
votes
0answers
6 views
Unable to connect to Oracle 11g using node-oracle driver for Node.js: are they compatible?
We are trying to use node.js app to connect to Oracle 11g server (Enterprise Edition 11.2.0.1.0 - 64bit production) from an Ubuntu 12.04.1 LTS server. We are running Node v0.10.12 and the nearinfinity ...
0
votes
0answers
9 views
SQL Developer verify package change before compile
Sometimes we have two or three people changing the package at the same time.
I've been thinking if it's possible to configure SQL Developer for warn if the package has changed before compiling.
Is ...
0
votes
1answer
30 views
How to Convert the converted HTML tags back to the actual HTML Content
I'm converting the HTML tags to XML using "DBMS_XMLGEN.convert" funciton.
Ex:-
Original HTML Text:-
<p style="margin-bottom: 0pt;"><FONT color=#000080 size=2><FONT color=#000080 ...
0
votes
4answers
30 views
Function dont return decimal places
I have an Oracle function that performs calculations, but didn't return the decimal of the result.
CREATE OR REPLACE Function MY_TESTE
RETURN DECIMAL
IS
BEGIN
RETURN 1/3;
END;
If I ...
0
votes
0answers
28 views
How to connect mywebsite to Oracle cloud?
I am using this code for connect my website to oracle cloud database
$db = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOSTNAME)(PORT=1521))(CONNECT_DATA=(SID=DBNAME)))';
$db_charset = 'AL32UTF8';
$c ...
1
vote
5answers
58 views
Oracle 11g: LISTAGG ignores NULL values
I have some table TABLE1 with data:
+------------+
| COL1 |
+------------+
| FOO |
| BAR |
| (null) |
| EXP |
+------------+
( FIDDLE )
When I executing:
SELECT ...
0
votes
0answers
3 views
What are the differences between the Instance-Id, the ECID and the Dialog-ID in SOA Suite 11g?
What are the differences between the Instance-Id, the ECID and the Dialog-ID? (In the Enterprise Manager 11g WebGui you can search for instances with these criteria.)
1
vote
0answers
5 views
Calling an OSB-WebService from a BPEL Process with a Conversation ID
I'm having trouble with invoking an OSB-WebService from a SOA Suite 11g BPEL Process.
If I do not specify a Conversation ID, it works.
If I do specify a Conversation ID (I'm using the ECID), I get ...
0
votes
0answers
30 views
Convert elements into attributes in XML saved in Oracle table
I haven't been working with Oracle very long and have not had much exposure to Oracle XML manipulation.
Essentially, I need to convert nodes to properties for each row in a table using PL/SQL.
Each ...
1
vote
3answers
20 views
Order of exceution of trigger and statements in Oracle stored procedure
Below are my table structures :
Table -Customer
CustomerID Blacklisted Customer Name
101 Y ABC
102 Y DEF
Table -Blacklist
CustomerID BlacklistID Customer Name
101 1011 ABC
102 1012 DEF
Table ...
-1
votes
0answers
10 views
Error while creating new DB in Oracle 11G [on hold]
I am creating a new DB instance on Oracle 11G. While creating an instance, it shows error:
ORA-27102: out of memory
Please help me!
Thanks
0
votes
0answers
15 views
Connect Oracle Database from SSIS
I have a problem connecting to Oracle Database from SSIS.
I have successfully connected from Linked Server and I am able to pull the data from Oracle Database where I have used "Oracle Provider for ...
0
votes
1answer
35 views
Why do we have to do nesting of blocks in Oracle PL/SQL ?
I am new to Oracle PL/SQL.Being a procedural language why do we have to do nesting multiple times ?
Thanks in advance.
1
vote
0answers
19 views
Oracle java stored procedure performance
I am trying to create Java class in Oracle 11g drawing binary data passed as BLOB with awt graphics. The class loaded as a Java source
> create or replace and compile java source...
...
0
votes
2answers
15 views
equivalent to INSERT INTO TABLE SET in Oracle
I want to add data to table STATISTICS using INSERT statements.
I also want to move new counts to old counts and new date to old date as the new data comes in.
This is where it gets lil tricky ...
2
votes
2answers
54 views
Declarative approach to constrain data ranges in table
I would like to learn a declarative approach for a data constraint issue I have had from time to time related to exclusive date ranges.
Below is a simplified example. I have items and prices on those ...
0
votes
1answer
11 views
Run shell script within oracle procedure
I have a script /home/load_data.sh that I want to run from my procedure, only if my IF statement is not satisfied:
create or replace
PROCEDURE RD_ODS_REFRESH_LOG
IS
BEGIN
FOR i IN
(
...
1
vote
1answer
17 views
Updating table in Oracle
I have a table in Oracle call STATISTICS.
COLUMN NAME DATE TYPE
MODEL VARCHAR2(30 BYTE)
NEW_COUNT NUMBER
NEW_DATE DATE
OLD_COUNT NUMBER
...
0
votes
0answers
8 views
Insert a row in xml stored in local xmltype variable
I am trying to insert a row in xml stored in my xmltype variable, I cant able to point exact node based on attribute in node my xml. I want to add one record Field Name as "NPO",
but it is ...
0
votes
0answers
40 views
Strange characters in my Oracle Database 11G
I used Oracle 11G database, i have a LOG table
when i write in this table with this function:
Pk_Util.LOG_ERROR('Pk_Slt.IMPORT_LIAISON', 'LIAISON', NULL, liaison_code, NULL, SUBSTR(SQLERRM, 1, ...
0
votes
2answers
20 views
Months between sysdate to earlier date
I want to get the months between current date to earlier date.
SELECT MONTHS_BETWEEN(to_date(fld_valid_from,'yyyy-mm-dd hh24:mi:ss'),TO_DATE(sysdate, 'yyyy-mm-dd hh24:mi:ss')) num_months
FROM ...
0
votes
2answers
35 views
how to find oracle listener port in linux
I have Oracle 11.2.0 installed in my Linux system, on which we are running one tool(developed in java), which needs as an input the port number where the oracle listener is running.
Is there any way ...
-1
votes
2answers
35 views
looking for reducing time of a big sql request in oracle
I have two tables:
D with field d1 and field d2
and T with field s
the two fields are of type Varchar2(255)
select d2
FROM
D ,
(select s from T where (s = 'val_1') OR (s='val_2') OR .. OR ...
0
votes
2answers
24 views
Oracle updating table based on a join
I have two tables
table 1 : rm_example(customer, weekno, salenum, card_type,...., imputed)
table 2 : rm_dummy(customer, weekno, imputed)
The imputed column in table one is null(all columns).
I ...
0
votes
0answers
8 views
Oracle Load-On-Demand for Network Data Model Analysis Implementation in C# ASP.NET
Based on Oracle Documentations, Oracle is recommending the use of Load-On-Demand API for Network Data Model Analysis. I found samples for Java but my application uses C# and ASP.NET. I've been ...
0
votes
0answers
14 views
sqlldr “second enclosure string not present”
I am having some trouble loading my existing data into my new Oracle database.
Here is the control file:
options (errors=0, rows=2000, bindsize=20000000, readsize=20000000 )
load data
infile ...
0
votes
1answer
89 views
Is it safe to remove Path variable for Delphi Rad studio 10
I have to install Oracle Client. In order to do it I need to update a value of the path.
My current Path has a value for Delphi:
C:\Users\Public\Documents\RAD Studio\10.0\Bpl.
Do you think I can ...
0
votes
0answers
13 views
SSRS 2008 with VS 2012 Error ORA-12638
I have the system below:
Windows 7 64Bits
Visual Studio 2012 with Business Intelligence Template
Oracle XE 11g Win 32bit
Oracle SQL Developer 3.2.20
ODTwithODAC1120320_32bit for .Net
I tried to ...
1
vote
2answers
33 views
trying to group by generic_m_ai
Our current application allows to filter data by NLSSORT=generic_m_ai, I'd like to be able to group by it as well.
Currently testing it with a small table, but keeping the 'case' statement similar to ...
0
votes
1answer
23 views
Select single row per unique field value with SQL Developer
I have thousands of rows of data, a segment of which looks like:
+-------------+-----------+-------+
| Customer ID | Company | Sales |
+-------------+-----------+-------+
| 45678293 | ...
4
votes
1answer
64 views
Oracle PL/SQL code conventions [on hold]
I am curious, is there any offcial code guidlines or conventions for code formatting in Oracle PL/SQL?
0
votes
2answers
48 views
Retrieving the latest record from a Table (Oracle SQLPlus)
I've got this table:
Thread(ThreadID, ThreadType, PostDate, PostTime, Topic, Detail, UserID)
Primary key = ThreadID, Foreign Key = UserID
I want to retrieved the latest Post together with their post ...
0
votes
1answer
19 views
how do i do an incremental import into a 9i database
I need to carry out the append feature of the impdp utility while importing a 11g database dump into a 9i database. I also need to be able to do it the other way round for importing into a 11g ...
1
vote
2answers
57 views
Convert String to SQL Date
I have a String which contains date string eg 12-28-18 of format MM-dd-yy. I wish to pass this parameter to a stored procedure in Oracle database.
Hence, I am trying to convert this String to ...
1
vote
0answers
17 views
mount database oracle 11g [migrated]
I recently had the oracle 11g Express Crashed.
I have copied the .dbf files from C:\oraclexe\app\oracle\oradata\XE to other folder and reinstalled Oracle 11g Express edition.
The files are
...
0
votes
0answers
25 views
Sqldeveloper /as sysdba connection [migrated]
I'm a total newbie in Oracle.
I installed Oracle 11g XE R2.
Also I installed SqlDeveloper 3.2.20.09 version.
I generated auto connections, and I have 2 connections.
One is: /as sysdba
and ...
0
votes
2answers
51 views
Can Oracle DBMS return a Java object from a Java stored procedure call?
Can the Oracle database return a Java object from the return values of a Java stored procedure call?
I would like to query the Oracle database with a call to a java stored procedure and receive back ...
1
vote
2answers
35 views
how to create a view of multiple columns from one column structure in oracle sql?
suppose that i have a table named PROFILE and one column of it is names like below:
|NAMES|
-------
JAMES
-------
ANDY
-------
PETER
-------
SARAH
-------
JESSICA
-------
RACHEL
How could i make a ...
0
votes
0answers
7 views
Why added Data Connections in Server Explorer doesn't stay in Visual Studio 2012?
I added a connection to Oracle database under Server Explorer's Data Connections inside Visual Studio Premium 2012. But after I close the solution and re-open again, the added data connection is gone. ...
0
votes
0answers
14 views
running different services for same database on testserver
i have a test server named secdevfdsapp01.infibox.in with user pavankumar
i have the oracle database (FDSPRD) on the same server having the service AFS_PRD
I will connect for user pavankumar to the ...
0
votes
0answers
23 views
When is a database server overloaded? [closed]
Oracle keeps operating system statistics in the views V$OSSTAT and DBA_HIST_OSSTAT. One statistic is called LOAD, which is defined as
Current number of processes that are either running or in the ...
1
vote
2answers
38 views
Does columns order in multiple columns unique constraint make any difference? Is it justifiable to have duplicate indexes?
In "SQL Certified Expert Exam Guide" by Steve O'Hearn I've found this paragraph:
In the rare instance when you create a composite index along with multiple constraints that call on the same index, ...
0
votes
1answer
17 views
Oracle 11g: Convert RAW(8) to table of integer range 0..255
I have variable lr_temp and it is RAW(8) type. Making on it RawToHex(lr_temp) I receive string: BDAB59967DF11ECC (8 bytes presented in hex). My problem is to receive integer value for each byte:
...
0
votes
1answer
19 views
PORTING FROM DB2 TO ORACLE - ORA-00907: missing right parenthesis
I'm getting the error " ORA-00907: missing right parenthesis" at row: 7, column: 6
when I launch this query on ORACLE 11g DB:
SELECT B.ID_COND AS IDCOND,B.ID_PAYMENT AS IDPAYMENT, B.DT_SCAD AS ...
0
votes
2answers
16 views
execute batch with oracle prepared statement
I try to add batch prepared statement with following code:
Connection c = ...
PreparedStatement ps = c.prepareStatement(query1);
ps.setObject(....)
...
ps.addBatch(query2); // SqlException : ...
-1
votes
2answers
39 views
How to judge there are same number of rows in two tables
I want to know how to write a SQL statements to judge the number of rows in table A equals the number of rows in table B?
