Alex Rivera | Logout

Questions tagged oracle-database

513 questions · page 8 of 11

Sort by: Newest Votes Active
281
votes
3
answers

Oracle SQL Developer multiple table views

oracle-database oracle-sqldeveloper
asked 2009-12-16T03:47:45.907
13
votes
3
answers

How to send arbitrary parameters to Oracle trigger?

java oracle-database jdbc plsql
asked 2009-12-10T12:39:40.677
50
votes
6
answers

Force index use in Oracle

sql oracle-database indexing sqlplus
asked 2009-12-03T06:37:37.170
13
votes
6
answers

Displaying the constraints in a table

sql oracle-database constraints sqlplus
asked 2009-12-03T05:11:28.357
36
votes
6
answers

How to connect to remote Oracle DB with PL/SQL Developer?

database oracle-database plsqldeveloper authentication
asked 2009-12-02T13:28:54.960
16
votes
3
answers

Is there any logical reason of having different tablespace for indexes?

oracle-database indexing tablespace
asked 2009-11-30T12:25:56.530
39
votes
7
answers

How to get size in bytes of a CLOB column in Oracle?

sql oracle-database clob
asked 2009-11-25T14:17:53.113
11
votes
4
answers

Is it possible to partially refresh a materialized view in Oracle?

oracle-database data-warehouse partitioning materialized-views
asked 2009-11-23T14:07:02.440
14
votes
7
answers

Inserting new columns in the middle of a table?

sql database oracle-database
asked 2009-11-16T08:32:34.947
22
votes
8
answers

Oracle PL/SQL - tips for immediate output / console printing

oracle-database debugging plsql console-output unbuffered-output
asked 2009-11-13T14:59:22.280
12
votes
3
answers

What's the best way to perform data archiving on an Oracle database?

oracle-database archiving
asked 2009-11-11T20:44:09.457
9
votes
2
answers

Oracle same table name on different schema?

database oracle-database schema
asked 2009-11-06T06:22:01.380
17
votes
2
answers

Migrating Oracle DATE columns to TIMESTAMP with timezone

sql oracle-database date oracle10g timestamp
asked 2009-11-03T00:54:20.980
44
votes
4
answers

In Oracle, is it possible to INSERT or UPDATE a record through a view?

sql oracle-database plsql view
asked 2009-10-31T00:46:17.580
20
votes
5
answers

Is there any way to use a strftime-like function for dates before 1900 in Python?

python oracle-database datetime sql-loader strftime
asked 2009-10-29T14:03:24.820
12
votes
11
answers

Why use a JOIN clause versus a WHERE condition?

sql oracle-database
asked 2009-10-23T13:08:02.697
27
votes
4
answers

pl/sql stored procedure: parameter name same as column name

oracle-database stored-procedures plsql
asked 2009-10-22T15:07:40.323
21
votes
4
answers

Why is (a | b ) equivalent to a - (a & b) + b?

oracle-database binary computer-science theory proofs
asked 2009-10-21T23:43:40.883
15
votes
4
answers

Oracle SQLDeveloper Autocomplete in Lowercase (How about Uppercase)

oracle-database autocomplete uppercase oracle-sqldeveloper
asked 2009-10-21T08:55:13.677
12
votes
7
answers

Opposite of INTERSECT in Oracle

sql oracle-database
asked 2009-10-20T07:47:54.743
232
votes
13
answers

How to add 'ON DELETE CASCADE' in ALTER TABLE statement

sql oracle-database
asked 2009-10-15T10:44:59.010
50
votes
10
answers

Oracle - How to generate script from sql developer

oracle-database
asked 2009-10-14T05:13:19.350
12
votes
5
answers

How do I make my Java application identify itself to Oracle on connection?

java oracle-database properties connection
asked 2009-10-10T16:32:49.903
9
votes
3
answers

How do I map from Oracle UDTs with ODP.NET without using OracleObjectMappingAttribute?

c# .net oracle-database odp.net user-defined-types
asked 2009-10-01T16:28:24.497
10
votes
10
answers

