Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g and Oracle 12c. Generally there are two releases within each major version. Questions tagged [tag:oracle11g] are assumed to be specific to this version or features introduced in this version.
0
votes
0answers
3 views
Oracle 11g listener doesnt work with ip
I have a server with two NICs, Hyper-V and an Oracle 11g db (I know, on a Hyper-V host dont run other servives ...).
One NIC has the IP 192.168.100.1 and the other NIC I use for a vswitch in Hyper-V. ...
-1
votes
1answer
35 views
Concatenate two column data
I have below table.
Now In the above table ENO,ENAME,Edept are existing column. Now I want to calculate the FINAL COLUMN as above.
Please help me with the query to get the FINAL column result.
...
0
votes
0answers
5 views
What is the “other miscellaneous information” in the Shared Global Area (oracle database)? [migrated]
I'm studying Oracle database ,and it says here that the SGA contains these data structures :
Database buffer cache
Redo log buffer
Shared pool
Java pool
Large pool (optional)
Data dictionary cache
...
0
votes
1answer
10 views
How to interpret tkprof_table.ticks?
I googled on web trying to search the meaning of tkprof_table.ticks but I could not find anything.
Can someone help me understand what ticks column means?
The following ticks show a large value. It ...
0
votes
2answers
16 views
using Oracle.DataAccess.Client; not found after download and install OPD.NET
I have visual studio 2012 and Oracle 11g and want to connect oracle database using OPD.NET
.I downloaded the
ODAC112040Xcopy_32bit zip file and un zip the file and click the intall.bat and ...
0
votes
1answer
37 views
copy from one database to another using oracle sql developer - connection failed
I am trying to copy a table from one database to another using oracle sql developer. I have the username, password and SIDs.
copy from uname1/password1@SID1 to uname2/pwd2@SID2 insert table1 (*) ...
0
votes
0answers
12 views
How to circumvent “Read-only file system” error on Docker version 0.11 or greater when running sysctl -w during an image build?
I'm trying to build an oracle-xe Docker image to be used on acceptance tests. The build process is aborted after trying to install Oracle XE 11g using the following command inside my Dockerfile:
RUN ...
0
votes
1answer
6 views
plsql updatexml- can't update value based on attribute
I'm working with a database Oracle 11g, and it has some xml fields like:
<bookstore id="other">
<fractionOfbooks>1.0</fractionOfbooks>
</bookstore>
<bookstore ...
1
vote
0answers
14 views
Dbms_datadump fails with ORA-39117 for a table with user defined type
I have a table which has column of user defined type, I tried to move the table to a different schema,
It worked fine using command line mode, however when I tries to use DBMS_DATAPUMP, it fails with ...
-4
votes
1answer
36 views
Join on multiple tables where table column has mixed values
Hy guys! For the last few days I've been searching for s solution on the web and SO. It's my first question so please be patient :)
Before the explaining I would like to apologize if it is too ...
0
votes
1answer
19 views
What is the difference between MOD and REMAINDER in oracle?
Although both the functions perform the same operation, even they produce same o/p, what is basic difference between these two? Is there any performance related difference, if yes, then which one is ...
0
votes
0answers
8 views
Why calling Excel from Oracle Forms on the Citrix Receiver does not work?
I have used webutil feature to copy the data from Excel into my Oracle forms. It works fine when I run the forms on my local machine (from Oracle Forms Builder), and when I install it on the linux ...
0
votes
0answers
6 views
Error on Programmatically changing the SelectManyCheckbox List in Oracle ADF
I have a SelectManyChecbox on my jsff which is bound to a list in the managed bean.
Now my issues is that when i click on certain radio button, some of the check boxes should get removed, ie the list ...
0
votes
1answer
29 views
Condition based spool generation in Oracle SQL script
I have a scenario where we generate spool based on condition.
The spool should generate only if user types y.
column col noprint new_value elcm_script
select ...
0
votes
0answers
7 views
Unexpected token Error while creating view that uses pivot
I'm not able to create view in oracle through a select query that uses PIVOT function
It gives the following error.I'm not able to understand what's the problem.Please help
Refer to the image at the ...
0
votes
0answers
9 views
Drawing Oracle spatial geometries with sharp map
I need to create a simple app which can display geometries from Oracle Spatial in C#. These geometries are exported from shape file to Oracle Spatial.
I just need to pan,zoom the layers.
When i am ...
0
votes
0answers
32 views
Getting exception in JDBC thin driver
I try to run the query using the Java and below mentioned is my program
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import ...
0
votes
1answer
13 views
Table is mutating, trigger/function may not see it
I create a trigger to check COUNT.
create or replace
TRIGGER TEST_TRG before INSERT OR UPDATE ON TEST
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
AVAILABLE INTEGER;
BEGIN
IF UPDATING ...
-2
votes
1answer
38 views
Connecting tables and update table2 data by table3
I am using SQL.I have three tables as TABLE1 , TABLE2 and TABLE3. TABLE1 holds the daily deliveries of products and TABLE2 holds the advance payments of that delivery. The TABLE3 is an intermediate ...
0
votes
1answer
11 views
Handling exceptions in Oracle DB stored Java classes
When a stored Java class hits and unhandled exception, what is the best way to get the full stack trace back to PL/SQL for proper logging?
During preliminary tests of my class, I hit a NullPointer, ...
0
votes
0answers
6 views
XIRR calculation in mysql?
Could anyone please help me finding the accurate working mysql procedure/function which calculates XIRR() value for a given dates and cash flow values ?.
Typically table will be like this.
10/30/2010 ...
0
votes
3answers
36 views
Issue with Oracle regex
select regexp_substr('select count(distinct empno), count(distinct deptno) from emp',
'count\(distinct.*\)')
from dual;
For the above query I want output count(distinct ...
0
votes
0answers
8 views
Drop database link in oracle 11g
I have created one schema with the name of sapsmc which has all the privilages, then i have created 1 database link. Now i want to drop that database link,but i can not able to drop it getting this ...
0
votes
1answer
22 views
Unpivot date columns to a single column of a complex query in Oracle
Hi guys, I am stuck with a stubborn problem which I am unable to solve. Am trying to compile a report wherein all the dates coming from different tables would need to come into ...
0
votes
1answer
21 views
Generate the output in same spool in Oracle
SPOOL c:\out.SPL
SELECT * FROM a WHERE ACCOUNT_NUMBER='&CRN' ;
SELECT * FROM b WHERE ACCOUNT_NUMBER='&CRN' ;
Spool off
accept op prompt 'Do u want to generate el spool,type y ...
0
votes
2answers
29 views
Generate spool in based on condition in Oracle sql
I need to write an oracle sql script based on some condition.
Like User has to type 'y' or 'n' if he types 'y' then i need to
accept gen prompt 'Enter y if you want to generate spool' default 'n'
...
0
votes
0answers
29 views
Statement Closed: Next Oracle Migration 11g
I am migrating an application from Oracle 10g to Oracle 11g and i am having trouble on a method included on a "OSubjectsqlmapdao" (the application uses ibatis 2).
public List retrieveList(String ...
0
votes
0answers
20 views
Oracle Full-Text Index Error
I have a problem with Oracle Full-Text index. I have a user table and i want to create index on two columns of this table.
So I Used MULTI_COLUMN_DATASTORE
CTX_DDL.CREATE_PREFERENCE('Users_Multi', ...
1
vote
3answers
25 views
Create oracle table with auto commit on
Here is the scenario,
I am writing a procedure which performs DML(insert,delete) operations on multiple tables. In case of exception I need to rollback data from most of the tables except one.
...
0
votes
0answers
17 views
Roundoff Oracle Number Type
From UI, i m passing 99999999999999.99 to request/transformation layer. In transformation layer, i m converting it to Double and store it in valueobject.
Now in ValueObject, I have Double ...
0
votes
0answers
18 views
Backup oracle 11g XE user
I'm using Oracle 11g XE and I want to make a backup for the database that I'm working on it using RMAN,
the command "Backup Database" backing up the whole database, with all its users.
Is there a ...
0
votes
1answer
30 views
PLS-00103 error while creating package with overloading functions
Please help in finding the error while creating the package with overloading functions.
Error shown:
PL-00103: Encountered the symbol "NUMOU"when expecting one of the following: language.
...
0
votes
2answers
33 views
How to extract 10 consecutive digits from a alphanumeric string?
This will give me whether or not a text_field value consists of 10 consecutive digits. Now, what if I need to extract those digits in a new field. How would that work?
select text_field,
case when ...
0
votes
0answers
19 views
Modeling Multiple IF conditions in a single SQL query [on hold]
I have a simple query as follows
Select e.ID
Case
WHEN e.postlevel <> 'abc' then
'No post level'
WHEN d.isActive <> 'A' then
'Not active'
WHEN ...
0
votes
1answer
24 views
SQL query to get a list of date ranges by month between two dates
I have a table which has a column that contains dates in 'dd.mm.yyyy' format.
For example:
_______________________
cnt_id | cnt_date |
-----------------------
1 | '15.01.2014' |
2 | ...
0
votes
1answer
18 views
Delete on cascade for oracle 11g
Is there any ways to perform delete on cascade without locking all the child tables.Also the delete is performed on the key which is not the foreign key in the child tables .The foreign key in the ...
0
votes
1answer
14 views
How to update column with numbers for multiple sets of rows?
I have a table that has more than 500.000 rows. Here's what i need - For every 1000 rows i need to update a column value to a sequential numbers starting from 1. For instance the table below:
ID ...
0
votes
1answer
15 views
Alterations in views
Following is the code for sample table I have created:
SQL> create table a (a1 number(2), a2 number(2) not null);
Table created.
Now suppose I create a view on this table as:
SQL> create ...
0
votes
1answer
24 views
Varchar to decimal oracle 11g
how to convert varchar to decimal without rounding off.Currently oracle is rounding it off to 5 decimal digits for eg if the varchar data is 1.00037388 then the result data after using the ...
0
votes
2answers
16 views
How to display certain values on one column via OBIEE?
I have a report using a dashboard, and I have one field which has all the countries. What I need to do is displaying just certain countries from this field not all of them.
I would highly appreciate ...
0
votes
2answers
20 views
Call Function within User-Defined Function in SQL
I want to include the following function inside of another user-defined function in Oracle.
DBMS_STATS.GATHER_TABLE_STATS(SCHEMA_IN,TABLE_IN)
SCHEMA_IN and TABLE_IN are arguments to the user-defined ...
0
votes
1answer
15 views
ORACLE SQL- Insert new variable to table
I have a stored proc I am trying to update a table with and am having trouble with how I would set a variable to different values dependent on the result of other column queries and joins.
Example:
...
0
votes
2answers
33 views
Oracle SqlDeveloper JDK path
I have recently installed sqldeveloper but i'm getting the below warning window when I try to launch it. This is causing the sqldeveloper to run very very slow and it hangs frequently
I have tried ...
-1
votes
5answers
43 views
How can I select id which have 'Red' and at the same time 'Black'?
I want to write a simple pl/sql or mssql
For selecting the car id which is red and at the same time black.
sample:
ID | Color
1 | Red
1 | Black
2 | Brown
2 | Red
3 | Black
3 | Yellow
...
0
votes
1answer
15 views
Getting error as “ORA-32044: cycle detected while executing recursive WITH query”
I am getting error as "ORA-32044: cycle detected while executing recursive WITH query"
while executing the following query in Oracle.
WITH EmpsCTE (affiliation_id, from_customer_id,to_customer_id, ...
0
votes
1answer
22 views
Oracle PL/SQL Trigger: update/insert with where condition
Maybe it's quite easy but I don't get ahead. The table B contains two fields: product_no NUMBER and product VARCHAR2. What the trigger should do is to insert a corresponding product description from ...
0
votes
0answers
18 views
.trc file error log(table not found)
My application use oracle as a database in production. Seens few days it is creating lot of .TRC file.When I am checking for the log it was (Table Not Found). But all my transaction run ...
1
vote
2answers
26 views
Stored procedure for counting the row count of all the tables in database of a specific owner [duplicate]
I am creating a stored procedure in oracle to find the row count of all the tables. I have to run these procedure daily to find the daily data that is being loaded after ETL. I have created the below ...
0
votes
1answer
31 views
I am executing following procedure in oracle but get compilation error
Actually I want to get usernames from table using Stored Procedure
CREATE OR REPLACE PROCEDURE GetRecord
(
p_ID IN integer ,
p_user OUT VARCHAR2
...
0
votes
0answers
7 views
Sql plus on windows can't connect to linux 11g server
I installed 11g on Centos VM on my mac.I have everything up and working on server.I have included following command I ran on cenos.
$lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production ...
