Questions tagged [oracle-database]

19

votes

4

answers

Database Upserts - Good or Bad Practice?

asked 2010-12-22T09:59:03.837

21

votes

6

answers

Using SQL query to determine if a table exists

sql oracle-database

asked 2010-12-08T08:10:16.033

11

votes

2

answers

Create/replace trigger in Squirrel

oracle-database squirrel-sql

asked 2010-12-02T09:05:01.243

15

votes

5

answers

Granting Rights on Stored Procedure to another user of Oracle

oracle-database stored-procedures sql-grant owner rights-management

asked 2010-11-29T15:43:33.933

39

votes

5

answers

Modify materialized view query

sql oracle-database

asked 2010-11-25T07:39:18.947

17

votes

5

answers

Why doesn't Oracle raise "ORA-00918: column ambiguously defined" for this query?

sql oracle-database oracle10g oracle11g ora-00918

asked 2010-11-24T16:39:57.710

22

votes

4

answers

Can I do an atomic MERGE in Oracle?

java oracle-database concurrency merge weblogic

asked 2010-11-19T16:05:00.193

11

votes

4

answers

Granting permission to users on different schema

oracle-database

asked 2010-11-18T22:09:01.197

10

votes

3

answers

How to do a like case-insensitive and accent insensitive in Oracle 10gR2 and JPA?

java oracle-database jpa

asked 2010-11-18T19:35:49.913

92

votes

12

answers

Materialized View vs. Tables: What are the advantages?

sql oracle-database materialized-views

asked 2010-11-18T19:21:22.243

10

votes

4

answers

oracle "table or view does not exist" from inside stored procedure

oracle-database stored-procedures

asked 2010-11-16T19:18:56.303

61

votes

13

answers

How to enter special characters like "&" in oracle database?

sql database oracle-database oracle-sqldeveloper

asked 2010-11-14T00:06:57.467

29

votes

1

answers

What does this Oracle SQL Developer icon mean on my stored procedure?

oracle-database stored-procedures oracle-sqldeveloper

asked 2010-11-12T21:48:01.587

270

votes

6

answers

How to export query result to csv in Oracle SQL Developer?

oracle-database csv export oracle-sqldeveloper

asked 2010-11-12T19:38:50.087

20

votes

4

answers

DBMS_JOB vs DBMS_SCHEDULER

oracle-database scheduler job-scheduling dbms-scheduler dbms-job

asked 2010-11-11T07:08:50.807

16

votes

2

answers

What happens in Oracle when I drop a column?

oracle-database

asked 2010-11-01T06:39:24.817

36

votes

8

answers

Calling Oracle stored procedure from C#?

c# .net oracle-database stored-procedures ado.net

asked 2010-10-15T08:22:31.427

21

votes

8

answers

SELECT DISTINCT CLOB_COLUMN FROM TABLE;

oracle-database plsql ora-00932

asked 2010-10-13T08:37:49.893

15

votes

3

answers

Load data to remote DB using sqlldr

oracle-database

asked 2010-10-09T03:49:32.943

30

votes

3

answers

How to write oracle insert script with one field as CLOB?

oracle-database

asked 2010-10-08T12:43:49.330

50

votes

5

answers

How to get rightmost 10 places of a string in oracle

sql oracle-database sorting oracle11g

asked 2010-10-08T06:59:07.390

9

votes

2

answers

How do transactions within Oracle stored procedures work? Is there an implicit transaction?

sql oracle-database

asked 2010-10-04T08:59:31.343

60

votes

3

answers

SQL Query to find missing rows between two related tables

sql database oracle-database

asked 2010-09-30T00:41:47.743

40

votes

3

answers

What does "%Type" mean in Oracle sql?

sql oracle-database plsql

asked 2010-09-24T20:17:36.583

9

votes

6

answers

WebSphere to Oracle - doesn't accept correct password

oracle-database jdbc websphere ora-01017

asked 2010-09-22T00:52:52.940

