Alex Rivera | Logout

Questions tagged oracle-database

513 questions · page 1 of 11

Sort by: Newest Votes Active
19
votes
5
answers

Finding the longest streak of wins

sql oracle-database oracle11gr2
asked 2013-07-24T15:52:12.697
11
votes
4
answers

Oracle Database import .sql file by command prompt

sql oracle-database oracle11g oracle10g oracle-sqldeveloper
asked 2013-07-18T12:14:10.593
16
votes
5
answers

MyBatis Insert List values

java oracle-database mybatis
asked 2013-07-10T06:02:13.203
54
votes
9
answers

Why would Oracle.ManagedDataAccess not work when Oracle.DataAccess does?

c# oracle-database tnsnames
asked 2013-07-03T18:56:18.520
40
votes
3
answers

How to give a unique constraint to a combination of columns in Oracle?

sql oracle-database constraints unique-constraint composite-key
asked 2013-06-27T12:43:08.430
11
votes
3
answers

Table function with bulk collection throws invalid datatype

oracle-database
asked 2013-06-10T21:26:16.553
9
votes
0
answers

A null was returned after calling the 'get_ProviderFactory' method on a store provider instance of type 'Oracle.DataAccess.Client.OracleConnection

c# oracle-database entity-framework connection-string
asked 2013-06-09T10:55:06.777
8
votes
3
answers

How to get all values in hierarchy linked to some value using Oracle CONNECT BY

oracle-database plsql connect-by
asked 2013-05-10T19:42:41.653
25
votes
3
answers

How to increase dbms_output buffer?

sql oracle-database plsql oracle10g dbms-output
asked 2013-05-10T06:39:37.057
17
votes
6
answers

Table is mutating, trigger/function may not see it (stopping an average grade from dropping below 2.5)

sql oracle-database triggers
asked 2013-04-24T01:51:34.640
13
votes
6
answers

ORA-01031 Insufficient privileges while CREATING a VIEW?

sql oracle-database view oracle11g
asked 2013-04-20T21:36:26.043
15
votes
4
answers

Why is the GETDATE() an invalid identifier

oracle-database function triggers
asked 2013-04-12T13:05:12.520
10
votes
4
answers

Determining query's progress (Oracle PL/SQL)

sql database oracle-database plsql monitoring
asked 2013-04-10T23:03:33.103
9
votes
3
answers

sql select with does not contain

sql oracle-database
asked 2013-04-09T08:11:50.243
9
votes
2
answers

PL/SQL FOR LOOP IMPLICIT CURSOR

oracle-database for-loop plsql database-cursor
asked 2013-04-06T18:51:03.313
20
votes
10
answers

Connection cannot be cast to oracle.jdbc.OracleConnection

java oracle-database hibernate jdbc jndi
asked 2013-03-18T17:42:49.273
11
votes
1
answers

Why cannot I create triggers on objects owned by SYS?

oracle-database plsql oracle11g database-trigger
asked 2013-03-13T04:54:27.670
24
votes
4
answers

Missing STOPKEY per partition in Oracle plan for paging by local index

sql oracle-database prepared-statement partitioning sql-execution-plan
asked 2013-03-12T09:32:26.120
8
votes
4
answers

Oracle Managed ODP.NET can't find tnsnames.ora

.net oracle-database odp.net managed
asked 2013-03-07T15:41:10.080
9
votes
2
answers

javax.xml.ws.WebServiceException: Provider com.sun.xml.internal.ws.spi.ProviderImpl not found

oracle-database java
asked 2013-03-03T09:52:04.543
50
votes
3
answers

Understanding Oracle's Java on Mac

java macos oracle-database
asked 2013-02-27T19:32:16.057
99
votes
9
answers

How to find the privileges and roles granted to a user in Oracle?

oracle-database security oracle10g user-accounts
asked 2013-02-25T11:55:51.007
66
votes
5
answers

Find out the history of SQL queries

oracle-database sql-update database-administration
asked 2013-02-12T10:55:41.237
14
votes
2
answers

How can I automatically convert MySQL DDL to Oracle DDL?

mysql sql oracle-database converters ddl
asked 2013-02-12T09:24:47.830
8
votes
4
answers

