Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

How to test an Oracle Stored Procedure with RefCursor return type?

I'm looking for a good explanation on how to test an Oracle stored procedure in SQL Developer or Embarcardero Rapid …

Read More
oracle stored-procedures plsqldeveloper ref-cursor rapidsql
How to return multiple rows from the stored procedure? (Oracle PL/SQL)

I want to create a stored procedure with one argument which will return different sets of records depending on the …

Read More
sql oracle plsql
Is there a function to split a string in PL/SQL?

I need to write a procedure to normalize a record that have multiple tokens concatenated by one char. I need …

Read More
string oracle plsql split tokenize
Oracle Differences between NVL and Coalesce

Are there non obvious differences between NVL and Coalesce in Oracle? The obvious differences are that coalesce will return the …

Read More
sql oracle coalesce nvl
ORA-00918: column ambiguously defined in SELECT *

Getting ORA-00918: column ambiguously defined: running this SQL: SELECT * FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER …

Read More
sql oracle ora-00918
INSERT SELECT statement in Oracle 11G

I'm trying to run a very simple sql statement in Oracle 11g. insert into table1 (col1, col2) values (select t1.…

Read More
sql oracle oracle11g
How to get the last row of an Oracle a table

I want to get the last row, which I inserted into a table in an Oracle 11g Express database. How …

Read More
sql oracle oracle11g
Hibernate dialect for Oracle Database 11g?

Is there a Hibernate dialect for Oracle Database 11g? Or should I use the org.hibernate.dialect.Oracle10gDialect that …

Read More
oracle hibernate oracle11g
How to create an Oracle sequence starting with max value from a table?

Trying to create a sequence in Oracle that starts with the max value from a specific table. Why does this …

Read More
sql oracle sequence
How to generate entire DDL of an Oracle schema (scriptable)?

Can anyone tell me how I can generate the DDL for all tables, views, indexes, packages, procedures, functions, triggers, types, …

Read More
oracle schema ddl