Is it OK to nest database views?

sql oracle-database plsql view
asked 2009-09-29T20:27:53.050
9
votes
3
answers

Does Oracle roll back the transaction on an error?

sql oracle-database transactions plsql oracle10g
asked 2009-09-23T19:32:35.180
25
votes
13
answers

ORACLE SQL:Get all integers between two numbers

sql oracle-database numbers
asked 2009-09-21T10:04:45.367
63
votes
6
answers

Favorite SQL*Plus tips and tricks

sql oracle-database sqlplus
asked 2009-09-17T14:20:37.657
11
votes
6
answers

how to set a null value to a field in a table using oracle sql developer tool?

oracle-database null insert oracle-sqldeveloper
asked 2009-09-11T07:57:03.827
10
votes
5
answers

Convert MS SQL script to Mysql and Oracle

sql mysql sql-server oracle-database
asked 2009-09-07T14:53:45.330
13
votes
3
answers

LINQPad and Oracle

oracle-database linqpad
asked 2009-09-03T21:44:23.090
13
votes
2
answers

Script to run other scripts in sqldeveloper

oracle-database oracle-sqldeveloper
asked 2009-09-02T12:31:00.657
10
votes
2
answers

How to store selection result in to variable in Oracle procedure

oracle-database stored-procedures select-into
asked 2009-08-28T13:46:29.000
9
votes
2
answers

Is it possible to set a unique constraint as a foreign key in another table?

oracle-database foreign-keys constraints unique
asked 2009-08-24T01:26:32.640
13
votes
3
answers

Oracle get stored procedure last modified date

oracle-database
asked 2009-08-21T17:21:48.777
12
votes
4
answers

How to measure performance of query in oracle

sql oracle-database sqlperformance
asked 2009-08-21T15:29:33.170
17
votes
5
answers

Should an Oracle database have more than one tablespace for data storage?

oracle-database oracle10g tablespace
asked 2009-08-18T01:11:38.717
30
votes
2
answers

Insufficient privileges when adding FK constraint (Oracle)

oracle-database foreign-keys
asked 2009-08-11T20:44:08.080
16
votes
5
answers

The provider is not compatible with the version of Oracle client error when using Oracle.DataClient

visual-studio-2008 oracle-database odp.net
asked 2009-08-09T04:39:36.423
22
votes
4
answers

PL/SQL Logging - How to control?

oracle-database plsql oracle10g instrumentation
asked 2009-08-05T09:55:40.430
14
votes
3
answers

When does Oracle index null column values?

oracle-database indexing null
asked 2009-08-05T01:46:33.587
11
votes
5
answers

Getting Oracle's MD5 to match PHP's MD5

php oracle-database md5
asked 2009-08-04T16:56:11.827
13
votes
1
answers

How do I get SQL*Plus to create views / tables with a blank line in the middle of the create statement?

oracle-database sqlplus
asked 2009-08-04T14:14:18.300
27
votes
9
answers

Best way to shorten UTF8 string based on byte length

c# oracle-database utf-8 ora-12899
asked 2009-08-03T23:05:15.260
11
votes
8
answers

Oracle Gotchas for An Experienced Newb

php mysql sql-server oracle-database postgresql
asked 2009-07-30T20:10:26.760
10
votes
5
answers

How can I create a table as a select from another database in Oracle?

sql oracle-database
asked 2009-07-30T16:41:02.500
318
votes
6
answers

What is the difference between varchar and varchar2 in Oracle?

oracle-database sqldatatypes
asked 2009-07-23T11:40:25.993
57
votes
5
answers

How to get UTC value for SYSDATE on Oracle

oracle-database timezone utc
asked 2009-07-21T08:08:00.187
88
votes
12
answers

Webrick is very slow to respond. How to speed it up?

ruby-on-rails oracle-database sqlplus webrick
asked 2009-07-21T00:46:27.123
33
votes
5
answers

oracle varchar to number

oracle-database numbers varchar
asked 2009-07-20T16:40:17.027
← Prev page 8 of 11 Next →