oracle11g Questions
2
Solved
I have the name of an index that is existing on some table on some column in the db(oracle 11g). Knowing the name of the index, how can i find which table it belongs to?
3
Solved
It's that simple: a query that runs in just a few seconds in SQL Developer connecting to Oracle 11g takes 15-25 minutes in SSRS 2008 R2. I haven't tried other versions of SSRS. So far I'm doing all...
Serpentiform asked 25/1, 2011 at 1:3
3
Solved
I'm getting a ORA-01790: expression must have same datatype as corresponding expression error message. Below is the sql I'm using. Is the CASE statement causing this issue? I'm new to sql and this ...
1
I've got this query in a @SQLInsert annotation in Spring against an Oracle 11g database and, although it's inserting properly it is not updating the values but raising no error.
Any ideas? If not,...
Tichonn asked 29/1, 2019 at 10:37
3
Solved
14
I am new to Oracle, and am trying to run a simple example code with Java, but am getting this error when executing the code.. I am able to start up the listener via CMD and am also able to run SQL ...
5
I have a table 'MSATTRIBUTE' with 3000K rows. I used the following query to retrieve data, this query has different execution plan with same DB data but in different env. in one env, it appears ful...
Ocher asked 23/1, 2013 at 16:28
6
Solved
I have a table named CUSTOMER, with few columns. One of them is Customer_ID.
Initially Customer_ID column WILL NOT accept NULL values.
I've made some changes from code level, so that Customer_ID ...
Fetish asked 27/3, 2013 at 11:33
13
Solved
I need execute an SQL query in ORACLE it takes a certain amount of time.
So I wrote this function:
CREATE OR REPLACE FUNCTION MYSCHEMA.TEST_SLEEP
(
TIME_ IN NUMBER
)
RETURN INTEGER IS
BEGIN
DBM...
2
I am having an issue in my Oracle 11.2.0.4.0 environment that has me stumped. I have a WORKING, COMPILED view in existence, which I can select data from, but I cannot alter it without getting an "O...
8
Solved
I am referring to this stackoverflow answer:
How can I select from list of values in SQL Server
How could something similar be done in Oracle?
I've seen the other answers on this page that use UNIO...
11
Solved
I have refresh my application page and getting this error in console
Failed to load resource: net::ERR_CONNECTION_RESET.
I have tried to re-install the XAMPP version but this doesnt work for me.
...
21
Solved
I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Usern...
32
Solved
We have an application running locally where we're experiencing the following error:
ORA-12514: TNS:listener does not currently know of service requested
in connect descriptor
I've tested the...
5
Solved
I have a sample code where i'm trying to print Boolean value.
It resulted error.
wrong number or types of arguments in call to 'PUT_LINE'
wrong number or types of arguments in call to 'TO_CH...
12
I am using ORACLE database in a windows environment and running a JSP/servlet web application in tomcat. After I do some operations with the application it gives me the following error.
ORA-125...
3
Solved
I understand that Oracle supports multiple character sets, but how can determine if the current 11g system where I work has that functionality enabled?
4
Solved
all
I'm trying to connect to an Oracle 19C database. I have installed two Oracle Clients (11g and 12c) because we need to support legacy programs. I can connect with no issue with any user using sq...
Allieallied asked 18/11, 2020 at 23:56
5
Solved
I have Oracle 11 running on a Windows server and I'm logged onto the same server trying to use SQL Plus. When I try to connect I get a ORA-12154 even though TNSPING and various other diagnostics lo...
4
Solved
I need to write a query that selects a minimum value and it's second most minimum value from a list of integers.
Grabbing the smallest value is obvious:
select min(value) from table;
But the se...
Diacaustic asked 18/11, 2011 at 19:35
3
Solved
I make a query with INNER JOIN and the result was 12 millions lines.
I like to put this in a table.
I did some tests and when I created the table using clause AS SELECT was more faster than, create...
Fiorenza asked 19/7, 2018 at 22:9
3
I'm trying to use a "literal" multi-column table for a join query with Oracle 11g.
Here's the best I've come up with, based on this answer (
this answer suggests a much nicer syntax, but it only w...
2
Solved
I get keep getting this error I can't figure out what is wrong.
DECLARE
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 11
Here is m...
2
Solved
Is it possible to have 2 or more null values in unique constraint column?
16
Solved
I've installed Oracle 11g r2 to my machine and when I opened Oracle SQL Developer it says: java 1.6.0_02 is not supported and telling me to install new java version.
Then I've installed JDK 1.6.0...
Garber asked 12/9, 2011 at 9:6
1 Next >
© 2022 - 2025 — McMap. All rights reserved.