All Oracle Solutions on Gang of Coders

Total of 358 Oracle Solutions

Oracle: how to UPSERT (update or insert into a table?)

Sql Oracle Merge Upsert

Oracle - What TNS Names file am I using?

Oracle Connection Tnsnames Tns

Alternatives to Toad

Database Oracle

Is there a function to split a string in PL/SQL?

String Oracle Plsql Split Tokenize

Find out the history of SQL queries

Oracle Sql Update Database Administration

Dropping connected users in Oracle database

Use string contains function in oracle SQL query

What does SQL Select symbol || mean?

Mysql Sql Oracle Ansi Sql

How do I view the Explain Plan in Oracle Sql developer?

Sql Oracle Oracle Sqldeveloper Sql Execution-Plan

How to insert date values into table

Sql Oracle Datetime Oracle10g Date Formatting

How should I store a GUID in Oracle?

Database Oracle Guid

Select without a FROM clause in Oracle

What does the colon sign ":" do in a SQL query?

Sql Oracle Plsql Bind Variables

Select from table by knowing only date without time (ORACLE)

Sql Oracle Date

Oracle: SQL query to find all the triggers belonging to the tables?

cx_Oracle: How do I iterate over a result set?

Python Sql Database Oracle Cx Oracle

What exactly do quotation marks around the table name do?

sqlplus statement from command line

Sql Oracle Sqlplus

Oracle: '= ANY()' vs. 'IN ()'

Sql Oracle Syntax

Oracle date "Between" Query

Sql Oracle Oracle10g Where Clause Date Arithmetic

Is there any boolean type in Oracle databases?

Sql Database Oracle Boolean Sqldatatypes

Online databases for trying out Oracle SQL queries?

Sql Database Oracle

Can you SELECT everything, but 1 or 2 fields, without writer's cramp?

SQL to add column and comment in table in single command

Sql Oracle Oracle11g

Display all views on oracle database

Database Oracle View Oracle Sqldeveloper

If statement in select (ORACLE)

Sql Oracle Select If Statement Oracle10g

ORA-01791: not a SELECTed expression

How to debug ORA-01775: looping chain of synonyms?

Sql Oracle Synonym

How can I issue a single command from the command line through sql plus?

Oracle Command Line Sqlplus

What's the most efficient way to check if a record exists in Oracle?

What's the SQL national character (NCHAR) datatype really for?

Sql Sql Server Oracle Tsql Nvarchar

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

Sql Database Oracle Oracle Sqldeveloper

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

Oracle Schema Ddl

Proper way of checking if row exists in table in PL/SQL block

Sql Oracle Select Plsql

ORA-01653: unable to extend table by in tablespace ORA-06512

Oracle Tablespace

How do I find duplicate values in a table in Oracle?

Sql Oracle Duplicate Data

Is there any way to flush output from PL/SQL in Oracle?

Sql Oracle Plsql Dbms Output

Change Primary Key

Sql Oracle Primary Key

How to query a CLOB column in Oracle

Sql Oracle Plsql Clob Ora 06502

How do I limit the number of rows returned by an Oracle query after ordering?

Sql Oracle Pagination Sql Limit

Oracle SQL: Update a table with data from another table

Sql Oracle Sql Update

What is the difference between varchar and varchar2 in Oracle?

Oracle Sqldatatypes

How to use Oracle's LISTAGG function with a unique filter?

Oracle Group By Oracle11g Aggregate Functions

libaio.so.1: cannot open shared object file

Linux Oracle Oracle Call-Interface

oracle SQL how to remove time from date

How can I create a copy of an Oracle table without copying the data?

Sql Oracle Copy Database Table

JDBC ResultSet get columns with table alias

Java Sql Oracle Jdbc Resultset

how to insert date and time in oracle?

Oracle timestamp data type

How to kill a running SELECT statement

Sql Oracle Select Oracle10g Sqlplus

create table with sequence.nextval in oracle

Sql Database Oracle Plsql

