Alex Rivera | Logout

Questions tagged oracle-database

513 questions · page 4 of 11

Sort by: Newest Votes Active
80
votes
15
answers

No more data to read from socket error

oracle-database hibernate spring jdbc
asked 2011-10-20T17:38:45.440
13
votes
3
answers

Oracle: Using a database link in a stored procedure : table or view does not exist

sql database oracle-database stored-procedures dblink
asked 2011-10-20T17:05:40.043
38
votes
7
answers

Does ODP.NET require Oracle Client installation

.net oracle-database odp.net oracleclient
asked 2011-10-19T10:26:22.820
9
votes
3
answers

No Oracle DataSource in Entity Data Model Wizard

.net oracle-database entity-framework orm odp.net
asked 2011-10-19T09:09:35.463
32
votes
4
answers

Pivoting rows into columns dynamically in Oracle

sql oracle-database oracle10g pivot
asked 2011-10-11T17:36:42.257
9
votes
4
answers

Remove all characters after a specific character in PL/SQL

sql oracle-database plsql oracle9i substr
asked 2011-10-10T19:22:50.967
12
votes
2
answers

how to select the most frequently appearing values?

sql oracle-database
asked 2011-10-09T19:20:44.443
26
votes
2
answers

what does the "2"mean in SQL*Plus?

oracle-database oracle10g oracle11g sqlplus
asked 2011-10-09T01:27:21.020
54
votes
13
answers

Find out free space on tablespace

oracle-database tablespace
asked 2011-10-06T08:56:49.653
11
votes
1
answers

What is correct JDBC URL syntax if Oracle wallets are used?

oracle-database jdbc
asked 2011-10-03T11:08:51.920
21
votes
4
answers

Why is there a SELECT 1 from table?

sql oracle-database
asked 2011-10-03T09:17:19.730
10
votes
2
answers

Oracle 11g - Check constraint with RegEx

sql regex oracle-database oracle11g check-constraints
asked 2011-10-01T16:38:18.310
12
votes
3
answers

Column headings keep appearing throughout Oracle output

oracle-database sqlplus
asked 2011-10-01T00:47:51.460
36
votes
16
answers

How to change the date format from MM/DD/YYYY to YYYY-MM-DD in PL/SQL?

sql oracle-database datetime
asked 2011-09-30T06:35:30.513
10
votes
3
answers

SQL ORACLE ORA-00969: missing ON keyword?

sql oracle-database
asked 2011-09-28T01:44:55.927
474
votes
11
answers

Can a foreign key be NULL and/or duplicate?

sql sql-server oracle-database foreign-keys
asked 2011-09-27T17:57:45.437
18
votes
3
answers

Unique constraint violation during insert: why? (Oracle)

oracle-database unique-constraint
asked 2011-09-27T14:57:16.680
13
votes
2
answers

Oracle database is hanging infinitly in UPDATE queries

sql oracle-database transactions oracle11g
asked 2011-09-21T14:43:58.780
12
votes
6
answers

How to get the employees with their managers

sql oracle-database sqlplus
asked 2011-09-17T01:02:11.963
9
votes
9
answers

"data manipulation operation not legal on this view" happening in a user table

oracle-database
asked 2011-09-16T12:53:30.917
12
votes
5
answers

How to compare two DATE values based only on date part in Oracle?

sql oracle-database date compare datepart
asked 2011-09-15T15:25:22.597
55
votes
5
answers

Reason why oracle is case sensitive?

oracle-database database-design case-sensitive
asked 2011-09-15T02:18:26.580
11
votes
5
answers

Oracle 10g small Blob or Clob not being stored inline?

performance oracle-database blob inline clob
asked 2011-09-09T12:36:30.997
11
votes
4
answers

Oracle: Full text search with condition

sql oracle-database indexing full-text-indexing oracle-text
asked 2011-09-09T06:54:49.757
20
votes
3
answers

Get the name of the calling procedure or function in Oracle PL/SQL

oracle-database function plsql procedure
asked 2011-09-01T17:18:37.603
12
votes
2
answers

