Top "Oracle" questions

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

How to use Oracle DMP files?

I have some files of an Oracle database with username and password. How do I connect to all files and …

oracle database-backups
Retrieving Stored procedures, Views, Functions, Triggers using Toad for Oracle

How can I get the scripts of Stored procedures, Views, Functions, Triggers in toad for oracle?

oracle toad
Recover unsaved SQL query Scripts in Oracle SQL Developer

I know how to do this in SQL Server thanks to this clever bit of code Use <database> …

sql oracle oracle-sqldeveloper
Free desktop client for Oracle?

Which is the best Open Source free client for querying an Oracle database? It may additionally support other databases (MySQL, …

database oracle desktop-application
java.sql.SQLException: ORA-00936: missing expression

Below I am creating table. public static final String CREATE_SQL = "CREATE TABLE " +DATABASE_TABLE + "(ID number(10,0), " + " CGUID VARCHAR(255), " + " PGUID …

java oracle ora-00936
ORA-01460: unimplemented or unreasonable conversion requested

When I run the following .Net code: using (var c = Shared.DataSources.BSS1.CreateCommand()) { c.CommandText = "\r\nSelect c1, c2, …

oracle odp.net
How to select top five or 'N' rows in Oracle 11g

select distinct ani_digit, ani_business_line from cta_tq_matrix_exp limit 5 I want to select top five rows …

sql oracle oracle11g syntax-error
Dropping all user tables/sequences in Oracle

As part of our build process and evolving database, I'm trying to create a script which will remove all of …

sql oracle plsql build-process oracle11g
Add a Column that Represents a Concatenation of Two Other Varchar Columns

I have an employees table and I want to add a third column valued as the concatenation of the first …

sql oracle concatenation oracle-sqldeveloper
How does one do a SQL select over multiple partitions?

Is there a more efficient way than: select * from transactions partition( partition1 ) union all select * from transactions partition( partition2 ) union …

sql oracle database-partitioning