Oracle insert if not exists statement

Why would Oracle.ManagedDataAccess not work when Oracle.DataAccess does?

C#Oracle Tnsnames

How to submit changes in LinqPad

C#Oracle Linqpad

How to resolve ORA-011033: ORACLE initialization or shutdown in progress

Database Oracle

Default row ordering for select query in oracle

Oracle Sql Order-By

How to get UTC value for SYSDATE on Oracle

Oracle Timezone Utc

Find the server name for an Oracle database

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Oracle Oracle11g Sqlplus Ora 12514 Tnsping

How to use a package constant in SQL SELECT statement?

Sql Oracle Packages

Reason why oracle is case sensitive?

Oracle Database Design Case Sensitive

Granting DBA privileges to user in Oracle

Oracle Oracle11g

alter the size of column in table containing data

How to know installed Oracle Client is 32 bit or 64 bit?

Oracle 64 Bit Oracleclient

What is the best way to escape non-format characters in Oracle's to_char?

Sql Oracle To Char

Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?

Java Oracle Jdbc

Generating sql insert into for Oracle

SQL - How to select a row having a column with max value

Convert comma separated string to array in PL/SQL

Oracle Plsql Tokenize

Inner join vs Where

Sql Performance Oracle

JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

Java Sql Oracle Resultset Getdate

DATEDIFF function in Oracle

Sql Oracle Select Datediff

Get list of all tables in Oracle?

How do I list all the columns in a table?

Sql Mysql Sql Server Database Oracle

How do I do top 1 in Oracle?

Sql Oracle Oracle11g Sql Limit

Oracle "Partition By" Keyword

Sql Oracle Window Functions

How to connect to Oracle using Service Name instead of SID

Java Oracle Jdbc Connection String Service Name

Select count(*) from multiple tables

Sql Oracle Count

Oracle SQL Developer multiple table views

Oracle Oracle Sqldeveloper

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

Oracle Csv Export Oracle Sqldeveloper

Case insensitive searching in Oracle

Sql Oracle Case Sensitive Case Insensitive Sql Like

What is the dual table in Oracle?

Oracle Dual Table

Why does Oracle 9i treat an empty string as NULL?

Sql Oracle Null String

Oracle Differences between NVL and Coalesce

Sql Oracle Coalesce Nvl

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Oracle Ora 00054

How can I set a custom date time format in Oracle SQL Developer?

Oracle Oracle Sqldeveloper

How can I find which tables reference a given table in Oracle SQL Developer?

Sql Oracle Foreign Keys Oracle Sqldeveloper

What resources exist for Database performance-tuning?

Mysql Sql Server Database Oracle Postgresql

What is the difference between Non-Repeatable Read and Phantom Read?

Database Oracle Transactions Isolation Level Transaction Isolation

What is the maximum length of a table name in Oracle?

Oracle Name Length

When do I need to use a semicolon vs a slash in Oracle SQL?

Sql Oracle Sqlplus

What's the difference between RANK() and DENSE_RANK() functions in oracle?

Sql Oracle Window Functions

How can I get column names from a table in Oracle?

Sql Database Oracle

SQL Query to concatenate column values from multiple rows in Oracle

Sql Oracle String Aggregation

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

GROUP BY with MAX(DATE)

Sql Oracle Group By Greatest N-per-Group Ora 00979

Oracle find a constraint

Sql Oracle Constraints

How SID is different from Service name in Oracle tnsnames.ora

Database Oracle Service Administration Sid

How do I reset a sequence in Oracle?

Sql Database Oracle Sequence

How do I turn off Oracle password expiration?

Oracle Security

Oracle "(+)" Operator

Sql Oracle Join Outer Join

How to retrieve the current value of an oracle sequence without increment it?

Sql Oracle Sequence

Difference between BYTE and CHAR in column datatypes

Sql Oracle Unicode Varchar

Removing duplicate rows from table in Oracle

Sql Oracle Duplicates Delete Row