18

votes

8

answers

How to find tables having foreign key to a table in Oracle?

oracle-database key

asked 2010-09-20T13:31:31.603

31

votes

4

answers

Concurrent updates handling in hibernate

java oracle-database hibernate spring

asked 2010-09-01T08:43:19.630

38

votes

5

answers

Does "SELECT FOR UPDATE" prevent other connections inserting when the row is not present?

sql mysql sql-server oracle-database concurrency

asked 2010-08-30T15:38:02.773

10

votes

7

answers

Is it possible to read a CLOB from a remote Oracle database?

database oracle-database

asked 2010-08-29T11:00:38.473

9

votes

6

answers

Oracle SQL - select within a select (on the same table!)

sql oracle-database select join

asked 2010-08-24T16:14:12.300

11

votes

1

answers

Oracle SQL Developer: Show REFCURSOR Results in Grid?

oracle-database stored-procedures oracle-sqldeveloper

asked 2010-08-24T12:22:24.167

14

votes

1

answers

oracle pl/sql arrays

arrays oracle-database plsql

asked 2010-08-23T07:09:30.607

14

votes

5

answers

Check if table exists in the database - PL SQL

oracle-database plsql

asked 2010-08-19T19:24:04.540

146

votes

4

answers

What is the Oracle equivalent of SQL Server's IsNull() function?

sql-server oracle-database t-sql plsql

asked 2010-08-19T14:55:49.423

9

votes

3

answers

What Java data type corresponds to the Oracle SQL data type NUMERIC?

java sql oracle-database types sqldatatypes

asked 2010-08-17T16:05:22.717

12

votes

1

answers

What SQL data type does Oracle assign to "count(*)"?

sql oracle-database sqldatatypes

asked 2010-08-17T15:58:20.157

21

votes

5

answers

Determine if Oracle date is on a weekend?

oracle-database date plsql weekend

asked 2010-08-10T16:02:48.343

79

votes

4

answers

How to replace specific values in a oracle database column?

sql oracle-database replace

asked 2010-08-09T18:47:14.713

24

votes

5

answers

Declaring & Setting Variables in a Select Statement

sql oracle-database variables plsql

asked 2010-08-03T19:26:21.287

10

votes

3

answers

Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect

excel vba oracle-database ms-access ado

asked 2010-08-03T15:50:35.393

11

votes

6

answers

Setting Oracle 11g Session Timeout

oracle-database oracle11g

asked 2010-07-29T15:01:53.210

19

votes

2

answers

What does PARTITION BY 1 mean?

oracle-database count analytics database-partitioning

asked 2010-07-26T19:48:15.750

12

votes

4

answers

How big is the performance difference between Oracle and PostgreSQL?

performance oracle-database postgresql

asked 2010-07-23T09:11:26.123

10

votes

4

answers

Getting inserted ID after INSERT ... SELECT on Oracle

oracle-database spring jdbc insert ora-00933

asked 2010-07-16T01:17:08.763

12

votes

4

answers

Standard SQL alternative to Oracle DECODE

sql oracle-database ansi-sql

asked 2010-07-09T11:15:11.843

14

votes

1

answers

sql nested case statements

sql oracle-database case

asked 2010-07-06T15:36:39.180

15

votes

7

answers

How to make selecting random rows in Oracle faster with table with millions of rows?

oracle-database

asked 2010-06-30T15:05:57.353

20

votes

5

answers

How can I use Oracle SQL developer to run stored procedures?

oracle-database stored-procedures plsql oracle-sqldeveloper sys-refcursor

asked 2010-06-28T18:05:17.037

27

votes

3

answers

Get ID of last inserted record in oracle db

oracle-database

asked 2010-06-28T08:48:38.877

9

votes

4

answers

Any tools to export the whole Oracle DB as SQL scripts

oracle-database export liquibase baseline

asked 2010-06-28T06:54:20.740

Questions tagged oracle-database