Alex Rivera | Logout

Questions tagged oracle-database

513 questions · page 7 of 11

Sort by: Newest Votes Active
9
votes
4
answers

How to Select only one unique record from the Table using Distinct

oracle-database distinct greatest-n-per-group
asked 2010-06-25T09:37:49.207
9
votes
3
answers

oracle raw datatype in where clause

sql oracle-database
asked 2010-06-23T12:01:22.173
16
votes
3
answers

Oracle: copy row while updating one field

sql oracle-database plsql insert
asked 2010-06-22T18:28:48.523
26
votes
3
answers

Hibernate sequence on oracle, @GeneratedValue(strategy = GenerationType.AUTO)

java oracle-database hibernate orm
asked 2010-06-18T10:01:52.090
23
votes
4
answers

Is there a way to give a subquery an alias in Oracle 11g SQL?

sql oracle-database subquery oracle11g table-alias
asked 2010-06-16T23:35:44.817
118
votes
11
answers

How to generate a GUID in Oracle?

oracle-database guid
asked 2010-06-14T13:13:54.440
12
votes
2
answers

Hibernate Schema Validation Fails on Oracle Table Synonyms

java oracle-database hibernate validation synonym
asked 2010-06-11T13:13:11.850
22
votes
3
answers

PL/SQL pre-compile and Code Quality checks in an automated build environment?

oracle-database plsql continuous-integration build-automation code-analysis
asked 2010-06-10T12:18:57.793
18
votes
3
answers

oracle call stored procedure inside select

sql oracle-database stored-procedures plsql insert
asked 2010-05-19T11:50:24.550
22
votes
1
answers

PreparedStatement and setTimestamp in oracle jdbc

java oracle-database jdbc timestamp prepared-statement
asked 2010-05-18T14:30:37.513
13
votes
4
answers

Oracle equaivalent of java System.currentTimeMillis()?

oracle-database time
asked 2010-05-13T06:07:18.087
12
votes
2
answers

Oracle data provider pegs IIS worker process when web site is stopped

asp.net oracle-database iis oracle11g
asked 2010-05-06T15:16:10.747
9
votes
2
answers

How to use Data Pump utilities without a tnsnames.ora file

oracle-database command-line tnsnames datapump
asked 2010-05-05T13:44:19.993
31
votes
6
answers

UTL_FILE.FOPEN() procedure not accepting path for directory?

oracle-database plsql oracle9i utl-file
asked 2010-05-01T18:37:22.873
9
votes
3
answers

How to test if a string is inside a list of predefined strings?

oracle-database plsql
asked 2010-04-30T03:47:54.313
17
votes
2
answers

Greatest not null column

sql oracle-database oracle9i
asked 2010-04-21T15:01:14.083
9
votes
7
answers

Oracle - Return shortest string value in a set of rows

sql oracle-database plsql
asked 2010-04-20T16:14:49.240
12
votes
3
answers

Convert byte array from Oracle RAW to System.Guid?

c# .net oracle-database ado.net guid
asked 2010-04-19T13:30:18.483
13
votes
2
answers

SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword

sql oracle-database subquery left-join ora-00905
asked 2010-04-02T20:02:36.570
17
votes
2
answers

Base 36 to Base 10 conversion using SQL only

sql oracle-database base36
asked 2010-04-02T19:17:07.403
19
votes
4
answers

Oracle doesn't remove cursors after closing result set

java oracle-database jdbc resultset database-cursor
asked 2010-04-01T12:43:27.293
15
votes
1
answers

alias all column in a query with a prefix

oracle-database select jdbc alias
asked 2010-03-23T15:13:12.597
15
votes
5
answers

How to force oracle to use index range scan?

oracle-database indexing
asked 2010-03-18T21:58:48.703
15
votes
8
answers

SELECT SUM returns a row when there are no records

sql oracle-database sum
asked 2010-03-13T02:07:48.837
19
votes
2
answers

How does contains() in PL-SQL work?