What is the string concatenation operator in Oracle?

Sql Oracle Plsql String Concatenation

Number of rows affected by an UPDATE in PL/SQL

Oracle Plsql Sql Update

How to list active / open connections in Oracle?

Oracle SELECT TOP 10 records

Sql Oracle Top N

How do I list all tables in a schema in Oracle SQL?

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

How to drop all user tables?

Oracle Constraints Sql Drop

ORA-00979 not a group by expression

Sql Oracle Ora 00979

How can I confirm a database is Oracle & what version it is using SQL?

error: ORA-65096: invalid common user or role name in oracle

Oracle Oracle12c

Escaping ampersand character in SQL string

Sql Oracle Escaping Sqlplus

Comparing Dates in Oracle SQL

Sql Oracle Date Comparison

The provider is not compatible with the version of Oracle client

C#asp.net Oracle odp.net Oracleclient

List of foreign keys and the tables they reference in Oracle DB

Oracle Metadata Database Metadata

Why are Oracle table/column/index names limited to 30 characters?

Oracle Oracle10g Size

How do I spool to a CSV formatted file using SQLPLUS?

Sql Oracle Csv Sqlplus

What is the difference between precision and scale?

How to execute an .SQL script file using c#

C#Sql Oracle Scripting

SELECT INTO using Oracle

Sql Oracle Ora 00905

How to declare variable and use it in the same Oracle SQL script?

Sql Oracle Variables Declaration

Boolean Field in Oracle

Oracle Boolean Sqldatatypes

ORA-30926: unable to get a stable set of rows in the source tables

Oracle Sql Merge

embedding image in html email

Html Image Oracle Email Mime

How to select only 1 row from oracle sql?

Sql Oracle Oracle9i

Changing password with Oracle SQL Developer

Oracle Oracle Sqldeveloper

How do I escape a reserved word in Oracle?

Oracle Reserved Words

PL/SQL, how to escape single quote in a string?

Use tnsnames.ora in Oracle SQL Developer

Sql Oracle Tnsnames Oracle Sqldeveloper

Oracle PL/SQL - How to create a simple array variable?

Oracle Plsql Oracle9i

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

UUID max character length

Oracle Primary Key Uuid

Fetch the row which has the Max value for a column

Sql Oracle Greatest N-per-Group Groupwise Maximum

update columns values with column of another table based on condition

Sql Mysql Sql Server Oracle

How do I calculate tables size in Oracle

How to use Oracle ORDER BY and ROWNUM correctly?

Sql Oracle Sql Order-By Rownum

Oracle query to fetch column names

How to get primary key column in Oracle?

Change Oracle port from port 8080

Search All Fields In All Tables For A Specific Value (Oracle)

Sql Oracle Search Plsql Database Table

Do I need to create indexes on foreign keys on Oracle?

Sql Oracle Indexing

Is there a version control system for database structure changes?

Sql Database Oracle Version Control

Are foreign keys really necessary in a database design?

Database Oracle Foreign Keys

How do I use variables in Oracle SQL Developer?

Sql Oracle Variables Declare

Can we have multiple "WITH AS" in single sql - Oracle SQL

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

Sql Server Oracle Tsql Plsql

Display names of all constraints for a table in Oracle SQL

Sql Oracle Oracle11g Constraints

How to avoid variable substitution in Oracle SQL Developer

Oracle Oracle Sqldeveloper

SQL error "ORA-01722: invalid number"

Sql Oracle Plsql Casting Type Conversion

Checking oracle sid and database name

Oracle Oracle10g

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

Java Oracle Jdbc

How do I get textual contents from BLOB in Oracle SQL

Sql Oracle Blob

Splitting string into multiple rows in Oracle

Sql String Oracle Plsql Tokenize

subquery in FROM must have an alias

Sql Oracle Postgresql Subquery

MySQL 'create schema' and 'create database' - Is there any difference

Sql Mysql Oracle Jdbc Database

