Alex Rivera | Logout

Questions tagged oracle-database

513 questions · page 2 of 11

Sort by: Newest Votes Active
32
votes
2
answers

When should I use 'for update nowait' in cursors?

oracle-database stored-procedures oracle11g oracle10g database-cursor
asked 2012-11-06T09:39:25.207
35
votes
1
answers

Is there a difference between Surrogate key, Synthetic Key, and Artificial Key?

sql oracle-database database-design data-modeling
asked 2012-11-05T04:28:23.633
10
votes
3
answers

listunagg function?

string oracle-database csv oracle11g tokenize
asked 2012-11-02T05:02:47.703
29
votes
13
answers

Django: how to see the SQL query when running tests?

sql django oracle-database unit-testing django-testing
asked 2012-10-31T16:42:27.600
41
votes
17
answers

PLSQL :NEW and :OLD

oracle-database plsql triggers
asked 2012-10-30T08:37:20.753
14
votes
6
answers

set serveroutput on in oracle procedure

oracle-database procedure
asked 2012-10-28T23:45:20.450
22
votes
2
answers

Oracle: Call stored procedure inside the package

oracle-database package
asked 2012-10-23T08:08:48.483
8
votes
2
answers

Is there a way to configure Elastic Beanstalk to connect to an existing Oracle DB (without BYOL)?

oracle-database amazon-web-services amazon-elastic-beanstalk
asked 2012-10-15T20:07:29.597
15
votes
2
answers

Oracle IN vs Exists difference?

sql oracle-database
asked 2012-10-15T12:49:28.670
15
votes
10
answers

Why in SQL NULL can't match with NULL?

mysql sql sql-server oracle-database null
asked 2012-10-12T07:06:52.490
11
votes
2
answers

Simple getColumnName(0) call throws Invalid column index: getValidColumnIndex

java sql oracle-database jdbc
asked 2012-10-08T19:08:06.040
8
votes
4
answers

ORA-00907: missing right parenthesis Error while creating a table?

oracle-database ora-00907
asked 2012-10-08T01:53:17.743
9
votes
2
answers

How to Pass Java List of Objects to Oracle Stored Procedure Using MyBatis?

oracle-database stored-procedures mybatis
asked 2012-10-04T02:56:14.410
12
votes
3
answers

Procedure in package specification

oracle-database stored-procedures plsql scope package
asked 2012-10-03T11:06:03.667
13
votes
1
answers

how to use xmltable in oracle?

xml oracle-database
asked 2012-10-02T13:09:00.203
8
votes
3
answers

Oracle SQL : search column that starts with digits

sql string oracle-database digits
asked 2012-10-01T09:18:11.260
12
votes
1
answers

How to delete a column from a view

sql oracle-database oracle11g
asked 2012-09-30T10:11:22.750
8
votes
1
answers

Does the Oracle JDBC client encrypt password when you make a connection?

oracle-database jdbc
asked 2012-09-05T15:34:44.683
12
votes
2
answers

Oracle Merge vs Select then Insert or Update

sql oracle-database sql-merge
asked 2012-09-05T03:35:35.147
14
votes
2
answers

How to convert column value to CamelCase with Oracle?

sql oracle-database camelcasing
asked 2012-09-04T14:56:53.593
8
votes
2
answers

Oracle User defined aggregate function for varray of varchar

oracle-database oracle11g aggregate-functions varray
asked 2012-09-02T15:34:39.657
20
votes
3
answers

Understanding JodaTime DateTime.parse(string, formatter)

java oracle-database datetime formatting jodatime
asked 2012-08-28T20:21:36.090
8
votes
2
answers

SELECT as much data from CLOB to VARCHAR2 as possible, with multibyte chars in the data

sql oracle-database substr clob multibyte
asked 2012-08-23T05:48:31.720
12
votes
7
answers

jboss 7 oracle datasource configuration

oracle-database datasource jboss7.x
asked 2012-08-21T07:07:58.847
13
votes
4
answers

Oracle <> , != , ^= operators

