oracle11g Questions
6
Solved
Is there a Hibernate dialect for Oracle Database 11g? Or should I use the org.hibernate.dialect.Oracle10gDialect that ships with Hibernate?
12
Solved
Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?
Problem
Please note that I changed details for security purposes. However, the problem remains intact.
I installed an Oracle 11g database on a server at location, say, herp-devDV.derp.edu.
Now ...
Devisable asked 9/6, 2014 at 19:48
9
Solved
I am trying to install Oracle 11G R2 in windows 64-bit. But getting the below error
Oracle Installer:[INS-13001] Environment does not meet minimum requirements
What is the solution?
Epithelium asked 10/3, 2016 at 2:59
6
Solved
How to add an offset in a "select" query in Oracle 11g.
I only know how to add the limit by e.g rownum <= 5
this question is not a duplicate, I already checked the other questions and are not re...
Glenda asked 24/11, 2014 at 6:58
2
Solved
I have a sql script that I must run after I import a dump. among other things the script does, it does the following:
BEGIN
--remove program
SYS.DBMS_SCHEDULER.DROP_PROGRAM(program_name=>'STA...
Bruns asked 24/11, 2013 at 18:12
9
Solved
I want to get the last row, which I inserted into a table in an Oracle 11g Express database.
How can I do this?
15
I have an application that I can't get connected to my Oracle Database 11g Express Edition. I created a test database in this edition, and I can connect to the database fine using Oracle SQL Develo...
22
Solved
I am getting this error while on of my .Net application are trying to make a connection to oracle database.
The error says that This problem will occur when running in 64 bit mode with the 32 bit ...
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...
1
It came to my attention that Oracle EXTRACT(XML) function is deprecated in Oracle 11g.
I used to make my XML processing by following approach:
DECLARE
TYPE xmltype_table IS TABLE OF xmltype INDE...
Aardwolf asked 5/1, 2016 at 13:9
4
Solved
I always get confused with date format in ORACLE SQL query and spend minutes together to google, Can someone explain me the simplest way to tackle when we have different format of date in database ...
1
I used an Oracle 11g EE to create my database and access it through PHP using PDO, and all was working good. But i had to change to 11g XE because i wanted to use it freely inside my company. Now, ...
Condescend asked 5/3, 2013 at 12:37
17
Solved
When I try to query objects, I end up with following error:
ORA-01461: can bind a LONG value only for insert into a LONG column
Could someone please help me on the cause and solution of the prob...
2
Solved
Introduction
I'm facing a very strange behaviour on my Oracle SQL Server (exactly: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production) when using the Oracle Advanced Queu...
Airtoair asked 14/1, 2016 at 10:59
3
Solved
I have a simple php script:
<?php
$DB = '//10.11.201.170:1521/XE';
$DB_USER = 'BIOTPL';
$DB_PASS = 'biotpl';
$DB_CHAR = 'AL32UTF8';
$conn = oci_connect($DB_USER, $DB_PASS, $DB, $DB_CHAR...
Schist asked 28/11, 2016 at 11:33
6
Solved
As an FYI, I'm new to this entire stack, so I might be making a basic error.
I'm attempting to explore BIRT reporting for a Maximo system that was recently upgraded.
To do so, I installed the fol...
4
This is what it is showing. No output even after running the code block
SQL> DECLARE
2 message varchar2(20):= 'Hello, World!';
3 BEGIN
4 dbms_output.put_line(message);
5 END;
6 /
PL/SQL...
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...
7
From within an Oracle 11g database, using SQL, I need to remove the following sequence of special characters from a string, i.e.
~!@#$%^&*()_+=\{}[]:”;’<,>./?
If any of these character...
4
Solved
I want to get the number of sessions in Oracle using the SQL query:
SELECT value FROM v$parameter WHERE name = 'sessions'
But I get this error:
Error starting at line 1 in command:
SELECT value...
2
Solved
I want to know the Query that allows us to view all the columns that are defined for a table in oracle database.
Elaboration:
Table Name: Some_Table have 10 columns.
I want to know how I can ret...
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
6
Solved
I need to get employees with smallest salary in their departments
I did it using anti join.
select emp.employee_id,emp.last_name,emp.salary,emp.department_id
from employees emp
left join employ...
7
Solved
iam really new in oracle and databases at all.
So sorry for a maybe stupid question.
Here is my problem. I have a DB export (not mine so i dont know how it was exported: are there differences?) an...
5
Solved
I am using Oracle 11g for my web application. I want to add a column and a comment to an existing table. I can do that easily with the below commands
ALTER TABLE product ADD product_description VA...
© 2022 - 2025 — McMap. All rights reserved.