Gang Of Coders
Home
About Us
Contact Us
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
Oracle
Use string contains function in oracle SQL query
Sql
Oracle
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
Sql
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?
Sql
Oracle
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?
Sql
Oracle
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?
Oracle
Plsql
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
Sql
Oracle
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?
Sql
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
Sql
Oracle
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
Oracle timestamp data type
Sql
Oracle
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
Oracle
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
Oracle
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
Sql
Oracle
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
Oracle
SQL - How to select a row having a column with max value
Sql
Oracle
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?
Sql
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
Oracle
Jdbc
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
Oracle SELECT TOP 10 records
Sql
Oracle
Top N
How do I list all tables in a schema in Oracle SQL?
Sql
Oracle
How to add 'ON DELETE CASCADE' in ALTER TABLE statement
Sql
Oracle
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?
Sql
Oracle
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?
Oracle
Types
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?
Oracle
Plsql
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?
Sql
Oracle
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
Oracle
How to use Oracle ORDER BY and ROWNUM correctly?
Sql
Oracle
Sql Order-By
Rownum
Oracle query to fetch column names
Sql
Oracle
How to get primary key column in Oracle?
Oracle
Change Oracle port from port 8080
Oracle
Port
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
Sql
Oracle
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?
Sql
Oracle
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
Sql
Oracle
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
Oracle
How to Alter Constraint
Sql
Oracle
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
Oracle
Plsql
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
Sql
Oracle
Is it possible to generate django models from the database?
Database
Django
Oracle
Orm
How to generate a GUID in Oracle?
Oracle
Guid
How to insert a timestamp in Oracle?
Sql
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?
Sql
Oracle
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?
Sql
Oracle
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
Sql
Oracle
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?
Sql
Oracle
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
Java
Oracle
When or Why to use a "SET DEFINE OFF" in Oracle Database
Oracle
Sqlplus
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
Oracle
Clob
How can I get all sequences in an Oracle database?
Sql
Database
Oracle
Sequence
Toad
How to Select Top 100 rows in Oracle?
Sql
Oracle
What's the best way to determine which version of Oracle client I'm running?
Windows
Oracle
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?
Sql
Oracle
Oracle: If Table Exists
Sql
Oracle
Sql Drop
ORA-28001: The password has expired
Oracle
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
Oracle
String
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?
Oracle
Select * from subquery
Sql
Oracle
Add a auto increment primary key to existing table in oracle
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?
Oracle
Dropping a connected user from an Oracle 10g database schema
Oracle
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"
Sql
Oracle
Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
Oracle
Count
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
Oracle
To Date
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
Sql
Oracle
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
Process
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
Oracle
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
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
Oracle
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
Oracle
Plsql
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?
Oracle
IS vs AS keywords for PL/SQL Oracle Function or Procedure Creation
Sql
Oracle
Plsql
Create a user with all privileges in Oracle
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
Oracle
Plsql
SQL IN Clause 1000 item limit
Sql
Oracle
UNION with WHERE clause
Sql
Oracle
Union
How to get first two characters of a string in oracle query?
Sql
Oracle
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
Sql
Oracle
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?
Sql
Oracle