sql database performance oracle-database query-optimization
asked 2012-08-17T09:22:16.937
10
votes
3
answers

Sql Insert statement return "zero/no rows inserted"

oracle-database plsql insert
asked 2012-08-09T05:08:38.193
32
votes
2
answers

SSIS - the value cannot be converted because of a potential loss of data

sql-server oracle-database ssis etl
asked 2012-07-31T14:31:52.547
9
votes
2
answers

Is a deadlock possible when updating and deleting different rows in a table?

oracle-database
asked 2012-07-27T16:03:27.260
18
votes
2
answers

Troubleshoot Oracle - hung process

java database oracle-database
asked 2012-07-26T16:36:28.930
31
votes
6
answers

Using Oracle XMLType column in hibernate

xml oracle-database hibernate
asked 2012-07-20T11:45:07.077
9
votes
2
answers

Oracle JDBC charset and 4000 char limit

java database oracle-database jdbc ojdbc
asked 2012-07-19T14:17:37.913
135
votes
24
answers

LISTAGG in Oracle to return distinct values

sql oracle-database aggregate-functions listagg
asked 2012-07-16T19:04:43.957
14
votes
4
answers

Oracle: Concat with delimiter, but only if both operands are NOT NULL

oracle-database oracle10g concatenation
asked 2012-07-12T14:32:16.357
10
votes
5
answers

How can I check if a procedure exists in a package?

oracle-database plsql
asked 2012-07-11T15:46:17.040
8
votes
3
answers

Oracle drop column and unused column

oracle-database
asked 2012-07-05T19:16:41.403
18
votes
2
answers

Should SELECT ... FOR UPDATE always contain ORDER BY?

oracle-database locking deadlock
asked 2012-07-03T13:26:08.733
10
votes
5
answers

What is the simplest way to define a local variable in Oracle?

oracle-database variables plsql
asked 2012-07-02T17:53:35.430
8
votes
2
answers

ORA 00904 Error:Invalid Identifier

sql oracle-database ora-00904
asked 2012-06-30T19:46:05.510
14
votes
2
answers

how to write Oracle Function For Convert Date to persian (jalali)

database oracle-database function
asked 2012-06-26T10:48:55.113
9
votes
3
answers

Repeating rows based on column value in each row

sql oracle-database
asked 2012-06-26T05:34:43.130
9
votes
1
answers

how to declare %ROWTYPE of a variable that is a weakly typed SYS_REFCURSOR?

oracle-database stored-procedures plsql sys-refcursor rowtype
asked 2012-06-25T10:16:22.333
9
votes
4
answers

Best design pattern to close database connection when exception occurs

java oracle-database jdbc
asked 2012-06-22T16:42:13.443
13
votes
1
answers

Is there any way to determine if a package has state in Oracle?

oracle-database oracle11g package state
asked 2012-06-14T23:25:06.353
22
votes
3
answers

How to show comments of a column with desc operation

oracle-database oracle-sqldeveloper
asked 2012-06-06T10:22:56.653
58
votes
7
answers

How to generate entire DDL of an Oracle schema (scriptable)?

oracle-database schema ddl
asked 2012-06-04T18:40:35.293
9
votes
1
answers

Rank function in MySQL with Order By clause

mysql oracle-database window-functions rank
asked 2012-06-04T13:14:36.657
14
votes
6
answers

How can I save my Oracle Toad connections to move to a new PC?

oracle-database toad
asked 2012-06-04T01:16:30.267
22
votes
5
answers

oracle pl/sql DBMS_LOCK error

oracle-database plsql
asked 2012-06-03T13:32:57.330
152
votes
4
answers

Is there any difference between "!=" and "<>" in Oracle Sql?

sql oracle-database
asked 2012-05-18T10:22:56.437
55
votes
4
answers

Oracle 'Partition By' and 'Row_Number' keyword

sql oracle-database partition row-number analytic-functions
asked 2012-05-07T05:28:00.200
← Prev page 2 of 11 Next →