How to show all privileges from a user in oracle?

Sql Oracle Rules Privileges

How many database indexes is too many?

Database Oracle Database Design

Oracle SQL, concatenate multiple columns + add text

Sql Oracle Concatenation

Paging with Oracle

Sql Oracle Stored Procedures

I need to store postal codes in a database. How big should the column be?

Database Oracle Globalization Postal Code

Cleanest way to build an SQL string in Java

Java Sql Oracle String

How to put more than 1000 values into an Oracle IN clause

Oracle In Clause

How do I use CREATE OR REPLACE?

Oracle Oracle10g Ddl

How can I combine multiple rows into a comma-delimited list in Oracle?

Sql Oracle Concatenation Pivot String Aggregation

How to create a new database after initally installing oracle database 11g Express Edition?

Oracle Oracle11g Oracle Sqldeveloper Oracle Xe

Search an Oracle database for tables with specific column names?

ORA-01882: timezone region not found

Oracle Jdbc Timezone

LISTAGG in Oracle to return distinct values

Sql Oracle Aggregate Functions Listagg

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

Database Oracle Db2 Blob Clob

How do I ignore ampersands in a SQL script running from SQL Plus?

Sql Oracle Sqlplus

How can I list ALL grants a user received?

Sql Oracle Sql Grant

How do you create a temporary table in an Oracle database?

Sql Oracle Temp Tables

ORA-01950: no privileges on tablespace 'USERS'

Oracle Privileges Tablespace

What does "select count(1) from table_name" on any database tables mean?

Sql Database Oracle

SQL selecting rows by most recent date with two unique columns

ORA-28040: No matching authentication protocol exception

Oracle Oracle12c

Get table name by constraint name

Oracle Constraints

Printing the value of a variable in SQL Developer

Oracle Plsql Oracle Sqldeveloper

Oracle JDBC ojdbc6 Jar as a Maven Dependency

Oracle Maven Jdbc War

How to check Oracle database for long running queries

How to Alter Constraint

How to check for null/empty/whitespace values with a single test?

Sql Oracle Oracle10g

Hibernate dialect for Oracle Database 11g?

Oracle Hibernate Oracle11g

Oracle SQL Query for listing all Schemas in a DB

What is the difference between "AS" and "IS" in an Oracle stored procedure?

Oracle Stored Procedures Keyword

Difference between oracle DATE and TIMESTAMP

Oracle Jdbc Oracle11g

Why would you use Oracle database?

Database Oracle Comparison

Calculate difference between 2 date / times in Oracle SQL

Oracle Date Arithmetic

Oracle DateTime in Where Clause?

Sql Oracle Time Date Arithmetic

Print text in Oracle SQL Developer SQL Worksheet window

Oracle Printing Oracle Sqldeveloper

Disable all table constraints in Oracle

Is it possible to generate django models from the database?

Database Django Oracle Orm

How to generate a GUID in Oracle?

How to insert a timestamp in Oracle?

ORA-00904: invalid identifier

Sql Database Oracle Ora 00904

Can you use Microsoft Entity Framework with Oracle?

.Net Oracle Entity Framework odp.net

Oracle SQL escape character (for a '&')

Sql Oracle Escaping Oracle Sqldeveloper

How to check the maximum number of allowed connections to an Oracle database?

Oracle TNS names not showing when adding new connection to SQL Developer

Database Oracle Oracle Sqldeveloper Tnsnames Tns

How to create id with AUTO_INCREMENT on Oracle?

Sql Oracle Auto Increment

Is java.sql.Timestamp timezone specific?

Java Oracle Date Datetime Jdbc

What does a (+) sign mean in an Oracle SQL WHERE clause?

How to get records randomly from the oracle database?

Oracle Select Random

How to use a calculated column to calculate another column in the same view

Where does Oracle SQL Developer store connections?

Oracle Oracle11g

Oracle: is there a tool to trace queries, like Profiler for sql server?

Sql Server Oracle Profiler