oracle improve query performance

sql performance oracle-database select
asked 2013-02-01T15:46:19.737
22
votes
4
answers

How to get row number from selected rows in Oracle

sql oracle-database rownum
asked 2013-01-28T07:58:37.813
12
votes
5
answers

Calling an Oracle PL/SQL procedure in Java using a CallableStatement with a boolean IN parameter gives an PLS-00306 oracle error:

java sql oracle-database jdbc plsql
asked 2013-01-28T01:27:29.057
23
votes
9
answers

"Cannot create an instance of OLE DB provider" error as Windows Authentication user

sql-server oracle-database oledb windows-authentication linked-server
asked 2013-01-24T11:14:12.573
8
votes
1
answers

get runtime execution plan of a query

oracle-database oracle11g
asked 2013-01-23T12:55:02.530
16
votes
4
answers

Find out the default value for a column (Oracle)

sql oracle-database select default
asked 2013-01-23T11:24:45.537
8
votes
2
answers

Oracle XE 11g homepage not displaying

oracle-database installation oracle11g listener
asked 2013-01-18T12:22:20.240
11
votes
2
answers

Using IF ELSE in Oracle

sql oracle-database toad
asked 2013-01-17T19:45:19.897
46
votes
1
answers

How can I execute a native SQL script in JPA/Hibernate?

sql oracle-database hibernate jpa
asked 2013-01-16T12:24:06.590
9
votes
2
answers

PostgreSQL equivalent of Oracle's PERCENTILE_CONT function

oracle-database function postgresql percentile
asked 2013-01-13T02:14:13.580
16
votes
3
answers

Slow performance on Hibernate + Java but fast when I use TOAD with the same native Oracle query

java oracle-database hibernate
asked 2013-01-12T15:22:21.460
20
votes
7
answers

Concatenate results from a SQL query in Oracle

sql oracle-database oracle10g concatenation
asked 2013-01-09T17:36:55.290
9
votes
4
answers

Oracle Client vs. Task-based Asynchronous Pattern (async/await)

c# .net oracle-database task-parallel-library async-await
asked 2013-01-03T10:04:25.870
10
votes
1
answers

Mysql vs Oracle XE vs Postgresql . Scalability and performance, which to chose?

mysql oracle-database postgresql database-performance
asked 2012-12-19T12:08:21.847
8
votes
3
answers

Unable to log-in using PL/SQL Developer

oracle-database plsqldeveloper
asked 2012-12-14T13:23:34.397
13
votes
2
answers

Calculate the percentage of the root owned by its parents

sql oracle-database hierarchy oracle11gr2 connect-by
asked 2012-12-10T18:25:39.677
14
votes
4
answers

Clear Screen in SQL*Plus

sql oracle-database sqlplus
asked 2012-12-01T17:23:13.563
9
votes
5
answers

how to find partition of record oracle

database oracle-database plsql oracle11g database-partitioning
asked 2012-12-01T13:35:20.010
9
votes
4
answers

Strange Oracle XMLType.getClobVal() result

oracle-database xmltype
asked 2012-11-23T18:35:51.980
18
votes
2
answers

Why is Oracle ignoring index with ORDER BY?

sql performance oracle-database database-performance sql-execution-plan
asked 2012-11-21T16:38:51.727
31
votes
2
answers

Oracle SQL - max() with NULL values

sql oracle-database null
asked 2012-11-16T13:49:38.087
52
votes
3
answers

Oracle: Changing VARCHAR2 column to CLOB

oracle-database database
asked 2012-11-15T17:01:05.873
108
votes
4
answers

Oracle client ORA-12541: TNS:no listener

oracle-database listener
asked 2012-11-13T09:58:33.550
8
votes
2
answers

XMLAGG with RTRIM issue

oracle-database xquery xmltable
asked 2012-11-08T23:39:54.500
26
votes
8
answers

How to create a DB link between two oracle instances

oracle-database dblink
asked 2012-11-07T09:54:28.093
12
votes
2
answers

How to return primary key from oracle merge query

oracle-database merge oracle10g sequence sql-returning
asked 2012-11-06T12:53:51.227
page 1 of 11 Next →