sql oracle-database oracle10g contains
asked 2010-03-12T07:11:29.890
29
votes
9
answers

Oracle's lack of a Bit datatype for table columns

oracle-database boolean
asked 2010-03-11T15:22:09.293
13
votes
2
answers

How to key in and display date with hours and minutes into Oracle SQL Developer?

oracle-database date oracle-sqldeveloper
asked 2010-03-09T18:15:06.337
58
votes
7
answers

Select from table by knowing only date without time (ORACLE)

sql oracle-database date
asked 2010-03-08T06:56:11.007
9
votes
4
answers

Does anyone use the PL/SQL Web Toolkit?

oracle-database plsql
asked 2010-03-04T20:31:59.987
99
votes
1
answers

dbms_lob.getlength() vs. length() to find blob size in oracle

sql oracle-database blob
asked 2010-03-03T16:44:49.150
17
votes
2
answers

Finding ghost constraint from Oracle DB

sql oracle-database unique-constraint ora-00001
asked 2010-03-03T14:44:15.383
78
votes
11
answers

How do I get column datatype in Oracle with PL-SQL with low privileges?

oracle-database plsql ddl privileges
asked 2010-02-26T02:04:59.223
15
votes
1
answers

Oracle number and varchar join

performance oracle-database join to-char ora-01722
asked 2010-02-24T23:19:25.893
11
votes
4
answers

java.util.Timestamp.after() wrong when comparing milliseconds?

java oracle-database time
asked 2010-02-23T20:12:49.153
13
votes
4
answers

Executing a dynamic sql statement into a SYS_REFCURSOR

sql oracle-database plsql
asked 2010-02-09T16:01:38.323
20
votes
6
answers

How to find locked rows in Oracle

oracle-database locking
asked 2010-02-02T19:09:40.040
17
votes
3
answers

Spring's Stored Procedure - results coming back from procedure always empty

java oracle-database stored-procedures jdbc spring-jdbc
asked 2010-01-28T12:17:53.197
27
votes
5
answers

In which cases will Oracle create indexes automatically?

database oracle-database indexing
asked 2010-01-28T11:27:58.850
10
votes
7
answers

How to resolve ORA-00937: not a single-group group function when calculating percentage?

sql oracle-database ora-00937
asked 2010-01-27T21:48:34.617
9
votes
3
answers

What makes Oracle more scalable?

oracle-database scalability rdbms
asked 2010-01-24T13:29:00.950
12
votes
3
answers

Table-Valued Functions in ORACLE 11g ? ( parameterized views )

oracle-database view oracle11g parameterized user-defined-functions
asked 2010-01-13T18:45:21.180
12
votes
2
answers

Using an Oracle Table Type in IN-clause - compile fails

oracle-database plsql associative-array database-cursor
asked 2010-01-11T22:57:33.000
30
votes
4
answers

Automatically populate date in oracle table

oracle-database time timestamp
asked 2010-01-09T10:36:10.017
10
votes
3
answers

Value from last inserted row in DB

java database oracle-database jdbc
asked 2009-12-29T19:57:31.047
24
votes
4
answers

Where can I find a complete list of predefined Oracle pl/SQL Exceptions?

sql oracle-database ora-00001
asked 2009-12-29T12:12:50.570
10
votes
7
answers

Oracle connection compression?

java oracle-database jdbc compression
asked 2009-12-23T17:44:16.770
151
votes
4
answers

Search an Oracle database for tables with specific column names?

sql oracle-database
asked 2009-12-23T14:54:43.077
9
votes
3
answers

Oracle PLSQL - Declare a cursor on a non-existing table

oracle-database plsql database-cursor ora-00942
asked 2009-12-21T19:26:12.507
23
votes
4
answers

SQL Inner join on select statements

sql oracle-database ora-00933
asked 2009-12-21T14:59:26.123
12
votes
1
answers

Unit testing with Oracle

oracle-database unit-testing plsql
asked 2009-12-16T21:31:30.517
← Prev page 7 of 11 Next →