How can I drop a "not null" constraint in Oracle when I don't know the name of the constraint?

Oracle Plsql Constraints

ORA-00972 identifier is too long alias column name

Sql Oracle Alias

null vs empty string in Oracle

Oracle Null Oracle10g String

How can I get the number of records affected by a stored procedure?

Sql Sql Server Oracle Tsql Plsql

Oracle client ORA-12541: TNS:no listener

Oracle Listener

How do you interpret a query's explain plan?

Sql Database Performance Oracle Sql Execution-Plan

How do I select all the columns from a table, plus additional columns like ROWNUM?

Sql Oracle Select

How to select the nth row in a SQL database table?

Mysql Sql Database Oracle Postgresql

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

Ruby on-Rails Oracle Sqlplus Webrick

dbms_lob.getlength() vs. length() to find blob size in oracle

Sql Oracle Blob

How to display databases in Oracle 11g using SQL*Plus

Oracle Oracle11g Sqlplus

CASE .. WHEN expression in Oracle SQL

Sql Oracle Oracle10g

Run Stored Procedure in SQL Developer?

Oracle Stored Procedures Oracle Sqldeveloper

how to modify an existing check constraint?

Oracle Ora 00933

How to find the privileges and roles granted to a user in Oracle?

Oracle Security Oracle10g User Accounts

SQL Error: ORA-01861: literal does not match format string 01861

Sql Oracle Sql Insert

How to Select a substring in Oracle SQL up to a specific character?

Sql Oracle Substring Trim

Oracle PL/SQL - Raise User-Defined Exception With Custom SQLERRM

Oracle Exception Plsql Custom Exceptions

GROUP BY without aggregate function

Sql Oracle Group By Aggregate Functions

What is it exactly a BLOB in a DBMS context

Sql Oracle Blob Database Blobstore

Oracle SQL - DATE greater than statement

Sql Oracle Date Format

What is the default Precision and Scale for a Number in Oracle?

Database Oracle Number Formatting

How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

Oracle Oracle Sqldeveloper Entity Relationship Erd

How to see if the background process is complete in SQLDEVELOPER

Oracle Csv Background Export Oracle Sqldeveloper

How to uninstall / completely remove Oracle 11g (client)?

Oracle Oracle11g

How to rename a table column in Oracle 10g

Oracle Oracle10g

OVER clause in Oracle

Sql Oracle Window Functions

How can I introduce multiple conditions in LIKE operator?

How to handle a single quote in Oracle SQL

Sql Oracle Escaping

Is there a combination of "LIKE" and "IN" in SQL?

Sql Sql Server Oracle Tsql Plsql

Can a foreign key be NULL and/or duplicate?

Sql Sql Server Oracle Foreign Keys

How to create a user in Oracle 11g and grant permissions

Oracle Oracle11g Access Control

How to approach a "Got minus one from a read call" error when connecting to an Amazon RDS Oracle instance

When or Why to use a "SET DEFINE OFF" in Oracle Database

How to increase size of GUI/font/everything of Oracle SQL Developer 18.1

Oracle Oracle Sqldeveloper

Oracle SQL Developer - Query results window with grid missing

Oracle Oracleclient Oracle Sqldeveloper

Is it possible to output a SELECT statement from a PL/SQL block?

Sql Oracle Plsql Oracle10g Oracle Apex

MySQL vs. SQL Server vs. Oracle

Mysql Sql Server Oracle

What is the difference between Views and Materialized Views in Oracle?

Sql Oracle View Relational Database Materialized Views

ORA-00932: inconsistent datatypes: expected - got CLOB

How can I get all sequences in an Oracle database?

Sql Database Oracle Sequence Toad

How to Select Top 100 rows in Oracle?

What's the best way to determine which version of Oracle client I'm running?

How to import an Oracle database from dmp file and log file?

Oracle Oracle11g Oracle Dump

ORA-12560: TNS:protocol adaptor error

Sql Oracle Oracle9i Ora 12560

ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying

Oracle Oracle11g

How to extract group from regular expression in Oracle?

Oracle: If Table Exists

Sql Oracle Sql Drop

ORA-28001: The password has expired

How do I get the current year using SQL on Oracle?

Sql Oracle Date

Foreign key reference to table in another schema

Sql Oracle Database Design

How to get the week day name from a date?

Oracle Date Dayofweek

How to escape comma and double quote at same time for CSV file?

Java Regex Excel Oracle Csv

What is PostgreSQL equivalent of SYSDATE from Oracle?

Oracle Postgresql

Finding last index of a string in Oracle

How can multiple rows be concatenated into one in Oracle without creating a stored procedure?

Sql Oracle Concatenation String Aggregation

Difference between Oracle's plus (+) notation and ansi JOIN notation?

Sql Performance Oracle Join

Understanding the results of Execute Explain Plan in Oracle SQL Developer

Oracle Oracle Sqldeveloper Sql Execution-Plan

How to enter newline character in Oracle?

Select * from subquery

Add a auto increment primary key to existing table in oracle

What is the minimum client footprint required to connect C# to an Oracle database?

C#Oracle Client

What do the letter codes in Oracle user_contraints table's constraint_type column stand for?

Oracle Constraints Oracleinternals

How to replace specific values in a oracle database column?

Sql Oracle Replace

Is there a free GUI management tool for Oracle Database Express?

Dropping a connected user from an Oracle 10g database schema

Using an Alias in a WHERE clause

Sql Oracle Alias Decode Ora 00904

How to document a database

Sql Oracle Documentation

Select a random sample of results from a query result

Sql Oracle Random Sample

Materialized View vs. Tables: What are the advantages?

Sql Oracle Materialized Views

how to increase sqlplus column output length?

Sql Oracle Sqlplus Column Width

LISTAGG function: "result of string concatenation is too long"

Faster alternative in Oracle to SELECT COUNT(*) FROM sometable

Handling ExecuteScalar() when no results are returned

C#Oracle ado.net

No more data to read from socket error

Oracle Hibernate Spring Jdbc

Using Oracle to_date function for date string with milliseconds

Where's my invalid character (ORA-00911)

Java Oracle Jdbc Prepared Statement

ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

Oracle Oracle11g Oracle9i

Oracle's default date format is YYYY-MM-DD, WHY?

Oracle Date Formatting

How to execute an oracle stored procedure?

Oracle Plsql Oracle10g Ora 00900

Online SQL syntax checker conforming to multiple databases

Mysql Sql Server Oracle Postgresql

How to select several hardcoded SQL rows?

Mysql Sql Oracle

Relationship between catalog, schema, user, and database instance

Mysql Sql Server Oracle Postgresql Db2

Oracle insert from select into table with more columns

How do I get column datatype in Oracle with PL-SQL with low privileges?

Oracle Plsql Ddl Privileges

"Safe" TO_NUMBER()

Oracle Type Conversion Ora 01722

How to check if a column exists before adding it to an existing table in PL/SQL?

Sql Oracle Plsql

Calculating difference between two timestamps in Oracle in milliseconds

Sql Oracle Datetime

How do I show running processes in Oracle DB?

Oracle: What does `(+)` do in a WHERE clause?

Sql Oracle Operators

Oracle DB: How can I write query ignoring case?

Sql Database Oracle

Writing sqlplus output to a file

Different CURRENT_TIMESTAMP and SYSDATE in oracle

Sql Oracle Plsql Oracle10g

Select multiple columns into multiple variables

Sql Oracle Plsql Select Into

Counting number of joined rows in left join

Sql Oracle Join Count Left Join

What is the equivalent of the Oracle "Dual" table in MS SqlServer?

Sql Server Oracle Dual Table

Why doesn't Oracle tell you WHICH table or view does not exist?

Sql Database Oracle Ora 00942

Find duplicate entries in a column

Sql Oracle Subquery

