oracle10g Questions
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
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...
8
Solved
I am using Oracle Database and I am a bit confused about Drop and Purge Commands. In fact for me both does the same thing. Removes the table with schema from database. What is the main difference b...
3
Solved
In Oracle 10g, how do I add a unique case-insensitive constraint on two varchar fields? For example, given the following records already in the table:
"Stephen", "Swensen"
"John", "Smith"
The fo...
Pepper asked 15/10, 2010 at 18:5
10
Solved
I have made a desktop app Setup that connects with remote Oracle 10g Database. When I install Setup on remote machine and run my application then I get following error:
system.data.oracleclient re...
Prowl asked 14/10, 2013 at 5:32
3
Solved
I have a class representing a table on database that is defined:
public class MyClass{
public int MyClassId{get;set;}
public string Name{get;set;}
public string LastNamw{get;set;}
public Date...
Teteak asked 3/7, 2012 at 15:26
4
Solved
Is there any official method to use ORACLE Dark Mode?
Pitarys asked 22/11, 2021 at 5:53
9
Solved
When executing the following code, it just says the procedure is completed and doesn't print the infomation i want it to (firstName, lastName) and then the other values from the select query in a t...
Consueloconsuetude asked 3/5, 2012 at 15:24
5
Solved
In where clause for my query if I include condition in where clause such as
where
T2.Comments not like '%ABC%'
and T2.Comments not like '%xyz%'
it also filters out blanks/null comments.
I d...
3
Solved
I have a stored procedure which is being called from a dbms job. i.e.
DBMS_SCHEDULER.RUN_JOB ('Procedure_JB', FALSE);
A java code stored procedure, which after doing some stuff, kicks off Proce...
Grind asked 7/2, 2012 at 16:18
9
Solved
For some reason, people in the past have inserted data without using sequence.NEXTVAL. So when I go to use sequence.NEXTVAL in order to populate a table, I get a PK violation, since that number is ...
Fragonard asked 23/5, 2011 at 15:8
2
I created a view called "view_employee" like this:
CREATE VIEW view_employee AS
SELECT employee.surname || ', ' || employee.name AS comp_name, employee.sex, sections.name AS section_name, employee...
Translucent asked 22/11, 2017 at 18:38
5
Solved
I'm using Oracle 10g and want to delete approx 5 million records from Persons table (Having total 15 million records) which doesn't have any reference in Order table (Having total 5 million records...
Figwort asked 14/11, 2014 at 12:50
4
When i run the following query:
Select
tm.product_id,
listagg(tm.book_id || '(' || tm.score || ')',',')
within group (order by tm.product_id) as matches
from
tl_product_match tm
where
tm.bo...
14
Solved
I'd like to write a SELECT statement that uses just one test to return columns with no value (null, empty, or all spaces).
I thought this would work:
SELECT column_name from table_name WHERE colu...
11
Solved
I have a PL/SQL function with BOOLEAN in parameter:
function get_something(name in varchar2, ignore_notfound in boolean);
This function is a part of 3rd party tool, I cannot change this.
I woul...
9
Solved
I have a Java stored procedure which fetches record from the table using Resultset object and creates a CS Vfile.
BLOB retBLOB = BLOB.createTemporary(conn, true, BLOB.DURATION_SESSION);
retBLOB.op...
Purdum asked 8/12, 2010 at 15:10
2
Solved
I have an stored procedure that looks like this:
TYPE ref_cursor IS REF CURSOR;
TYPE parametro IS RECORD (
nombre VARCHAR2(50), -- I want to remove this value and make it the key of the table in...
4
Solved
I'm using Oracle XE 10g.
Please I beg you to read my question carefully. I have a weird use case for this but please bear with it.
Let's say I have the following records:
Table person
Name YearO...
10
Solved
I am facing this error given below :
ORA-28000: the account is locked
Is this a DB Issue ? Whenever I unlock the user account using the alter SQL query, that is ALTER USER username ACCOUNT UNLOC...
14
I have one table, gender, in which only two entries are there, 'male' and 'female' number of rows with these two entries only. Now I want to write a procedure which replaces these two values and th...
Cornela asked 31/7, 2013 at 11:20
4
Solved
I have been tasked with comparing two oracle schema with a large number of tables to find the structural differences in the schema. Up until know I have used the DB Diff tool in Oracle SQL Develope...
Cannikin asked 10/6, 2010 at 0:20
4
Solved
I´m trying a query in oracle 10g. It goes like this:
SELECT
*
FROM
h2h_reg reg,
h2h_cat_estatus est
WHERE
reg.FECH_APLICACION = SYSDATE
AND REG.ID_EST = EST.ID_ESTATUS
AND est.tipo_estatus =...
2
Solved
I'm using spark-sql-2.4.1v and ojdbc6.jar to read data from oracle.
Have oracle table as below
create table schema1.modal_vals(
FAMILY_ID NOT NULL NUMBER,
INSERTION_DATE NOT NULL DATE,
ITEM_VA...
Weakminded asked 7/5, 2019 at 10:2
9
Solved
This is my code for which I am getting error. My classes12.jar has been imported as an external jar.
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java...
Covenantee asked 24/3, 2013 at 12:59
1 Next >
© 2022 - 2024 — McMap. All rights reserved.