oracle Questions
5
Solved
I'm generating a scientific application that performs a lot of number crunching in Java and C, and accuracy is critical. There is no number crunching done inside the Oracle database (it's merely us...
8
Solved
I'm getting this error if i try to login as db user. If lsnrctl status is run i get the below error. DB was working fine all these years and stopped working suddenly.
Connecting to (DESCRIPTION=(A...
Foozle asked 19/5, 2014 at 17:39
7
Solved
I need some pointers on how to diagnose and fix this problem. I don't know if this is a simple server setup problem or an application design problem (or both).
Once or twice every few months this ...
Fayum asked 15/6, 2009 at 1:7
6
Solved
How do I check if a particular element exists in a table - how can I return true or false?
I have a table that has
user_id
user_password
user_secretQ
Verbally, I want to do this: If a particu...
Garlicky asked 4/11, 2010 at 16:22
4
Solved
What is the equivalent of:
TRUNC(SYSDATE)
...in SQL Server 2005?
Calfskin asked 11/11, 2009 at 5:0
7
I am currently migrating a SpringBoot 2.7 application to SpringBoot 3. The following query is used within a SpringData repository:
@Query("select b from #{#entityName} b where (trunc(b.date) ...
Uninterested asked 10/12, 2022 at 13:36
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
Solved
I have the following unique constraint
dup_Checklist_QNum UNIQUE (QUESTION_NO, IS_ACTIVE)
I am trying to prevent two questions having the same question number while being active (IS_ACTIVE value...
Propaedeutic asked 4/7, 2012 at 22:9
5
Solved
Here is:
declare
v_str1 varchar2(80);
begin
v_str1 := 'test';
print :v_str1;
end
When I run it using SQLDeveloper just in a sql worksheet I get this:
Bind Variable "v_str1" is NOT DECLARED
a...
5
Solved
I have data in following format.
match_id team_id won_ind
----------------------------
37 Team1 N
67 Team1 Y
98 Team1 N
109 Team1 N
158 Team1 Y
162 Team1 Y
177 Team1 Y
188 Team1 Y
198 Team1 N
207 ...
Dahna asked 24/7, 2013 at 15:52
6
Solved
How would I be able to get N results for several groups in
an oracle query.
For example, given the following table:
|--------+------------+------------|
| emp_id | name | occupation |
|--------+-...
Admonition asked 25/9, 2008 at 18:9
7
When I'm querying a table in schema C from schema A, I'm getting ORA-01031: insufficient privileges and when I'm querying the same table from schema B, I'm getting ORA-00942: table or view does not...
Trelliswork asked 8/1, 2014 at 6:34
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...
2
Solved
I have a large table with phone numbers. The phone numbers are all strings and supposed to be '+9628789878' or similar. (a "+" sign followed by between 9 and 13 digits.)
A user bug uncovered one r...
9
Solved
I have a simple test program that when I run I get:
./hello: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
I link it like this:
$(...
Panpsychist asked 16/5, 2012 at 13:11
5
Solved
I'm trying to do an insert with a potentially large amount of binary data into a remote Oracle (11g) database using Entity Framework (ODP.Net). It works fine for really small files (<5 KB), but ...
3
Solved
According to google and some other sources (e.g., http://www.enterprisedt.com/publications/oracle/result_set.html), if I want to call a stored-function that returns a ref cursor, I need to write so...
11
Solved
OS: Windows 2008 Server R2
Oracle Client: 11.2
Many Thanks
Passade asked 2/11, 2012 at 2:57
7
Solved
I am not deeply acquainted with Oracle Sql Queries, therefore I face a problem on deleting some rows from a table which must fulfill a constraint which includes fields of another (joining) table. I...
Vast asked 1/10, 2012 at 11:6
9
Solved
I am working now with oracle and spring jdbc but I don't want to use the schema in my sql statements:
Example: Select * from SCHEMA.table
Is there any way to set default schema in application.pr...
Benumb asked 22/6, 2016 at 16:17
4
Solved
3
Solved
What would be better if need to migrate from Oracle Forms 10g , Either Apex or ADF
If Apex then Why and Why not ADF
If Adf then Why and Why not Apex
Whelm asked 25/4, 2019 at 18:1
15
Solved
I see an error while executing hibernate sql query.
java.sql.SQLException: ORA-00904: "table_name"."column_name": invalid identifier
When I open up the table in sqldeveloper, the column is pre...
4
A column in a table has a default value of sysdate and I want to change it so it gets no default value, how do I do this?
11
I am getting this exception with SERIALIZED isolation level on JobRepository in Spring Batch:
org.springframework.dao.CannotSerializeTransactionException: PreparedStatementCallback; SQL [INSERT in...
Hyperboloid asked 12/3, 2014 at 21:39
© 2022 - 2025 — McMap. All rights reserved.