oracle Questions
2
Solved
I have to use SQLPLUS for my database class, and our first assignment is simple saving.
I followed the instructions.. (I'm using PuTTY to access sqlplus)
"Use the following SQL commands in this e...
13
Solved
I have downloaded Oracle XE 18c for Windows 64 bit, and tried to install it on a Windows 10 machine. I checked the SHA-256 checksum and it's correct.
The installation starts fine, but when it's co...
4
I created a job which runs in my database successfully with DBMS_SCHEDULER ,but now I need to disable this job, how can i do this?
thanks!
Balsam asked 2/9, 2021 at 7:45
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
5
Solved
In a hypothetical scenario, I am an user with no table creation privileges. I want to know if a column in a table has UNIQUE CONSTRAINT. Is it possible to look it up in the DICTIONARY? How would I ...
8
Our C# application is generating ORA-01000 error. We were using ODP.Net and the application was running just perfect without any ORA-01000 error.
We removed the ODP.Net and installed the instant ...
7
Solved
Here's a simplified example of what I'm talking about:
Table: students exam_results
_____________ ____________________________________
| id | name | | id | student_id | score | date |
|----+------...
Romanticist asked 7/12, 2009 at 23:22
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
I have a table which contains a primary key column which is auto incremented from application. How can I modify the column to be an identity column in Oracle 12c?
A sample case is provided below-
...
4
Solved
I am using an internal maven/artifactory repository on my network.
I am trying to intialize an Oracle Connection with DBeaver 7.1.0. (not the eclipse plugin, the standalone program)
Each time it in...
15
I am trying to use ALTER USER query for Oracle database using OracleCommand in C# in the following code. It creates the query if the values for Username and password are not empty strings. But I ge...
4
Solved
As is known, there are two locking strategy: Optimistic vs. Pessimistic locking
Pessimistic Locking is when you lock the record for your exclusive use
until you have finished with it. It has mu...
Wager asked 14/8, 2016 at 21:32
13
Solved
I have downloaded a fresh copy of sqldeveloper (sqldeveloper-4.1.3.20.78-no-jre) from the Oracle website. When I unzip it and lauch the GUI, I keep getting the following error message:
Warning ...
Rickrack asked 22/4, 2016 at 10:6
6
Solved
I have a varchar2 column named NAME_USER. for example the data is: JUAN ROMÄN but I try to show JUAN ROMAN, replace Á to A in my statement results. How Can I do that?. Thanks in advance.
6
Solved
I have an application that uses JMS op top of Oracle advanced queuing. I would like to do a query on the queue table that shows the content of the message (which in my case is XML). So when I do a ...
Stavropol asked 19/6, 2009 at 21:44
14
Solved
We are using Oracle as the database for our Web application. The application runs well most of the time, but we get this "No more data to read from socket" error.
Caused by: java.sql.SQLRecoverabl...
2
Solved
While I was working with a table containing a BLOB column:
SELECT id FROM table WHERE blob_column LIKE '%something%';
...I got the following error:
ORA-22835: Buffer too small for CLOB to CHAR or...
11
I want to upload some data from UAT DB to DEV DB. When I try to do this from Export function in SQL Developer, I got an error File C:\Users\xxx\export.sql was not opened because it exceeds the maxi...
Exacting asked 7/5, 2015 at 3:48
9
I am trying to run openrowset from MS SQL Server on an Oracle server.
When i execute the following command:
select * from
OPENROWSET('OraOLEDB.Oracle','srv';'user';'pass',
'select * from table')...
Mckibben asked 24/1, 2013 at 11:14
3
Solved
3
Solved
I have a little problem with a column on a table.
The column is a Varchar named "prize".
The datas are something like:
00008599
00004565
00001600
etc...
They have to become:
85.99
45.65
16.00
e...
3
Solved
Suppose there is a table called DISTANCES in Oracle with a float type column named distance. The range of distance is from [0, 1000]. I want to know the distribution of the distances, for example, ...
12
Solved
One of my django application unit test fails with
DatabaseError: ORA-00942: table or view does not exist
I would like to see actual SQL query that caused this error. Do you know how to achieve t...
Rosaliarosalie asked 31/10, 2012 at 16:42
5
Solved
I recently discovered a difference between Oracle adds months to a given date (using ADD_MONTHS function) and the way Java adds months to a Calendar object.
For instance in oracle:
select add_mo...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.