where to define default value in oracle package

sql oracle-database plsql messagebroker
asked 2011-08-31T16:58:31.887
16
votes
4
answers

Oracle SQL PLS-00049: bad bind variable

sql oracle-database
asked 2011-08-30T14:21:12.880
55
votes
9
answers

JDBC ResultSet get columns with table alias

java sql oracle-database jdbc resultset
asked 2011-08-28T21:21:39.693
11
votes
3
answers

What are the common mistakes pl/sql programmers make with money computation?

oracle-database plsql
asked 2011-08-26T02:09:24.437
10
votes
1
answers

Why does Oracle's varchar sort order not match the behavior of varchar comparison?

oracle-database sorting compare
asked 2011-08-25T12:56:06.820
12
votes
2
answers

dbms_scheduler.run_job('jobName) fails to run

oracle-database stored-procedures plsql dbms-scheduler
asked 2011-08-25T10:13:48.947
11
votes
4
answers

How to connect an Oracle Database to Mathematica?

sql database oracle-database connection wolfram-mathematica
asked 2011-08-24T16:04:41.130
17
votes
3
answers

how to print out the definition of a procedure in Oracle?

sql oracle-database plsql
asked 2011-08-23T20:45:10.620
34
votes
6
answers

Oracle Date TO_CHAR('Month DD, YYYY') has extra spaces in it

sql oracle-database oracle10g
asked 2011-08-23T19:27:38.540
15
votes
7
answers

oracle systimestamp (sysdate) to milliseconds

database oracle-database stored-procedures
asked 2011-08-22T13:11:19.107
337
votes
8
answers

Update a table with data from another table

sql oracle-database sql-update
asked 2011-08-11T18:05:54.983
16
votes
3
answers

Create index on existing table Oracle

oracle-database indexing
asked 2011-08-10T10:19:39.037
9
votes
2
answers

What is a good size (# of rows) to partition a table to really benefit?

sql oracle-database partitioning database-partitioning
asked 2011-07-30T20:56:23.437
14
votes
2
answers

Difference between SELECT DISTINCT and SELECT UNIQUE

oracle-database
asked 2011-07-21T07:06:13.133
19
votes
1
answers

Oracle -- WITH CLAUSE => MERGE? (Syntax error, )

oracle-database merge with-statement ora-00928 subquery-factoring
asked 2011-07-13T03:39:31.090
38
votes
5
answers

ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)

sql oracle-database oracle9i ora-00942
asked 2011-07-12T19:00:28.577
13
votes
2
answers

Non-negligible execution plan difference with Oracle when using jdbc Timestamp or Date

oracle-database jdbc timestamp sql-execution-plan
asked 2011-07-07T14:58:09.357
9
votes
1
answers

What's the created Date-time for Table row in Oracle?

database oracle-database timestamp
asked 2011-07-04T12:33:55.330
9
votes
5
answers

SQL: if cannot convert to_number set as null

sql oracle-database
asked 2011-06-24T16:27:11.947
82
votes
3
answers

How to import an Oracle database from dmp file and log file?

oracle-database oracle11g oracle-dump
asked 2011-06-24T05:05:15.027
23
votes
4
answers

SQLDeveloper displays no tables under connections where it says tables

oracle-database oracle-sqldeveloper
asked 2011-06-23T18:50:00.243
22
votes
4
answers

Compatible SQL to test for not null and not empty strings

sql sql-server oracle-database
asked 2011-06-23T16:48:34.217
10
votes
5
answers

display select results inside anonymous block

oracle-database plsql oracle10g oracle-sqldeveloper pls-00428
asked 2011-06-23T14:19:49.427
11
votes
2
answers

Is it a good idea to index a date column in descending order?

database oracle-database indexing
asked 2011-06-20T18:56:39.290
18
votes
2
answers

Fetch Oracle table type from stored procedure using JDBC

oracle-database stored-procedures jdbc resultset out-parameters
asked 2011-06-20T11:29:08.227
← Prev page 4 of 11 Next →