Custom Order in Oracle SQL

Sql Oracle Sql Order-By

Update statement with inner join on Oracle

Sql Oracle Inner Join Ora 00933

Liquibase lock - reasons?

Database Oracle Liquibase

Get month name from date in Oracle

Sql Oracle Date

Which .NET data type is best for mapping the NUMBER Oracle data type in NHibernate?

C#Oracle Nhibernate Oracle10g Nhibernate Mapping

Best way to reset an Oracle sequence to the next value in an existing column?

Sql Oracle Oracle10g Primary Key Sequence

Difference between Oracle jdbc driver classes?

Java Oracle Jdbc

Oracle SQL : timestamps in where clause

Sql Oracle Where Sql Timestamp

Functions vs procedures in Oracle

Oracle Stored Procedures Plsql Oracle11g Stored Functions

ORA-28000: the account is locked error getting frequently

Oracle Oracle11g Oracle10g

how to modify the size of a column

Oracle Oracle Sqldeveloper Alter Table

Rename Oracle Table or View

Oracle Table Rename

Favorite SQL*Plus tips and tricks

Sql Oracle Sqlplus

Get a list of all functions and procedures in an Oracle database

Oracle Plsql Oracle9i

SQL to generate a list of numbers from 1 to 100

Sql Oracle Plsql

Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)

Oracle Oracle Xe

HQL "is null" And "!= null" on an Oracle column

Oracle Hibernate Null

Is the 'as' keyword required in Oracle to define an alias?

Sql Oracle Alias Required

Difference between a user and a schema in Oracle?

oracle - what statements need to be committed?

Sql Database Oracle Session Commit

How to refresh materialized view in oracle

Oracle Materialized Views

Using setDate in PreparedStatement

Java Sql Oracle Jdbc Prepared Statement

How to find Oracle Service Name

How do you connect to a MySQL database using Oracle SQL Developer?

Mysql Oracle Oracle Sqldeveloper

What is the difference between a hash join and a merge join (Oracle RDBMS )?

Sql Performance Oracle Join

How to use BOOLEAN type in SELECT statement

Sql Oracle Plsql Oracle10g Ora 00904

How can I select from list of values in Oracle

Sql Oracle Select Oracle11g

BEGIN - END block atomic transactions in PL/SQL

Using the DISTINCT keyword causes this error: not a SELECTed expression

Sql Oracle Hibernate Oracle11g

Best way to do multi-row insert in Oracle?

Sql Oracle Sql Insert Oracle9i

How to run .sql file in Oracle SQL developer tool to import database?

Sql Oracle Oracle Sqldeveloper

PL/SQL block problem: No data found error

Sql Oracle Plsql Oracle10g Ora 01403

Oracle JDBC intermittent Connection Issue

Java Oracle Jdbc

What is difference between primary index and secondary index exactly?

Mysql Database Oracle Indexing

Why is Oracle's to_char() function adding spaces?

IS vs AS keywords for PL/SQL Oracle Function or Procedure Creation

Sql Oracle Plsql

Create a user with all privileges in Oracle

What is a View in Oracle?

Database Oracle Views

Truncating a table in a stored procedure

Oracle Stored Procedures Plsql Ddl

How to export data with Oracle SQL Developer?

Sql Oracle Oracle Sqldeveloper

Oracle: how to INSERT if a row doesn't exist

SQL IN Clause 1000 item limit

UNION with WHERE clause

Sql Oracle Union

How to get first two characters of a string in oracle query?

The order of a SQL Select statement without Order By clause

Sql Server Oracle Select Sql Order-By

How to query GROUP BY Month in a Year

Alternatives to LIMIT and OFFSET for paging in Oracle

Sql Oracle Sql Limit

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

Oracle Jdbc Listener Tnsnames

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

Oracle Oracle11g Ora 01034 Ora 27101

Delete with "Join" in Oracle sql Query

Sql Oracle Sql Delete

Is there any function in oracle similar to group_concat in mysql?