How to use ?
Noob codes chrome extension
Tool made for making your Programming life easier
updated on 2-4-2021
How to Use ?
Search code snippets in oracle
java.sql.SQLException: ORA-00933: SQL command not properly ended when using getGeneratedKeys
Get list of all tables in Oracle?
How do I limit the number of rows returned by an Oracle query after ordering?
Fetch the row which has the Max value for a column
Oracle: If Table Exists
Difference between a user and a schema in Oracle?
Update statement with inner join on Oracle
Oracle: how to UPSERT (update or insert into a table?)
Liquibase lock - reasons?
How do I find duplicate values in a table in Oracle?
Best way to do multi-row insert in Oracle?
How can I create a copy of an Oracle table without copying the data?
Is there any boolean type in Oracle databases?
What is the difference between varchar and varchar2 in Oracle?
Oracle SQL: Update a table with data from another table
Oracle “Partition By” Keyword
Java JDBC - How to connect to Oracle using Service Name instead of SID
How do I do top 1 in Oracle?
Select count(*) from multiple tables
Case insensitive searching in Oracle
How can I find which tables reference a given table in Oracle SQL Developer?
How can I set a custom date time format in Oracle SQL Developer?
What is the maximum length of a table name in Oracle?
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
When do I need to use a semicolon vs a slash in Oracle SQL?
How can I get column names from a table in Oracle?
How SID is different from Service name in Oracle tnsnames.ora
Oracle find a constraint
How do I reset a sequence in Oracle?
SQL Query to concatenate column values from multiple rows in Oracle
What is the string concatenation operator in Oracle?
GROUP BY with MAX(DATE)
How can I confirm a database is Oracle & what version it is using SQL?
How to list active / open connections in Oracle?
How do I list all tables in a schema in Oracle SQL?
Number of rows affected by an UPDATE in PL/SQL
How to drop all user tables?
Oracle “(+)” Operator
Removing duplicate rows from table in Oracle
ORA-00979 not a group by expression
What's the difference between RANK() and DENSE_RANK() functions in oracle?
Why are Oracle table/column/index names limited to 30 characters?
Escaping ampersand character in SQL string
Oracle SELECT TOP 10 records
List of foreign keys and the tables they reference in Oracle DB
How do I spool to a CSV formatted file using SQLPLUS?
Boolean Field in Oracle
Changing password with Oracle SQL Developer
SELECT INTO using Oracle
How to execute an .SQL script file using c#
How to add 'ON DELETE CASCADE' in ALTER TABLE statement
error: ORA-65096: invalid common user or role name in oracle
ORA-30926: unable to get a stable set of rows in the source tables
How to use Oracle ORDER BY and ROWNUM correctly?
Oracle PL/SQL - How to create a simple array variable?
How do I calculate tables size in Oracle
PL/SQL, how to escape single quote in a string?
Oracle query to fetch column names
How to select only 1 row from oracle sql?
Change Oracle port from port 8080
How do I use variables in Oracle SQL Developer?
Is there a version control system for database structure changes?
embedding image in html email
Display names of all constraints for a table in Oracle SQL
Search All Fields In All Tables For A Specific Value (Oracle)
Checking oracle sid and database name
How do I get textual contents from BLOB in Oracle SQL
What is the Oracle equivalent of SQL Server's IsNull() function?
How can I combine multiple rows into a comma-delimited list in Oracle?
Can we have multiple “WITH AS” in single sql - Oracle SQL
How to get primary key column in Oracle?
How many database indexes is too many?
Oracle SQL, concatenate multiple columns + add text
Splitting string into multiple rows in Oracle
Cleanest way to build an SQL string in Java
How to put more than 1000 values into an Oracle IN clause
How do I ignore ampersands in a SQL script running from SQL Plus?
SQL error “ORA-01722: invalid number”
SQL selecting rows by most recent date with two unique columns
ORA-01882: timezone region not found
Printing the value of a variable in SQL Developer
Get table name by constraint name
Paging with Oracle
How do I use CREATE OR REPLACE?
How can I list ALL grants a user received?
How to check Oracle database for long running queries
LISTAGG in Oracle to return distinct values
Oracle SQL Query for listing all Schemas in a DB
Disable all table constraints in Oracle
How do you create a temporary table in an Oracle database?
How to insert a timestamp in Oracle?
Oracle TNS names not showing when adding new connection to SQL Developer
How to generate a GUID in Oracle?
Print text in Oracle SQL Developer SQL Worksheet window
Calculate difference between 2 date / times in Oracle SQL
Webrick is very slow to respond. How to speed it up?
Where does Oracle SQL Developer store connections?
How to check for null/empty/whitespace values with a single test?
Oracle: is there a tool to trace queries, like Profiler for sql server?
Oracle SQL escape character (for a '&')
Oracle DateTime in Where Clause?
Is java.sql.Timestamp timezone specific?
How can I drop a “not null” constraint in Oracle when I don't know the name of the constraint?
CASE .. WHEN expression in Oracle SQL
How to get records randomly from the oracle database?
Run Stored Procedure in SQL Developer?
Oracle PL/SQL - Raise User-Defined Exception With Custom SQLERRM
How to display databases in Oracle 11g using SQL*Plus
What does a (+) sign mean in an Oracle SQL WHERE clause?
How to find the privileges and roles granted to a user in Oracle?
How to use a calculated column to calculate another column in the same view
How to rename a table column in Oracle 10g
how to modify an existing check constraint?
How do I select all the columns from a table, plus additional columns like ROWNUM?
GROUP BY without aggregate function
How can I get all sequences in an Oracle database?
What is the default Precision and Scale for a Number in Oracle?
ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
How can I introduce multiple conditions in LIKE operator?
Difference between Oracle's plus (+) notation and ansi JOIN notation?
Finding last index of a string in Oracle
What do the letter codes in Oracle user_contraints table's constraint_type column stand for?
When or Why to use a “SET DEFINE OFF” in Oracle Database
Understanding the results of Execute Explain Plan in Oracle SQL Developer
ORA-00932: inconsistent datatypes: expected - got CLOB
What's the best way to determine which version of Oracle client I'm running?
How to approach a “Got minus one from a read call” error when connecting to an Amazon RDS Oracle instance
Where's my invalid character (ORA-00911)
How to escape comma and double quote at same time for CSV file?
Using an Alias in a WHERE clause
Oracle insert from select into table with more columns
How to get the week day name from a date?
Oracle's default date format is YYYY-MM-DD, WHY?
ORA-12560: TNS:protocol adaptor error
Dropping a connected user from an Oracle 10g database schema
How do I get the current year using SQL on Oracle?
How to extract group from regular expression in Oracle?
ORA-28001: The password has expired
How to enter newline character in Oracle?
how to increase sqlplus column output length?
How do I show running processes in Oracle DB?
How can multiple rows be concatenated into one in Oracle without creating a stored procedure?
Handling ExecuteScalar() when no results are returned
Select a random sample of results from a query result
How to execute an oracle stored procedure?
LISTAGG function: “result of string concatenation is too long”
How to increase size of GUI/font/everything of Oracle SQL Developer 18.1
How to Select Top 100 rows in Oracle?
Custom Order in Oracle SQL
HQL “is null” And “!= null” on an Oracle column
How to check if a column exists before adding it to an existing table in PL/SQL?
ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
Favorite SQL*Plus tips and tricks
Calculating difference between two timestamps in Oracle in milliseconds
Select * from subquery
Oracle: What does `(+)` do in a WHERE clause?
Why is Oracle's to_char() function adding spaces?
Get month name from date in Oracle
Rename Oracle Table or View
Oracle DB: How can I write query ignoring case?
How do I get column datatype in Oracle with PL-SQL with low privileges?
How to refresh materialized view in oracle
Get a list of all functions and procedures in an Oracle database
Find out the history of SQL queries
Which .NET data type is best for mapping the NUMBER Oracle data type in NHibernate?
Oracle - What TNS Names file am I using?
Select multiple columns into multiple variables
Is there a function to split a string in PL/SQL?
Is the 'as' keyword required in Oracle to define an alias?
oracle - what statements need to be committed?
PL/SQL block problem: No data found error
Oracle: how to INSERT if a row doesn't exist
How can I select from list of values in Oracle
How to enter special characters like “&” in oracle database?
How to run .sql file in Oracle SQL developer tool to import database?
Counting number of joined rows in left join
Best way to reset an Oracle sequence to the next value in an existing column?
SQL IN Clause 1000 item limit
Truncating a table in a stored procedure
how to modify the size of a column
Alternatives to LIMIT and OFFSET for paging in Oracle
How to debug ORA-01775: looping chain of synonyms?
sqlplus statement from command line
How to get first two characters of a string in oracle query?
How to query GROUP BY Month in a Year
What's the most efficient way to check if a record exists in Oracle?
SQL to generate a list of numbers from 1 to 100
Can you SELECT everything, but 1 or 2 fields, without writer's cramp?
create table with sequence.nextval in oracle
How to find Oracle Service Name
How to know installed Oracle Client is 32 bit or 64 bit?
Display all views on oracle database
Select without a FROM clause in Oracle
How can I issue a single command from the command line through sql plus?
How to generate entire DDL of an Oracle schema (scriptable)?
cx_Oracle: How do I iterate over a result set?
JDBC ResultSet get columns with table alias
How to use Oracle's LISTAGG function with a unique filter?
How should I store a GUID in Oracle?
JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp
Delete with “Join” in Oracle sql Query
Oracle insert if not exists statement
How do I view the Explain Plan in Oracle Sql developer?
If statement in select (ORACLE)
How to resolve ORA-011033: ORACLE initialization or shutdown in progress
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
Change Primary Key
ORA-01653: unable to extend table by in tablespace ORA-06512
Why would Oracle.ManagedDataAccess not work when Oracle.DataAccess does?
SQL to add column and comment in table in single command
How to query a CLOB column in Oracle
How to get UTC value for SYSDATE on Oracle
how to insert date and time in oracle?
Understanding Oracle's Java on Mac
What is the best way to escape non-format characters in Oracle's to_char?
How to correctly set the ORACLE_HOME variable on Ubuntu 9.x?
Convert comma separated string to array in PL/SQL
How to return multiple rows from the stored procedure? (Oracle PL/SQL)
Update statement using with clause
Proper way of checking if row exists in table in PL/SQL block
Get resultset from oracle stored procedure
SQL - How to store and navigate hierarchies?
Determine Oracle null == null
Oracle 'Partition By' and 'Row_Number' keyword
Insert if not exists Oracle
SQL - How to select a row having a column with max value
How to redirect the output of DBMS_OUTPUT.PUT_LINE to a file?
Performing Inner Join for Multiple Columns in the Same Table
How to submit changes in LinqPad
Do we need to specify “not null” for primary key? Oracle/SQL
SQL not displaying null values on a not equals query?
How to create an Oracle sequence starting with max value from a table?
Mapping a foreign key with a custom column name
Declaring a variable and setting its value from a SELECT query in Oracle
Using bind variables with dynamic SELECT INTO clause in PL/SQL
How can I insert multiple rows into oracle with a sequence value?
Creating a trigger in Oracle Express
Find the server name for an Oracle database
URL string format for connecting to Oracle database with JDBC
Oracle: SQL query that returns rows with only numeric values
Use string contains function in oracle SQL query
Oracle: sequence MySequence.currval is not yet defined in this session
oracle SQL how to remove time from date
Oracle: how to add minutes to a timestamp?
Find out free space on tablespace
How to insert a string which contains an “&”
INSERT SELECT statement in Oracle 11G
Connecting to Oracle Database through C#?
How does GROUP BY work?
How to select the comparison of two columns as one column in Oracle
How to find out when a particular table was created in Oracle?
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Grant Select on all Tables Owned By Specific User
Default Schema in Oracle Connection URL
How to count the number of occurrences of a character in an Oracle varchar value?
Generate a range of dates using SQL
How to display table data more clearly in oracle sqlplus
SQL multiple columns in IN clause
SQL Query to fetch data from the last 30 days?
Is there a way to do full text search of all oracle packages and procedures?
Convert from Oracle's RAW(16) to .NET's GUID
How can I execute a native SQL script in JPA/Hibernate?
Base64 encoding and decoding in oracle
Oracle unique constraint and unique index
How do I remove the default value from a column in oracle?
SQL Server VS Oracle
How to determine the Schemas inside an Oracle Data Pump Export file
How do I change the default schema in sql developer?
How to catch a unique constraint error in a PL/SQL block?
How to test an Oracle Stored Procedure with RefCursor return type?
Is there such thing CASE expression in JPQL?
Trim Whitespaces (New Line and Tab space) in a String in Oracle
How can I select records ONLY from yesterday?
DATEDIFF function in Oracle
What is the difference between CLOB and NCLOB?
Error java.sql.SQLException: ORA-00911: invalid character
How to run Oracle query with begin/end in SQL*Plus?
How to compare strings in sql ignoring case?
Update rows in one table with data from another table based on one column in each being equal
How do NULL values affect performance in a database search?
ROWID (oracle) - any use for it?
How to list all the roles existing in Oracle database?
oracle sql: update if exists else insert
Oracle pl-sql escape character (for a “ ' ”)
'CONTINUE' keyword in Oracle 10g PL/SQL
Top 5 time-consuming SQL queries in Oracle
Oracle SqlPlus - saving output in a file but don't show on screen
Does ODP.NET require Oracle Client installation
Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found
Howto import an oracle dump in an different tablespace
SQL ROWNUM how to return rows between a specific range
Get counts of all tables in a schema
Oracle: How to find out if there is a transaction pending?
insert a multiline string in Oracle with sqlplus
How can I get the number of days between 2 dates in Oracle 11g?
Unique constraint on multiple columns
Oracle Date - How to add years to date
Update columns with Null values
Creating new table with SELECT INTO in SQL
Group by alias (Oracle)
How to give a unique constraint to a combination of columns in Oracle?
Joining a list of values with table rows in SQL
How can I describe a table in Oracle without using the DESCRIBE command?
Extracting the total number of seconds from an interval data-type
MODIFY COLUMN in oracle - How to check if a column is nullable before setting to nullable?
Efficient way to update all rows in a table
Oracle: Changing VARCHAR2 column to CLOB
How to run a stored procedure in oracle sql developer?
SQL Error: ORA-00933: SQL command not properly ended
what does a B-tree index on more than 1 column look like?
Oracle query to get Data from table inserted in last 10 mins
check if “it's a number” function in Oracle
Oracle: how to “group by” over a range?
How can you tell if a value is not numeric in Oracle?
How can I insert into a BLOB column from an insert statement in sqldeveloper?
Split String by delimiter position using oracle SQL
ORA-00984: column not allowed here
How can I access Oracle from Python?
How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
How to find Current open Cursors in Oracle
PL/SQL print out ref cursor returned by a stored procedure
ORA-01830: date format picture ends before converting entire input string / Select sum where date query
Oracle Pl/SQL: Loop through XMLTYPE nodes
How to calculate the maximum of two numbers in Oracle SQL select?
How to change column varchar to clob in oracle
Sleep function in ORACLE
Dropping all user tables/sequences in Oracle
Error : ORA-01704: string literal too long
NULL or BLANK fields (ORACLE)
SQL recursive query on self referencing table (Oracle)
Decision when to create Index on table column in database?
ORA-01008: not all variables bound. They are bound
Check if a variable is null in plsql
install cx_oracle for python
Oracle SQL: Use sequence in insert with Select Statement
System users password has expired
How do I get a list of locked users in an Oracle database?
How to get current Connection object in Spring JDBC
How do I query for something that starts with certain characters?
How to get size in bytes of a CLOB column in Oracle?
Why do I have ORA-00904 even when the column is present?
varchar2(n BYTE|CHAR) default -> CHAR or BYTE
Oracle copy data to another table
DECODE( ) function in SQL Server
SQL How to Select the most recent date item
Is there any way to have the JBoss connection pool reconnect to Oracle when connections go bad?
T-SQL: How can you create a table with SELECT?
How to connect to remote Oracle DB with PL/SQL Developer?
Is there an Oracle SQL query that aggregates multiple rows into one row?
How to connect in java as SYS to Oracle?
ORA-00918: column ambiguously defined in SELECT *
Oracle REGEXP_LIKE and word boundaries
How to execute an Oracle stored procedure via a database link
How to find out when an Oracle table was updated the last time
OracleCommand SQL Parameters Binding
What does Hibernate map a boolean datatype to when using an Oracle database by default?
oracle diff: how to compare two tables?
Inserting into Oracle and retrieving the generated sequence ID
Finding and removing non ascii characters from an Oracle Varchar2
How to Query Database Name in Oracle SQL Developer?
Installing Oracle Instant Client
Calling Oracle stored procedure from C#?
Truncate table in Oracle getting errors
Oracle date difference to get number of years
How to get rightmost 10 places of a string in oracle
Benefits Of Using SQL Ordinal Position Notation?
Best practice for pagination in Oracle?
Sum columns with null values in oracle
oracle drop index if exists
'NOT LIKE' in an SQL query
Taking the record with the max date
How to get the last row of an Oracle a table
Multiplication aggregate operator in SQL
SQL to search objects, including stored procedures, in Oracle
How to select all columns, and a count(*) in the same query
Oracle “ORA-01008: not all variables bound” Error w/ Parameters
oracle sql date not later than today
ORA-12638: Credential retrieval failed
ORA-01031: insufficient privileges when selecting view
Check if two “select”s are equivalent
Oracle - Insert New Row with Auto Incremental ID
Oracle create table using with clause
Get data type of field in select statement in ORACLE
oracle varchar to number
executing a function in sql plus
Search for a particular string in Oracle clob column
ORA-00054: resource busy and acquire with NOWAIT specified
PLSQL :NEW and :OLD
Checking whether an item does not exist in another table
How can I kill all sessions connecting to my oracle database?
Oracle SQL query for Date format
ORA-01843 not a valid month- Comparing Dates
How to declare and display a variable in Oracle
How do you select all columns, plus the result of a CASE statement in oracle 11g?
Split function in oracle to comma separated values with automatic sequence
ORA-01799: a column may not be outer-joined to a subquery
PL/SQL Package invalidated
Find if a column in Oracle has a sequence
PLS-00428: an INTO clause is expected in this SELECT statement
Oracle Age calculation from Date of birth and Today
How to make use of SQL (Oracle) to count the size of a string?
Oracle - How to create a readonly user
Copying a row in the same table without having to type the 50+ column names (while changing 2 columns)
Oracle SQL insert into with With clause
ORA-12516, TNS:listener could not find available handler
What's the difference between pls_integer and binary_integer?
ORA-38104: Columns referenced in the ON Clause cannot be updated
Getting error while trying to alter table in an sql block
How to disable Oracle XE component which is listening on 8080?
How to store only time; not date and time?
Hidden features of PL/SQL
How to determine tables size in Oracle
SQLRecoverableException: I/O Exception: Connection reset
Oracle's lack of a Bit datatype for table columns
Convert OracleParameter.Value to Int32
Oracle, Make date time's first day of its month
Oracle Delete Rows Matching On Multiple Values
Selecting the second row of a table using rownum
Oracle PL/SQL: how to get the stack trace, package name and procedure name
Why doesn't Oracle SQL allow us to use column aliases in GROUP BY clauses?
Solution to “cannot perform a DML operation inside a query”?
How to get list of all materialized views in oracle
How to aggregate boolean column
Escaping single quote in PLSQL
Oracle subquery does not see the variable from the outer block 2 levels up
What length can a network interface name have?
Get ID of last inserted record in oracle db
Is substr or LIKE faster in Oracle?
Issue building cx_Oracle - libclntsh.so.11.1 => not found
Oracle Date TO_CHAR('Month DD, YYYY') has extra spaces in it
SQL: delete all the data from all available tables
Connection timeout for DriverManager getConnection
How to use existing Oracle sequence to generate id in hibernate?
Oracle Equivalent to MySQL INSERT IGNORE?
Oracle 11g SQL to get unique values in one column of a multi-column query
Does SQLDeveloper support executing scripts?
How to get list of all the procedure inside a package oracle
Using a view with no primary key with Entity
pl/sql stored procedure: parameter name same as column name
Query several NEXTVAL from sequence in one statement
How to retrieve an Oracle directory path?
Oracle, adding leading zeros to string (not number)
Return results of a sql query as JSON in oracle 12c
How to write / update Oracle blob in a reliable way?
Why is selecting specified columns, and all, wrong in Oracle SQL?
Example of an Oracle PIVOT clause with subquery
Selecting both MIN and MAX From the Table is slower than expected
Multiple REPLACE function in Oracle
get string from right hand side
oracle blob text search
sqlplus remote connection giving ORA-21561
Creating Duplicate Table From Existing Table
ORACLE and TRIGGERS (inserted, updated, deleted)
How to subtract hours from a date in Oracle so it affects the day also
SQL “Join” on null values
Abort a PL/SQL program
How to kill all active and inactive oracle sessions for user
How to add a new column with foreign key constraint in a single statement in oracle
Is there a way to create multiple triggers in one script?
Add column in Oracle table
oracle plsql: how to parse XML and insert into table
NLS_LANG setting for JDBC thin driver?
Using SELECT inside COALESCE
In SQL Server, how can I lock a single row in a way similar to Oracle's “SELECT FOR UPDATE WAIT”?
ORA-01654: unable to extend index
PL/SQL ORA-01422: exact fetch returns more than requested number of rows
SQL: how to limit a join on the first found row?
UPDATE with CASE and IN - Oracle
How can I check the last time stats was run on Oracle without using OEM
Hidden features in Oracle
Recover unsaved SQL query Scripts in Oracle SQL Developer
Count number of tables in Oracle
ORACLE SQL:Get all integers between two numbers
Can We use threading in PL/SQL?
Bulk Insert into Oracle database: Which is better: FOR Cursor loop or a simple Select?
Oracle: How do I convert hex to decimal in Oracle SQL?
How do I display the full content of LOB column in Oracle SQL*Plus?
oracle sql query to format number by comma
Materialized Views - Identifying the last refresh
How can I deploy a .NET application that uses ODAC without installing the whole component to the user?
Error (ORA-00923: FROM keyword not found where expected)
CX_Oracle - import data from Oracle to Pandas dataframe
SQL Performance: SELECT DISTINCT versus GROUP BY
Oracle: DBMS_UTILITY.EXEC_DDL_STATEMENT vs EXECUTE IMMEDIATE
How to clear a queue in Oracle AQ
Force Oracle to return TOP N rows with SKIP LOCKED
Execute Statement or Run Script?
Split varchar into separate columns in Oracle
Escape ampersand in PL/SQL Developer
How to find available directory objects on Oracle 11g system?
Oracle.ManagedDataAccess.EntityFramework - ORA-01918: user 'dbo' does not exist
The full pathname of a JDK installation for Oracle SQL Developer
How to count unique rows in Oracle
How to treat MAX() of an empty table as 0 instead of NULL
Oracle PL/SQL string compare issue
What is the major difference between Varchar2 and char
Equivalent function for DATEADD() in Oracle
How to count the number of columns in a table using SQL?
Query a Table's Foreign Key relationships
How to add a not null constraint on column containing null values
Oracle SQL - REGEXP_LIKE contains characters other than a-z or A-Z
java.sql.SQLException: Exhausted Resultset
Oracle: How do I get the sequence number of the row just inserted?
Auto-increment in Oracle without using a trigger
Oracle: How to add 6 months to current date
USE DATABASE command on SQL PLUS ORACLE 11gr1
How do I find out when a stored procedure was last modified or compiled in Oracle?
Can the “IN” operator use LIKE-wildcards (%) in Oracle?
Where can I find a complete list of predefined Oracle pl/SQL Exceptions?
Difference between N'String' vs U'String' literals in Oracle
How to write oracle insert script with one field as CLOB?
ORA-12170: TNS:Connect timeout occurred
Oracle REPLACE() function isn't handling carriage-returns & line-feeds
Sort by day of the week from Monday to Sunday
How to find foreign-key dependencies pointing to one record in Oracle?
Oracle PL/SQL : remove “space characters” from a string
syntax error when declaring variables in a pl/sql procedure
Oracle: How to count null and non-null rows
SQL: How to find duplicates based on two fields?
How can I sort by a table column in varying cases (Oracle)
SQL - how to count unique combination of columns
How to set default value for column of new created table from select statement in 11g
“Specified cast is not valid” when populating DataTable from OracleDataAdapter.Fill()
C#: Oracle Data Type Equivalence with OracleDbType
Compatible SQL to test for not null and not empty strings
IN vs OR of Oracle, which faster?
Oracle error : ORA-00905: Missing keyword
Proving SQL query equivalency
SqlPlus SP2-0734: Error
Is it possible to CONTINUE a loop from an exception?
How to show comments of a column with desc operation
Splitting comma separated string in a PL/SQL stored proc
Show all queries coming to an Oracle database
How to create a blank/empty column with SELECT query in oracle?
Spring Batch ORA-08177: can't serialize access for this transaction when running single job, SERIALIZED isolation level
Aggregate Overlapping Segments to Measure Effective Length
In WiX how do I test for the existence of a registry key (not value) for Oracle ODP.Net
Call an Oracle function from Java
Resolving ORA-4031 “unable to allocate x bytes of shared memory”
How to change the date format from MM/DD/YYYY to YYYY-MM-DD in PL/SQL?
Oracle Add 1 hour in SQL
Oracle sql return true if exists question
Oracle SQL - Sum and group data by week
Ugly formatting in SQL*Plus
MyBatis Batch Insert/Update For Oracle
Finding rows that don't contain numeric data in Oracle
Hibernate sequence on oracle, @GeneratedValue(strategy = GenerationType.AUTO)
Is there an automatic modification time stamp type for Oracle columns?
… where count(col) > 1
Select the minimum of two dates
Insert into from CTE
How to grant “grant create session” privilege?
Trunc date field in mysql like Oracle
Changing the data type of a column in Oracle
Why does Dapper throw an OracleException when i run a query or command with parameters?
Understanding Lob segments (SYS_LOB) in oracle?
Automatically populate date in oracle table
rs.last() gives Invalid operation for forward only resultset : last
SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
create oracle package encountered PLS-00103: Encountered the symbol “CREATE”
Select First Row of Every Group in sql
How to subtract years from sysdate
Oracle: Call stored procedure inside the package
Oracle - grant privileges to all users
How to get Oracle create table statement in SQL*Plus
LISTAGG function with two columns
Query my block size oracle
How to create a DB link between two oracle instances
Add a Column that Represents a Concatenation of Two Other Varchar Columns
Oracle date function for the previous month
How to change settings for SQL Developer to correctly recognize current version of SDK
“Cannot create an instance of OLE DB provider” error as Windows Authentication user
select from one table, insert into another table oracle sql query
How to generate a version 4 (random) UUID on Oracle?
Oracle - Select where field has lowercase characters
Counting null values as unique value
change Oracle user account status from EXPIRE(GRACE) to OPEN
Oracle - Best SELECT statement for getting the difference in minutes between two DateTime columns?
SQL Inner join on select statements
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
What does it mean when the size of a VARCHAR2 in Oracle is declared as 1 byte?
Oracle equivalent to SQL Server DATEPART
how to store date AND time with JPA in Oracle?
PLSQL JDBC: How to get last row ID?
How to compare string in PL/SQL?
Oracle 9 - Resetting Sequence to match the state of the table
How do I resolve this “ORA-01109: database not open” error?
Oracle/PL SQL/SQL null comparison on where clause
How to use “Partition By” or “Max”?
Remove Duplicates from LEFT OUTER JOIN
Rounding to 2 decimal places in SQL
Why is there a SELECT 1 from table?
Disable and later enable all table indexes in Oracle
Cannot call oracle stored procedure and function
Find Size of a Database in Oracle
what is the maximum value of MAXVALUE in sequence in oracle?
Oracle PL/SQL - tips for immediate output / console printing
Oracle considers empty strings to be NULL while SQL Server does not - how is this best handled?
How to re-raise pl/sql exception in exception handling block?
Strange random behavior in where clause
Difference between NVARCHAR in Oracle and SQL Server?
Oracle merge constants into single table
(Oracle) How get total number of results when using a pagination query?
PreparedStatement and setTimestamp in oracle jdbc
Will Oracle optimizer use multiple Hints in the same SELECT?
Issues calling stored procedure from C# with large CLOB
PL/SQL Logging - How to control?
SQL group by date (hour)
How can I get just the first row in a result set AFTER ordering?
JDBC returning empty result set
Need to count records and group count by date on oracle db using sql developer
“ORA-28001: the password has expired” not fixable
How do I use Group By based on a Case statement in Oracle?
Why is no_data_found ORA-01403 an exception in Oracle?
How to escape <, >, and & characters to html entities in Oracle PL/SQL
How to SELECT from object type column in Oracle 11g?
How to use a table type in a SELECT FROM statement?
How to SELECT Column, * FROM TABLE in Oracle?
Is there a way to give a subquery an alias in Oracle 11g SQL?
WHERE_IN query with a composite key?
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
Is there any way to use a strftime-like function for dates before 1900 in Python?
Is it possible to perform a bitwise group function?
Conditions (like “like”) on binary field (blob) in oracle
Is there something like “if not exist create sequence …” in Oracle SQL?
Get the name of the calling procedure or function in Oracle PL/SQL
Delete all records except the most recent one?
Getting seconds between two Oracle Timestamps
Spring JDBC support and large dataset
SQL/Oracle: when indexes on multiple columns can be used
ORA-00900: invalid SQL statement- when run a procedure in oracle 10g
Oracle SQL: Understanding the behavior of SYS_GUID() when present in an inline view?
Query to order by the last three characters of a column
Why no output when PLSQL Anonymous block completes?
Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?
How to call an Oracle function from Hibernate with a return parameter?
Oracle data-source configuration for Spring
Old SQL History in Oracle SQL Developer
SQL Oracle Sort string (numbers) and (letters with numbers)
Find the length of the longest row in a column in oracle
Determine if Oracle date is on a weekend?
Oracle doesn't remove cursors after closing result set
Find out name of PL/SQL procedure
Meaning of PLSQL symbol “=>”
PLSQL - Drop all database objects of a user
How to average time intervals?
How to find maximum avg
Capitalization of Person names in programming
How to specify @lock timeout in spring data jpa query?
Parser for Oracle SQL
java.sql.SQLException: Could not commit with auto-commit set on at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:4443)
Creating or simulating two dimensional arrays in PL/SQL
How to select top five or 'N' rows in Oracle 11g
ORA-06508: PL/SQL: could not find program unit being called
Can you have an INNER JOIN without the ON keyword?
What are the best workarounds for known problems with Hibernate's schema validation of floating point columns when using Oracle 10g?
Extract data from XML Clob using SQL from Oracle Database
Difference between count(1) and count(*) in oracle
How to return oracle output parameters from a stored procedure in .NET
Is it against license to publish Oracle and SQL Server performance test?
Overall summary with multiple GROUP BY
Is there a generic workaround to express a derived column list in Oracle (and MySQL)?
Entity Framework and multiple schemas
Your project references the latest version of Entity Framework… - Error
How do I check the NLS_LANG of the client?
SQLPlus settings to generate tab-separated data file
Oracle Convert Seconds to Hours:Minutes:Seconds
Invalid common user or role name
difference between ON Clause and using clause in sql
SQL Plus change current directory
Speed up bulk insert operations with NHibernate
Best way to shorten UTF8 string based on byte length
Do DDL statements always give you an implicit commit, or can you get an implicit rollback?
ORA-00988: missing or invalid password(s)
How do I find the definition of a named constraint in Oracle?
Connection cannot be cast to oracle.jdbc.OracleConnection
Java JDBC - How to connect to Oracle using tnsnames.ora
Oracle insert if row does not exist
Oracle 10g - optimize WHERE IS NOT NULL
how to convert a string date to date format in oracle10g
SQL join subquery
oracle call stored procedure inside select
Oracle SQL — insert multiple rows into a table with one statement?
How to manually initialize a collection of RECORDs in PL/SQL?
Displaying RowID in Select * (all) Statement
How to SELECT INTO array of Numbers in Oracle PL/SQL?
How to connect to Oracle 11g database remotely
How to find which version of Oracle is installed on a Linux server (In terminal)
ORA-00907: missing right parenthesis
How can I tell if my Oracle system is set to support Unicode or multibyte characters?
OracleParameter and IN Clause
Convert interval to minutes
How to find locked rows in Oracle
MySQL equivalent of Oracle's SEQUENCE.NEXTVAL
Is there a way to get the row number in Mysql like the rownum in oracle
In oracle, how do I change my session to display UTF8?
Conditional unique constraint in oracle db
Optimizing Oracle CONNECT BY when used with WHERE clause
Get column value length, not column max length of value
How to resolve ORA 00936 Missing Expression Error?
Using Dapper with Oracle stored procedures which return cursors
what does the “2”mean in SQL*Plus?
Why doesn't Oracle raise “ORA-00918: column ambiguously defined” for this query?
How to troubleshoot ORA-02049 and lock problems in general with Oracle
Cannot Insert Unicode Using cx-Oracle
How to convert CLOB to VARCHAR2 inside oracle pl/sql
Troubleshoot Oracle - hung process
Is there an Oracle equivalent to SQL Server's OUTPUT INSERTED.*?
How can I tell whether Java is Sun / Oracle / OpenJDK?
Pivoting of data using two columns
Oracle : how to subtract two dates and get minutes of the result
Get top results for each group (in Oracle)
Oracle SQL order by in subquery problems!
query to get the difference between total number of rows and distinct rows
How to use a dynamic parameter in a IN clause of a JPA named query?
Dynamic pivot in oracle sql
Oracle SQL - How to Retrieve highest 5 values of a column
Making a sha1-hash of a row in Oracle
How to return today's date to a variable in Oracle
Convert 24 Hour time to 12 Hour plus AM/PM indication Oracle SQL
How to check if a database object in Oracle is a table or view
Set default schema = SOMETHING in oracle using Spring Boot and Spring JDBC
Check When MY Oracle Password Expires
Oracle SQL pivot query
Oracle setting per user default scheme (not altering a session)
Using SQL query to determine if a table exists
How To Check for an Index in Oracle
How to constrain a database table so only one row can have a particular value in a column?
Creating a table from a query using a different tablespace (Oracle SQL)
Add Day to Timestamp
SELECT DISTINCT CLOB_COLUMN FROM TABLE;
Check for a substring in a string in Oracle without LIKE
Any performance impact in Oracle for using LIKE 'string' vs = 'string'?
Select latest row for each group from oracle
Oracle DB & SQL Developer: “Error report: execution completed with warning” - How do I *see* the warning?
ORA-12704: character set mismatch
Base 36 to Base 10 conversion using SQL only
EXCEPT keyword in Oracle
Connect to Oracle database using SQLALCHEMY
Setting Network Timeout for JDBC connection
How to use the 'as' keyword to alias a table in Oracle?
Oracle: How to filter by date and time in a where clause
How to insert/update larger size of data in the Oracle tables?
where is the Oracle Event Log located?
How to parse comma delimited string in PL/SQL?
Search a JSON array in Oracle
Find out the default value for a column (Oracle)
Hibernate could not fetch the SequenceInformation from the database
Oracle sequence nextval and currval confusing
How to use MAX() on a subquery result?
Batch multiple select statements when calling Oracle from ADO.NET
Delete with Left Join in Oracle 10g
ORA-24408: could not generate unique server group name
ORA-02303: cannot drop or replace a type with type or table dependents
Split comma separated values to columns in Oracle
ALTER TABLE syntax - missing DIRECTORY keyword
Create a Sequence with START WITH from Query
Why does Oracle varchar2 have a mandatory size as a definition parameter?
Oracle date format picture ends before converting entire input string
How to search new line char in oracle table?
How to get the last executed SQL statement and bind variable values in oracle
How to convert Rows to Columns in Oracle?
How can I do a batch insert into an Oracle database using Python?
oracle systimestamp (sysdate) to milliseconds
Trying to connect internally to Oracle, getting an idle instance?
For loop in Oracle SQL
How to escape single quote in sql which is causing' quoted string not properly terminated '?
What are materialized views?
Fix ORA-02273: this unique/primary key is referenced by some foreign keys
how to use a variable in oracle script for the table name
Drop all tables sql developer
Execution order of conditions in SQL 'where' clause
Oracle SQL Developer Problem initializing Welcome Page
Oracle SQL: converting timestamp to UTC
SQL Error: ORA-02298: cannot validate (SYSTEM.AEROPUERTO_FK) - parent keys not found
What is the meaning of '@' symbol in Oracle SQL?
Remove last character from string in sql plus
Conditional unique constraint with multiple fields in oracle db
ORA-00947 Not enough values while declaring type globally
How to obtain the list of Oracle's SIDs
Sql Order by on multiple column
Managing error handling while running sqlplus from shell scripts
“local collection types not allowed” error in PL/SQL ORA-06550
how to print out the definition of a procedure in Oracle?
Representing IPv4/IPv6 addresses in Oracle
How To Handle Table Column Named With Reserved Sql Keyword?
When doing a MERGE in Oracle SQL, how can I update rows that aren't matched in the SOURCE?
Oracle - update join - non key-preserved table
How do I print out a Christmas tree with SQL?
How to extract table definitions using SQL or Toad
Inserting Image Into BLOB Oracle 10g
Displaying the hex value of a string from a oracle varchar2?
Oracle SQL - change decimal dot for a comma
Using NVL for multiple columns - Oracle SQL
How to retrieve all recursive children of parent row in Oracle SQL?
Unable to log in to database as SYS with Oracle SQL Developer
Create index on existing table Oracle
Oracle SQL GROUP BY “not a GROUP BY expression” help
oracle error, column not allowed here
java persistence native sql not accepting parameters
Is it possible to kill a single query in oracle without killing the session?
Spring JDBC Could not load JDBC driver class [oracle.jdbc.driver.OracleDriver]
Query featuring outer joins behaves differently in Oracle 12c
bulk insert from Java into Oracle
Get execution time of sql script in oracle sqlplus
DROP all tables starting with “EXT_” in Oracle SQL
Query the two cities in STATION with the shortest and longest CITY names,
Oracle connection string without tnsnames.ora file
Removing zeros from number
Timestamp conversion in Oracle for YYYY-MM-DD HH:MM:SS format
Select Nth Row From A Table In Oracle
C# Oracle Stored Procedure Parameter Order
How to query the permissions on an Oracle directory?
Oracle get previous day records
Function returning boolean fails on “expression is of wrong type”
Custom order in Oracle PL/SQL
Oracle get records updated in last one hour
How can I tell if I have uncommitted work in an Oracle transaction?
How to replace a character from a String in SQL?
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following: ;
Oracle current_date or sysdate without hours, minutes, seconds
How to get the generated id from an inserted row using ExecuteScalar?
How to trunc a date to seconds in Oracle
Is there any hash function in PL/SQL?
Use a calculated field in the where clause
What is the best way to search the Long datatype within an Oracle database?
Oracle order by descending with NULL last
Oracle - How do I get the actual size of a specific ROW?
How can I use a collection within an Oracle SQL statement
Oracle ORA-12154: TNS: Could not resolve service name Error?
Why does CONNECT BY LEVEL on a table return extra rows?
Correct way to give users access to additional schemas in Oracle
How to get string after character oracle
How to convert XMLTYPE in VARCHAR in ORACLE?
SELECT SUM returns a row when there are no records
ResultSet - Cursor : rs.next() Taking lot of time
Oracle — WITH CLAUSE => MERGE? (Syntax error, )
Appending strings in Oracle within a plsql loop
Ignoring exception in oracle trigger
How to check whether Oracle instance is started using pfile or spfile?
Generate Upper and Lowercase Alphanumeric Random String in Oracle
How can I check SQL syntax for a JDBC statement without running the actual query?
Using distinct on a column and doing order by on another column gives an error
PL/SQL: Selecting from a table into an assoc array
Oracle: copy row while updating one field
Display contents of Oracle AQ SYS.AQ$_JMS_TEXT_MESSAGE
Best way to handle LOBs in Oracle distributed databases
Is there any logical reason of having different tablespace for indexes?
Convert timestamp/date time from UTC to EST Oracle SQL
How can I enumerate the list of privileges granted to an Oracle role?
How to find parameters in Oracle query received from v$sql?
Creating a logging handler to connect to Oracle?
Merging two rows to one while replacing null values
How to truncate all user tables?
Unit test MyBatis with HSQL instead of Oracle
Oracle SQL: How to use more than 1000 items inside an IN clause
Oracle JInitiator version too low
django how to see sql query when running tests?
Oracle: Display row number with 'order by' clause
What is wrong with Cursors?
When does Oracle index null column values?
How to test connection to Oracle Database using Java
Oracle get column data size
Unable to connect to oracle via Pentaho. 'oracle.jdbc.driver.OracleDriver' could not be found
CHECK CONSTRAINT of string to contain only digits. (Oracle SQL)
Is there a way to view relationships in Oracle SQL Developer?
Oracle: create temporary table by a SELECT statement
Using substr to trim string on Oracle
EXTRACT() Hour in 24 Hour format
Foreign keys in alternate schemas with Oracle?
Filter “text” column on all_views
Oracle 10g: Extract data (select) from XML (CLOB Type)
Oracle's default DATE format
SELECT data from another schema in oracle
Oracle RAC and sequences
SQL for Oracle to check if a constraint exists
How to display date in a different format in oracle
ORACLE Casting DATE to TIMESTAMP WITH TIME ZONE WITH OFFSET
output of two different queries as one result in oracle SQL
PL/SQL: is there an instruction to completely stop the script execution?
“date” as a column name
Oracle random row from table
Oracle select most recent date record
Joining tables with LIKE (SQL)
When designing databases, what is the preferred way to store multiple true / false values?
Getting overflow error when executing pl/sql query
Stack conditions in CASE statement in PL/SQL
Swapping column values in Oracle
How to check if an array contains a particular string?
Trigger for only changed values
How to drop more than one constraint at once (Oracle, SQL)
Oracle :Compare dates only by the Hour
How to send arbitrary parameters to Oracle trigger?
How to Get all table space name, Allocated size, Free size, Capacity from single query?
How to set numwidth in the grid output of PL/SQL developer?
Oracle SQL Developer 3.1.07 extra spaces between characters using listagg
Enclosing column names within double quoatation marks with CREATE command in Oracle doesn't work properly. Why?
How to call a stored procedure in JDBC
Finding the longest streak of wins
Select into a temporary table in Oracle
Oracle - return multiple counts as one query
If statement within Where clause
How do I get SQL*Plus to create views / tables with a blank line in the middle of the create statement?
Using a subquery instead of a table name in an Oracle Update Statement
Spring Boot Actuator /health endpoint does not show database or file system information
How to rename a primary key in Oracle such that it can be reused
Using Dapper with Oracle
Convert String ISO-8601 date to oracle's timestamp datatype
Why does Hibernate throw org.hibernate.exception.LockAcquisitionException?
How to SELECT in Oracle using a DBLINK located in a different schema?
Why is this check for null associative array in PL/SQL failing?
Oracle 11g: Unpivot multiple columns and include column name
Mutating Table in Oracle 11 caused by a function
Exporting a CLOB to a text file using Oracle SQL Developer
EntityManager.createNativeQuery returning list of objects instead of list of BigDecimal when using Pagination
How does one do a SQL select over multiple partitions?
Default value for paramteters not passed SQLPlus script
is setautocommit(true) needed after conn.commit()
How to create and use temporary table in oracle stored procedure?
Alter a nonunique index to a unique index
Oracle INSTR replacement in SQLite
PreparedStatement , CallableStatement and Performance Considerations
How to catch DB errors and translate them into meaningful information for the business layer?
What is wrong with this PL/SQL? Bind Variable * is NOT DECLARED
Valid GROUP BY query doesn't work when combined with INSERT INTO on Oracle
Missing artifact com.oracle:ojdbc7 in eclipse
How to avoid two different threads read the same rows from DB (Hibernate and Oracle 10g)
How to make dbms_metadata.get_ddl more pretty/useful
Counting number of SELECTED rows in Oracle with PHP
SQL query for extracting year from a date
MyBatis Insert List values
Why use a JOIN clause versus a WHERE condition?
Why is the GETDATE() an invalid identifier
Oracle SQL — find the values NOT in a table
Oracle - drop multiple table in a single query
How to get first and last day of week in Oracle?
Rewrite left outer join involving multiple tables from Informix to Oracle
if(condition, then, else) in Oracle
Oracle. How to output date and time?
Using Tables of Records in PL/SQL
Invalid Oracle URL specified: OracleDataSource.makeURL
Entity Framework Core - Take(1), Single(), First()… Not Working with Oracle Provider (ORA-00933: SQL command not properly ended)
How to view the original script of a materialized view?
How to select columns with an even ID number in SQL?
Hibernate on Oracle: mapping String property to CLOB column
Always show decimal places in SQL?
Defining a Character Set for a column For oracle database tables
Selecting a count into a variable in oracle
Oracle Insert via Select from multiple tables where one table may not have a row
Table is mutating, trigger/function may not see it (stopping an average grade from dropping below 2.5)
Oracle SYS_GUID does not change
how to printf in oracle stored procedure (for debugging purposes)?
Does Oracle have a filtered index concept?
How to find tables having foreign key to a table in Oracle?
adding primary key to sql view
is there a PRODUCT function like there is a SUM function in Oracle SQL?
How to define global variable in PL/SQL in Oracle?
Handle NULL values when reading through OracleDataReader?
ORACLE: Updating multiple columns at once
Is it safe to put an index on an Oracle Temporary Table?
Oracle SQL - Add Primary Key to table
cx_Oracle: How can I receive each row as a dictionary?
oracle sql query question(grouping by 2 columns)
Why isn't index used for this query?
Creating an Oracle User if it doesn't already exist
True length of a String, as seen by Oracle
JPA: java.lang.IllegalArgumentException: Not an entity
Oracle - drop table constraints without dropping tables
How to replace single-quote with double-quote in sql query - oracle 10g?
Concatenate results from a SQL query in Oracle
ODP.Net Driver Throwing Exception on .NET Core 5.0
libclntsh.so.12.1 : cannot open shared object file error when running sample of node-oracledb
Oracle Convert TIMESTAMP with Timezone to DATE
exp command accepts host and port to export remote DB tables
Oracle composite primary key / foreign key question
Get last ID on inserted row in Oracle DB
How To Declare Input-Output Parameters In SQL Server Stored Procedure/Function?
How can I list all tables existent in a Database Link (Oracle)?
SQL Developer error Unable to find Java Virtual Machine
Problem with execute procedure in PL/SQL Developer
PL/SQL bulk collect into associative array with sparse key
Migrating Oracle DATE columns to TIMESTAMP with timezone
PhpStorm unable to resolve column for multiple database connections
Update query if statement for Oracle
Is ora_hash deterministic?
Get list of table names in different schema of an Oracle database
Is there way to give user-friendly error message on constraint violation
JDBC Oracle - Fetch explain plan for query
Table-Valued Functions in ORACLE 11g ? ( parameterized views )
How to Run the Procedure?
Oracle: How to do multiple counts with different where clauses the best way?
List the contents of Oracle export dump file
How to compare two DATE values based only on date part in Oracle?
Insert default value when null is inserted
Selecting all rows until first occurrence of given value
DESCRIBE via database link?
How to use date variable in sql developer's “Enter Binds” dialog?
Inserting values into tables Oracle SQL
oracle query to find priveleges on a stored procedure
Create Materialized view which refresh records on daily
Exception ORA-08103: object no longer exists on using setfetchsize of Hibernate
Oracle sql merge to insert and delete but not update
Oracle Insert Into NVarchar2(4000) does not allow 4000 characters?
“ORA-00903: invalid table name” error while updating a record
Non-negligible execution plan difference with Oracle when using jdbc Timestamp or Date
Optimising a SELECT query that runs slow on Oracle which runs quickly on SQL Server
Oracle CLOB can't insert beyond 4000 character?
Opposite of INTERSECT in Oracle
Oracle SQL - can I return the “before” state of a column value
Difference between table access by index rowid BATCHED and table access by index rowid
Extract time part from TimeStamp column in ORACLE
How to create a table inside of a procedure in Oracle?
Display Dynamic EXECUTE Output Within pl/sql From sqlplus
Doctor scheduling database design
Oracle Pro*C/OCI install handlers for SIGSEGV/SIGABRT and friends - why, and how to disable?
Hibernate, id, oracle, sequence
What and when should I specify setFetchSize()?
Oracle <> , != , ^= operators
Handling Null in Greatest function in Oracle
Oracle database is hanging infinitly in UPDATE queries
Decode function in oracle database
How widely used are Oracle objects?
Check if table exists in the database - PL SQL
Frequent error in Oracle ORA-04068: existing state of packages has been discarded
Convert timestamp datatype into unix timestamp Oracle
How to get second largest or third largest entry from a table
Granting Rights on Stored Procedure to another user of Oracle
Select all records in which at least n-1 of n criteria has been matched
oracle convert unix epoch time to date
oracle 12c - select string after last occurrence of a character
How to fix deprecated oracle.sql.ArrayDescriptor, oracle.sql.STRUCT and oracle.sql.StructDescriptor
Recovering deleted rows from oracle table
How do I force Django to connect to Oracle using Service Name
How to check if cursor returns any records in oracle?
Displaying the constraints in a table
Oracle cursor running through the last item twice
For each string, execute a function/procedure
Why does running this query with EXECUTE IMMEDIATE cause it to fail?
Left outer join on two columns performance issue
Alter table after keyword in Oracle
How to get information about a User-Defined Type?
How to show indexes in Oracle SQL
Delete from two tables with circular foreign keys
Is it possible to use “return” in stored procedure?
dropping a global temporary table
Quickest query to check for the existence of a row in Oracle?
SELECT COUNT(*) vs. fetching twice with an explicit cursor
ORA-06502: PL/SQL: numeric or value error: character string buffer too small exception from C# code
SQL Group By - counting records per month/year, error on insert - NOT A VALID MONTH
SQL Results group by month
Oracle Database import .sql file by command prompt
SQL ignore case in group by? (oracle)
Selecting Values from Oracle Table Variable / Array?
Getting Oracle's MD5 to match PHP's MD5
How to prettify the output coming from the SELECT query in command prompt?
Oracle number to C# decimal
Script to run other scripts in sqldeveloper
Ways to create a procedure with optional parameters?
INSERT INTO using a query, and add a default value
SQL*Plus does not execute SQL scripts that SQL Developer does
Group by values that are in sequence
Why does Oracle think I'm missing a right parenthesis?
LAST_NUMBER on oracle sequence
How to sort by numbers first with Oracle SQL query?
What object type does Spring Hibernate Template execute method return for a counting query on Oracle?
Discover what process/query is using oracle temp tablespace
Oracle SQL — Analytic functions OVER a group?
Matching a group that may or may not exist
Setting Oracle 11g Session Timeout
SQL - Multiple Values comma separated when using GROUP BY
Last_value window function doesn't work properly
Oracle DELETE statement with subquery factoring
Query to find an average weighted price
Oracle SQL Developer: how to view results from a ref cursor?
ORA-00917: missing comma error
Python module “cx_Oracle” module could not be found
Oracle Merge vs Select then Insert or Update
measure time of an sql statement in a procedure in plsql
How to connect an Oracle database from PHP
Granting “Create Directory” Privileges in Oracle
Oracle EXECUTE IMMEDIATE with variable number of binds possible?
Increasing precision or scale of number column in Oracle
Add a sequence number for each element in a group using an Oracle SQL query
Querying datetime in oracle
GROUP BY combined with ORDER BY
How to connect an Oracle Database to Mathematica?
SPOOL returns empty files when trying to export from SQL Developer
What does PARTITION BY 1 mean?
Executing a dynamic sql statement into a SYS_REFCURSOR
How can I speed up row_number in Oracle?
UPDATE statement in Oracle using SQL or PL/SQL to update first duplicate row ONLY
How can I query a null in a Long value without getting “Expected NUMBER but got BINARY” from OracleDB?
How to efficiently convert text to number in Oracle PL/SQL with non-default NLS_NUMERIC_CHARACTERS?
Oracle syntax - should we have to choose between the old and the new?
Java type for date/time when using Oracle Date with Hibernate
Why do I get #### in the NUMBER column after format?
Query executes slower after indexes are created and dbms_stats compute is used
Set database connection timeout in Python
ORA-32795: cannot insert into a generated always identity column
C# NHibernate & Oracle Managed Client
“SET FOREIGN_KEY_CHECKS = 0;” Oracle Equivalent
Oracle SQL Syntax - Check multiple columns for IS NOT NULL
Is it possible to partially refresh a materialized view in Oracle?
when should I go for procedure or function in PL/SQL?
How can I extract files from an Oracle BLOB field?
Truncate date to fiscal year
How can I implement conditional updating in Oracle?
Max column width in Oracle spool to file
How to change default nls_date_format for oracle jdbc client
Oracle JDBC batchUpdate rows affected is always -2 (Statement.SUCCESS_NO_INFO)
How to connect to Oracle in go
How to get generated keys from JDBC batch insert in Oracle?
Listagg function and ORA-01489: result of string concatenation is too long
In the Oracle JDBC driver, what happens to the time zone when you write a Java date to a TIMESTAMP column?
How to use Oracle as an embedded database for running unit tests in maven?
set serveroutput on in oracle procedure
SQL “not a valid month”
Can I execute a procedure with default null parameters?
Using Oracle Service Names with SQLAlchemy
Using date in a check constraint, Oracle
PLSQL generate random integer
Subtract one hour from datetime rather than one day
How to find number of rows in cursor
How can I count only NULL values in Oracle/PLSQL?
Number of days in a month
Oracle 10g: column is blank, but is not null or an empty string
How to Connect Airflow to oracle database
Oracle/SQL: Why does query “SELECT * FROM records WHERE rownum >= 5 AND rownum <= 10” - return zero rows
How to insert 1 million random row into table database Oracle
Why is Select 1 faster than Select count(*)?
Creating materialized view that refreshes every 5 min
SQL to have one specific record at the top, all others below
How to change datatype of column with data
how to select the most frequently appearing values?
dbms_output cannot print boolean?
How to change Oracle default data pump directory to import dumpfile?
Fetch MULTIPLE ROWS and STORE in 1 VARIABLE - ORACLE STORED PROCEDURE
Using IF ELSE in Oracle
DatabaseError: ORA-00911: invalid character
insert string which includes quotes in oracle
Oracle get substring before a space
ASP.NET / Oracle issue: TNS Could not resolve the connect identifier specified
How do I create Oracle Type which refers to table columns for data type?
how to convert csv to table in oracle
Oracle connection compression?
Inserting new columns in the middle of a table?
How can I determine string value of Oracle's datatype by its code?
Read all parameters from SYS_CONTEXT/USERENV
More than one table found in namespace (, ) - SchemaExtractionException
Use Oracle PL/SQL For Loop to iterate through comma delimited string
JPA Null or zero primary key encountered in unit of work clone
Oracle : Grant Create table in another schema?
pl sql %NOTFOUND
How to compare two tables column by column in oracle
Copying data between Oracle schemas using SQL
How can I mock/fake/stub sealed OracleException with no public constructor?
How to convert date to datetime in Oracle?
How to update Oracle Timestamp value from the current to a timestamp from the past
Use of boolean in PL/SQL
oracle faster paging query
what jdbc jar to use with oracle 11g & jdk 1.6 and how to connect to the db itself
Is an index clustered or unclustered in Oracle?
Oracle SQL - How do I repeat a character based on a value in a column
In Oracle SQL, can I query a partition of a table instead of an entire table to make it run faster?
What is the purpose of logging/nologging option in Oracle
How do I change the SRID's for Oracle SDO_GEOMETRY
Oracle 'INSERT ALL' ignore duplicates
How to create unique index on fields with possible null values (Oracle 11g)?
Sqlplus oracle : How can I run sql command on bash in 1 line?
Oracle get foreign keys
is it possible to update an existing row in DB, using liquibase?
Inserting system date in oracle
Is it possible for Oracle sqlldr to accept a TNS entry as an instance qualifier in Oracle 10 and 11?
How can I append/concatenate BLOB data to a BLOB column using SQL UPDATE command in ORACLE
Simple constraint to limit an Oracle table to a single row
Calling an Oracle stored procedure in Squirrel SQL
Insert blob in oracle database with C#
The fastest way to check if some records in a database table?
Fill null values with last non-null amount - Oracle SQL
How to correctly make a public synonym
Table Variables in Oracle PL/SQL?
Oracle get stored procedure last modified date
How to view Oracle table column character set?
Oracle SQL: How do I find the table name given the column names?
Oracle DB equivalent of on duplicate key update
How to optimize an update SQL that runs on a Oracle table with 700M rows
Executing an Oracle Stored Proc as Another User
Oracle: excluding updates of one column for firing a trigger
how to declare multiple variables in one line in oracle plsql block
SQL: AVG with NULL Values
Oracle SQL: variables used in place of table names
How can I check if a procedure exists in a package?
Oracle client and networking components were not found
How to check column is virtual in Oracle?
How to solve ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY
Index on which tablespace
How can I return multiple identical rows based on a quantity field in the row itself?
Oracle query is slow (or fails) from .NET app but is fast from SQL Developer
How to see contents of Check Constraint on Oracle
Is there a method in PL/SQL to convert/encode text to XML compliant text?
Compare Strings ignoring accents in SQL (ORACLE)
Oracle ManagedDataAccess - Connection Request Timed out - Pooling
SQL: Get records created in time range for specific dates
Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?
Is it possible to compare tuples in oracle-compatible sql?
How do I limit the number of rows returned by this LEFT JOIN to one?
SQL statement joining Oracle and MS SQL Server
run oracle sql script from java
Adding foreign keys error: ORA-02298: cannot validate - parent keys not found
ORA-0131 :insufficient privileges DEBUG CONNECT SESSION
OracleConnection.Open is throwing ORA-12541 TNS no listener
better way of using a single parameter multiple times in c#
Oracle Date format exception in SQL Server Reporting Services
Reference to uninitialized collection PL/SQL
How to use GROUP BY on a CLOB column with Oracle?
How to reorder items in a table
Oracle update query with select
Using an Oracle Table Type in IN-clause - compile fails
SQL: Is it possible to 'group by' according to 'like' function's results?
Cannot connect my rails app to Oracle
What type of join is '…where A.ID = B.ID (+)'
Oracle Alter command to rename existing Column errorring
How to insert conditionally in Oracle?
How to debug a pipelined function in PL/SQL Developer?
Get Oracle View Definition with limited control
Oracle: What permissions do I need to grant on a sequence?
Left Join that always includes null records
How to create a tablespace with multiple datafiles?
How to do a like case-insensitive and accent insensitive in Oracle 10gR2 and JPA?
SQL Query to Count() multiple tables
How to limit the results to 1 row in Oracle SQL
ORA-12154 error trying to connect using ODP .NET
PL/SQL: Error “PLS-00306: wrong number or types of arguments in call to” triggered for table of numbers
Parameterizing a raw Oracle SQL query in Entity Framework
How can I convert Oracle VARCHAR2 values to UTF-8 from a list of possible encodings?
How to get part of the string that matched with regular expression in Oracle SQL
truncated LISTAGG string
LISTAGG equivalent with windowing clause
Oracle on Alpine linux
how to select only row with max sequence without using a subquery?
Are Oracle PL/SQL arrays indexed from 0 or from 1?
Suppress PHP warnings for expected Oracle exceptions
Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
Do any databases allow multiple indexes on the same table to be created simultaneously?
java.util.Timestamp.after() wrong when comparing milliseconds?
Testing the Oracle to_date function
pull access denied for container-registry.oracle.com/database/enterprise
Database Design: replace a boolean column with a timestamp column?
Two foreign keys instead of primary
How to iterate over a date range in PL/SQL
How ROWNUM works in pagination query?
SQL: if cannot convert to_number set as null
How do you move a partitioned table from one tablespace to another in Oracle 11g?
Oracle - how to remove white spaces?
How to check if all fields are unique in Oracle?
java getting SQL next sequence number of the record before insertion
Oracle sql null value is not selected
Column count based on a condition
Oracle: getting maximum value of a group?
TNS Protocol adapter error while starting Oracle SQL*Plus
How do I close an OracleConnection in .NET
Number of columns
Oracle: How to select current date (Today) before midnight?
How to check Oracle patches are installed?
Oracle Database connection via SQLPLUS
SQL Command not properly ended?
Is there an MD5 Sum function in PL/SQL
What Situations Cause Oracle Packages to Become Invalid?
Oracle use LIKE '%' on DATE
How to retrieve two columns data in A,B format in Oracle
Select the first 150 rows, then the next 150 and so on?
How do I inspectdb 1 table from database which Contains 1000 tables
convert blob to clob
Manually forward a sequence - oracle sql
Oracle Syntax for Creating Database Link Owned by Another User
How to get a list of months between 2 given dates using a query?
Generating DDL script for object without schema name baked in using DBMS_METADATA.GET_DDL?
How to run sql scripts from a pl sql procedure
Oracle Unique Constraint with Expression
Oracle debugging techniques
Oracle Julian day of year
issue ORA-00001: unique constraint violated coming in INSERT/UPDATE
What is correct JDBC URL syntax if Oracle wallets are used?
What's the created Date-time for Table row in Oracle?
Column Name beginning with a number?
Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
Oracle: Combine multiple results in a subquery into a single comma-separated value
oracle procedure returns integer
Missing artifact com.oracle:ojdbc14:jar:10.2.0.1.0
How to replace ' or any special character in when using XMLELEMENT Oracle
If field is null, pull certain fields; otherwise, pull other fields
suppressing messages while running sql queries in a script
Obtain stored procedure metadata for a procedure within an Oracle package using ADO.NET
Oracle jdbc “createArray” throws “Unsupported feature” exception while trying to pass array to prepared statement
Conditional SUM on oracle SQL
oracle sql query for records with timestamp that falls between two timestamps
Oracle - SQL - insert into with sub select
Oracle + dbunit gets AmbiguousTableNameException
Selecting all columns and constant value from Oracle table
Joining tables based on the maximum value
How to store selection result in to variable in Oracle procedure
How to get all tables that have FKs to another table?
Cursor for loop in Oracle
SQL Loader Error: “Variable length field exceeds maximum length.”
Transform SQL Rows into Comma-Separated values in Oracle
How to sync and optimize an Oracle Text index?
how to replace multiple strings together in Oracle
2PL, Rigorous vs Strict Model, Is there any benefit?
oracle rollup function with multiple columns
How to force oracle to not to use an index
Binding Parameters to Oracle Dynamic SQL
Oracle: Possible to return nothing from PL/SQL function?
HSQLDB ROWNUM compatibility with Oracle
What is the syntax to define an Oracle procedure within an another stored procedure?
Obtain id of an insert in the same statement
Does making a primary key in multiple columns generate indexes for all of them?
In SQL*Plus, how do I change the prompt to show the connected user and database?
How to configure default database schema for native queries in pure JPA?
How can query last 5 minutes of records?
How to get the last letter of a string?
How to group by with a special condition
Select first result only
How to inline a variable in PL/SQL?
Clear the heading in Oracle spool
How do you add an edit button to each row in a report in Oracle APEX?
Table vs Materialized View
Oracle.DataAccess mismatch error
SQL query to test if string value contains carriage return
how to write Oracle Function For Convert Date to persian (jalali)
Oracle Analytic functions - How to reuse a PARTITION BY clause?
Session based global variable in Postgresql stored procedure?
ORA-12899: value too large for column
How to get the closest dates in Oracle sql
Query to determine if columns combine to create a unique key
Not a single-group group function
HIbernate issue with Oracle Trigger for generating id from a sequence
How do I a convert a number to an INTERVAL of minutes?
Oracle Sql NOT NULL xor NULL?
Inserting multiple rows with sequence in Oracle
Rank function in MySQL with Order By clause
Oracle date to Java date
Oracle: Finding Columns with only null values
Equivalent of MySQL's \G in Oracle's SQL*Plus
How can I find duplicate consecutive values in this table?
How to (unit-)test data intensive PL/SQL application
Oracle query using 'like' on indexed number column, poor performance
How can I estimate the size of an Oracle index?
Why INSERT /*+APPEND*/ is used?
How do I check index building status on Oracle 11?
about Oracle parallel insert performance
What is the correct way to deal with this Oracle ORA-01403: no data found Exception?
Create more than one procedure in a SQL file?
How to use pass an array in PL/SQL function
Easiest method to test an Oracle Stored Procedure
How to write pandas dataframe to oracle database using to_sql?
create synonym ora-01031 insufficient privileges
using expdp backup database
Strange Oracle XMLType.getClobVal() result
Convert VARCHAR2 to TIMESTAMP in Oracle
Why does Oracle return specific sequence if 'orderby' values are identical?
What Java data type corresponds to the Oracle SQL data type NUMERIC?
Hibernate's setFirstResult() issue with Oracle jdbc driver
List of all the User excluding default Users
How to insert data into TABLE type variable
How to solve ORA-29471 on dbms_sql.open_cursor?
What is an “XCopy version”?
Oracle sqlldr timestamp format headache
atomic compare and swap in a database
No usename HR in Oracle 12c
How to get driver class name (not driver name) from jdbc connection
Get correct datetime from Oracle query via ROracle in R
How do I exit a script in SQLPlus when an error occurs and return to the SQLPlus prompt, without disconnecting or exiting SQLPlus?
display select results inside anonymous block
Oracle - Return shortest string value in a set of rows
Fluent NHibernate - how to configure for oracle?
How to cast LONG to VARCHAR2 inline
SQL query challenge
ORA-00942: table or view does not exist : How do I find which table or view it is talking about
UPDATING Table Column with new Entry
Oracle Query to get table list for which the current user has read access
extract a substring from clob in oracle
Oracle CLOB and JPA/Hibernate ORDER BY?
SQL: Oracle - Parameters in query
How can I avoid “raw variable length too long” errors in SQL Developer?
Join elimination not working in Oracle with sub queries
Changed behaviour of java.sql.Date after OJBC client upgrade
oracle sql developer: 00904. 00000 - “%s: invalid identifier”. Where is my fault?
Oracle CONNECT BY clause after GROUP BY clause
Strange behaviour of full outer join in Oracle - how it could be explained?
Is it possible to create Oracle associative array type outside of a package/procedure?
SQL Merge two rows with same ID but different column values (Oracle)
How to establish a OracleConnection without making use of the obsolete OracleConnection Class
Select xpath values as separate rows in Oracle SQL
Can %NOTFOUND return null after a fetch?
How to subtract 2 dates in oracle to get the result in hour and minute
Equivalent to PostgreSQL array() / array_to_string() functions in Oracle 9i
ORA-00972: identifier is too long - Best strategy to avoid it in Grails
What is the syntax to use a Select statement inside a PL/SQL Trigger?
Oracle SQL returns rows in arbitrary fashion when no “order by” clause is used
Get the top row after order by in Oracle Subquery
Getting Last Day of Previous Month in Oracle Function
Error while installing DBD::Oracle
Java / JDBC: Best design pattern to close database connection when exception occurs
select max value of a column in table with no rows
SQL developer error with “disable modules and continue”
How can I format a number as xxx-xx-xxxx?
%Rowtype equivalent in SQL Server
Oracle ojdbc8 126.96.36.199 Forbidden by Maven
Understanding Oracle aliasing - why isn't an alias not recognized in a query unless wrapped in a second query?
Oracle: Get a query to always return exactly one row, even when there's no data to be found
Inserting a string with double quotes into a table
Use a variable with “LIKE %” (e.g. “variable%”) in PL/SQL?
How to extract only date value from date field in Oracle?
Oracle move column to the first position
How to get only one record for each duplicate rows of the id in oracle?
Why Mysql's Group By and Oracle's Group by behaviours are different
How to use Select Exists in Oracle?
ORA 00904 Error:Invalid Identifier
SQL Decode Null Values
Oracle dynamic DESC and ASC in order by
Prevent error when dropping not existing sequences, creating existing users
How to get lat and long from sdo_geometry in oracle
LEFT function in Oracle
How to group by each day in PL/SQL?
How to write a for loop in Oracle sqlplus?
How to activate the hr schema in Oracle 11g
True tablespace size in oracle
Oracle NVL with empty string
Detect all columns in an oracle table which have the same value in each row
Oracle BLOB to base64 CLOB
Oracle: Update a datarow by adding to existing value
ODP.NET Connection Pooling Parameters
SELECT SQL Syntax For Count in WHERE clause
Mixing “USING” and “ON” in Oracle ANSI join
listagg data to useable format?
How can I count the number of words in a string in Oracle?
ORA-22275 error: invalid LOB locator specified
Spaces when concatenating multiple columns and one column is null - Oracle
PL/SQL use VARRAY in IN CLAUSE
Oracle: Indexing a subset of rows of a table
Can't connect to Oracle database with SQL Developer (Ora00604 error occurred at recursive level 1 ORA - 12705)
Oracle INSERT into two tables in one query
Confusion with Oracle CONNECT BY
Table function with bulk collection throws invalid datatype
Initialising a pl/sql record type
Concatenate strings in Oracle SQL without a space in between?
Find specific varchar in Oracle Nested Table
Grant Select, Insert, Update to a Tablespace
How to handle optional parameters in SQL query?
how to print out the whole table using anonymous block in pl sql?
Find a Database table's unique constraint
Install Oracle Instant client into Docker container for Python cx_Oracle
How to drop a scheduled job in oracle
When/Why does Oracle adds NaN to a row in a database table
PL/SQL FOR LOOP IMPLICIT CURSOR
XMLAGG with RTRIM issue
how to get count(*) value in local temp variable in dynamic sql (ORACLE PLSQL)
Aggregate function over a given time interval
Number of fridays between two dates
Oracle Date Formatting Null date as 00/00/0000
Why can't I do a “with x as (…)” with ADODB and Oracle?
Query to display all tablespaces in a database and datafiles
Oracle: remove first 4 characters from a string
load multiple csv into one table by SQLLDR
increment row number when value of field changes in Oracle
SQL Developer explain plan broken
Minimum length constraint on a column
Remove newlines in oracle sql
Assign a Select to a variable in a stored procedure
Oracle UPDATE statement using the `REPLACE` function
how to check for not null column constraint in oracle sql?
Oracle EXECUTE IMMEDIATE into a cursor
oracle hibernate + maven dependenciesm dbcp.basicdatasource exception
Can Hibernate automatically uppercase a column on read/insert via configuration?
Oracle Analytic function for min value in grouping
How can I constrain multiple columns to prevent duplicates, but ignore null values?
Case Statement on Multiple conditions in Oracle
How to install tnsping?
How to call a Stored Procedure inside an oracle package with Entity Framework?
Oracle: How can I get a value 'TRUE' or 'FALSE' comparing two NUMBERS in a query?
SQL Populating with distinct data and a sequence
Get last DDL time for Oracle table in different Schema
Using the “IN” clause with a comma delimited string from the output of a replace() function in Oracle SQL
Oracle - Triggers to create a history row on update
How to Execute stored procedure from SQL Plus?
Dump the body of a function or procedure in sqlplus
Sequence within SQL Select
Shift operators in PL/SQL
Query with broken sub-select should result in error but returns rows
Execute multiple queries in single Oracle command in C#
using EXECUTE IMMEDIATE with multiple same bind arguments
How to fix Ora-01427 single-row subquery returns more than one row in select?
.NET / Oracle: How to execute a script with DDL statements programmatically
ALTER statement: Why VARCHAR2(50 BYTE) instead of VARCHAR2(50 CHAR)?
Issue when comparing result of to_char(myDate, 'DAY') to a string
Which data type is used to store DateTime in Oracle 10g?
Duplicating records to fill gap between dates
Oracle Rolling or Running totals by month
oracle raw datatype in where clause
How to determine a PL/SQL function's schema from within the function
how to create a stored procedure in oracle which accepts array of parameters
Insert multiple rows into a table with only one value changing
Oracle SQL: select from table with nested table
Reading data from Oracle DB using .Net is 10 times faster than using Java
SQL Server: how to imitate oracle keep dense_rank query?
Count of 2 distinct columns
Order by case insensitive in oracle
Oracle Sequential actions
convert oracle blob to xml type
oracle improve query performance
Getting SQLPlus to spool out Unicode characters, are being output as?
How do I connect to an Oracle Database in R?
How can I call an Oracle function from Delphi?
Oracle Trigger Updating a field on an Insert or an Update
Set up default “alter session” for an Oracle user
How can I create a table as a select from another database in Oracle?
Where are java classes stored in Oracle?
Joining other tables in oracle tree queries
Getting Numeric overflow error for smaller numbers but success for larger numbers
With Oracle, how can I restore a table that I dropped accidentally?
spring-data-jpa: ORA-01795: maximum number of expressions in a list is 1000
SQL Alternative for 'OR' in where clause when using outer join
Stored procedure error PLS-00201: identifier 'UTL_HTTP' must be declared
Delete statement - Sub Query should throw error
How to restrict the length of INTEGER when creating a table in ORACLE?
java.sql.SQLException: ORA-00928: missing SELECT keyword. when inserting record to DB using JDBC
Behavior of Sequence in Oracle Merge Statements
Is there an aggregate function that could return first non-null value within a group?
Oracle functions' optimiser
odbc instructions to connect to oracle
Oracle locking with SELECT…FOR UPDATE OF
Variables in TOAD scripts
Scenario to allow update based on booking-SQL
Oracle aggregation function to allocate amount
Converting time difference to a given format in Oracle
How to create an oracle.sql.ARRAY object?
Any tools to export the whole Oracle DB as SQL scripts
SQL Count for a Date Column
Oracle - dynamic column name in select statement
Grouping data by name and date ranges
Oracle Data Provider for .NET: Connection request timed out
Can a foreign key reference another foreign key
How do I annotate Id column if value is generated by a trigger?
ORA-12154: TNS:could not resolve the connect identifier specified
How to resolve ORA-27475: “JOB” must be a program or chain
How to reset IDENTITY column in oracle to a new value
Concatenating numbers in virtual column expression throws ORA-12899: value too large for column
Generating large xml files from oracle: Best practices
Oracle alternative for MySQL REPLACE INTO
SQL aggregate function for any non-specific value from a group
Is there an alternative to the MULTISET operator that avoids sub-queries?
How to select the first continuous group of rows using Oracle SQL
Explain Plan for Query in a Stored Procedure
Why Invalid conversion requested ERROR CODE: 17132?
Can SQL*Plus read environment variables from the machine is it running on?
Oracle + JPA - querying with INTERVAL
SQL*Plus - How do you hide SET ECHO OFF?
How can you see what transaction isolation level an arbitrary oracle session is using
Preferred way to add surrogate key to existing Oracle DB table
How do I query LDAP from C# to resolve Oracle TNS hostname while using managed ODP.NET?
Cannot connect to Oracle database with Django on Ubuntu
Parameter.AsString failing under Oracle/MSSQL - Parameter.Value 2-byte chars under Oracle
Primary Key and Unique Index — sql scripts generated by SQL Developer
Collapsible region for PL/SQL Developer
Hyperion Essbase Connection in SSIS
Remove tablespace info from Materialized View DDL
Java Multicast Time To Live is always 0
Execute Subquery refactoring first before any other SQL
Entity Framework ORA-00932: inconsistent datatypes: “'expected CLOB got CHAR”
Invalid Identifier on Sql left join oracle
ORA 7445: Query causing Oracle 12c to crash
Oracle partitioning solution for DELETE performance problem
Update Apex Tabular form with PLSQL
Insert BLOB test string bigger than 2000 or 4000 bytes
Counting the number of occurrences of a character in Oracle SQL
Data from oracle in utf-8 with php
format interval with to_char
Getting Next value from sequence with spring hibernate
Trigger to insert sysdate after an insert in Oracle
ORA-01403: no data found for Select into
Should I use a code in my lookup table
Improve oracle query performance without indexing
Oracle startup not possible - ORA-00845: MEMORY_TARGET not supported on this system - but memory size seems to be fine
Select second most minimum value in Oracle
Pass array from Java to Oracle: java.sql.SQLException: Fail to convert to internal representation:error
Oracle: Fast NOT IN for multiple columns
How will you keep a specific country on top in a drop down list?
Is `Delete From Join` Standard SQL?
Prevent Insert Trigger
Delete all duplicate records from Oracle table except oldest
Simple Oracle SQL date syntax question
Convert datetime field to just a date field in SQL (Oracle)
How to get two return value from Oracle Stored Procedure
Is there a way to force OracleCommand.BindByName to be true by default for ODP.NET?
transaction isolation problem or wrong approach?
ORA-01460: unimplemented or unreasonable conversion requested
Averaging dates in oracle sql
How do I select dates between two given dates in an Oracle query?
select * from table_name where column like ' '
Get column names in order in Oracle DB
Oracle-How to check if max_string_size is standard or extended
Oracle Database. Insert a copy of a row to the same table (Duplicate key error message)
ORACLE SQL get difference of two values retrieved from 2 select statements
plsql/cursors handle exception and return back to the execution flow
Oracle Sql Developer “string literal too long” error
How do I get the return value from a function in Oracle using Toad
Oracle — finding values with leading or trailing spaces
Using Ref Cursor in Oracle SQL Developer
Round up date field to next half hour in SQL
Comparing date with sysdate in oracle
Append to spool file Oracle
if-elseif-else 'condition' in oracle SQL
Unable to 'SELECT INTO' when value doesn't exist
How to populate calendar table in Oracle?
sql join 2 rows in the same table
How to insert an “Optimizer hint” to Hibernate criteria api query
How do you strip leading spaces in Oracle?
Map-like object type in PL/SQL?
conditional order by clause in sql
Drop a table in a procedure
Oracle: insert without columns specification
Cannot serialize the DataTable. DataTable name is not set
Oracle Managed ODP.NET can't find tnsnames.ora
How does 'in' clause works in oracle
How to display a default value when no match found in a query?
Cannot lookup row in database by UUID RAW(32)
Oracle appending string to a select statement
Oracle Create View issue
Getting location of file tnsnames.ora by code
How come sqlplus not connecting?
Oracle PL/SQL Query Order By issue with Distinct
CTE and table update in ORACLE
oracle convert DD-MON-YY to DD/MM/YYYY
Oracle find tablename given an index name
Loop through an explicit cursor in Oracle
oracle date sequence?
How to avoid same subquery in multiple select in oracle?
Inconsistent behavior with `CROSS APPLY` and `OUTER APPLY`
Retrieving identity of most recent insert in Oracle DB 12c
Lookup Error ORA-00932: inconsistent datatypes: expected DATE got NUMBER
Oracle equivalent of Java's Varargs
Execute a pl/sql function with OracleCommand
Getting the value that fired the Oracle trigger
How to dynamically add interval to timestamp?
Optimize the speed on performing “select” query in a big loop
SQL Group By function(column) - Now can't Select that column
SQL How to do a conditional sum by distinct id?
ORACLE PL/SQL: Functions and Optional Parameters, How?
SQL How to convert a decimal to a string
Oracle primary keys: NUMBER vs NUMBER(7,0)
How to check if a trigger is invalid?
Oracle insert failure : not a valid month
Oracle automatic partitioning by day
Why sid required in 'KILL SESSION' (Oracle SQL)?
Operator analogous to += or .= in PL/SQL?
Oracle: search though all stored procs/triggers/other db code?
Creating a trigger to only run when a new table is being created
.nextval JDBC insert problem
How to resolve ORA-00937: not a single-group group function when calculating percentage?
Should every field in an Oracle database have a check constraint if possible?
Oracle CASE with OR
Oracle PL / SQL printing each letter of a string
ALL operator VS Any on an empty query
Get the SQLException java.sql.SQLException: ResultSet.next was not called
Return value from sql script to shell script
How to create new schema and list all schema name in oracle
ORA-06511: PL/SQL Cursor already open
Adding extra column to view, which is not present in table
Repeating rows based on column value in each row
Oracle timestamp difference greater than X hours/days/months
Oracle syntax error
Fastest way to identify differences between two tables?
Oracle Parameters with IN statement?
Bitwise exclusive OR in Oracle
How to find the record that violate unique key constraint?
Oracle SQL CASE WHEN ORA-00932: inconsistent datatypes: expected CHAR got NUMBER 00932. 00000 - “inconsistent datatypes: expected %s got %s”
Setting the Date Format in the SQL*Loader Control File
Cant Map SYS_REFCURSOR in Entity Framework
sqlalchemy oracle scheme
How to create a comment to an oracle database view
How to use Oracle data pump export utility to create dump file in local machine?
Join to an oracle table valued function
How to give the output of the first query(which has two values) as the input to the second?
How to clone user in Oracle
Call Oracle Stored Procedure Using createNativeQuery
mysql function to provide equivalent to Oracle NVL
Simple recursive query in Oracle
Using ROracle dbWriteTable to write POSIXct back to Oracle DB
Compiling a PL/SQL function in Oracle 11g2 XE sometimes leads to a ORA-00600: internal error
PostgreSQL vs Oracle: “compile-time” checking of PL/pgSQL
How can I update data in CLOB fields using a >> prepared query << with ODP (Oracle.DataAccess)?
Running Total by Group SQL (Oracle)
Find duplicate items in a column Oracle SQL
Returning just column names of ResultSet without actually performing the query (Oracle and Java)
Use gv$session to tell if a query is hanging
Oracle unique constraint violation referencing a constraint that doesn't seem to exist
Concatenating collections in PLSQL
Dynamically select the columns to be used in a SELECT statement
How do you get the next value in a sequence into a variable?
How can I speed up queries against huge data warehouse tables with effective-dated data?
Which Oracle table uses a sequence?
Oracle TIMESTAMP WITH TIMEZONE named zone vs offset
Query with values prepended by ampersand - works in Oracle but not in MySQL?
ORA 06533: Subscript beyond count
Whatis is best approach on executing multiple UPDATE statement in one connection?
SELECT as much data from CLOB to VARCHAR2 as possible, with multibyte chars in the data
Oracle select with subquery
Oracle grand total column and row
New Line while inserting into VARCHAR2 column
Conditionally define a Cursor
Using Oracle SQL to generate nested XML
How to find if a sequence exists using PL/SQL
ORACLE - What does STORAGE in an explain plan signify or mean?
how can i find which attribute value only contain one type of value?
Oracle “create table as” null value
Grant all privileges to user on Oracle schema
using sql query with group by date
Get total count of rows in pagination query
Oracle Update and Return a Value
How to parse adjacent list in Oracle 10g?
SQL query to add values of two columns containing null values?
How to change the schema via connection string when connecting to Oracle using Entity Framework?
Is it not possible to check list items in Case Statement's condition?
How do I list all context namespaces in Oracle DB?
oci_bind_by_name and to_date PHP/OCI/Oracle
Implementing optimistic concurrency on a legacy database
CONNECT BY or hierarchical queries in RDBMS other than Oracle
PL/SQL how do I select into table type local variable
CHAR semantics and ORA-01461
Getting index of element in PL/SQL collection
Quick introduction on how to use oracle xml data type
setting Client Info in JDBC for Oracle
Set up Oracle Text to index values of multiple columns in Oracle tables
“ORA-22812: cannot reference nested table column's storage table” when trying to access system table
How to get rid of files with names bin$
How to identify all global temporary tables
Table Does Not Exist while using EF 6 and Oracle.ManagedDataAccess
Finding Data Pump Dump Location in 12c
invalid identifier error in oracle due to column alias
How to determine which version of “Oracle.DataAccess.dll” to include
Oracle SQL — remove partial duplicate from string
Generating dates between two dates
How to get Max id from table of database in java code
Good or bad idea to include numbers in SQL table names?
Groovy domain mapping
calculate running balance in oracle query
Get value based on max of a different column grouped by another column
Oracle Database 12c in VM on Mac OSX
How do i add a column in oracle with Enum values?
Why can't I update more than one column at the same time using With keyword?
How can I export contents of an oracle table to a file?
How to set manually an Oracle Connection String in a DbContext
the best way to track data changes in oracle
How to escape “:” in Oracle dynamic SQL and also have bind variables?
Any solution for Oracle TNS inefficiencies (many roundtrips, latency) from a Java app?
C#: Pass a user-defined type to a Oracle stored procedure
Oracle - How to grant to a user the rights to another user's objects
How to select dates from dual, but with joined data?
Oracle Parameterized query in c#
Oracle 12. Maximum duration for “select for update” for occi c++
Sequence next value in SELECT statement
Materialized View: How to automatically refresh it upon table data changes?
Header formatting while spooling a csv file in sqlplus
Cannot Install ruby-oci8 on Ubuntu 12.04LTS
ORA-01031 Insufficient privileges while CREATING a VIEW?
Formatting output of queries in SQLPlus
Membership.ValidateUser always returns false after upgrade to VS 2010 / .NET 4.0
oracle sql developer is truncating my results
Oracle DDL in autonomous transaction
Oracle MERGE does not INSERT
Is it possible to set a unique constraint as a foreign key in another table?
asp.net core docker container using Oracle Managed Driver Core. throws ORA-00604 and ORA-01882 when opening connection
How to drop columns in a compressed table?
SQL Error: ORA-02000: missing ALWAYS keyword when create identity column based table
How can I get position of an error in Oracle SQL query?
Oracle query using Entity Framework is ridiculously slow
Common Table Expression in Sub-Query
Creating index/pk in a huge table is taking too long. I am using Oracle. How do I know if it is going well?
Is there an equivalent to sp_getapplock, sp_releaseapplock in oracle
Use Oracle INSTR function to search for multiple strings
How Pragma UDF works?
Entity Framework - Use Dynamic connection string with Oracle Provider
Oracle 12c JSON Query Issue with Dot Notation and Double Quotes
ODP .NET behaves weird
Oracle external tables - Specifying dynamic filename
How do I merge two tables without naming all columns?
Reducing Parse Calls in Oracle
Precision of Interval for PL/SQL Function value
Serialize Oracle row to XML
How do I find the high water mark (for sessions) on Oracle 9i
Idle Oracle connections give error 'ORA-03114: not connected to ORACLE'
Oracle 12c double quote on password restrictions
ORA-12519, TNS:no appropriate service handler found while inserting into Oracle Database with X threads
Parsing XML with unknown namespaces in Oracle SQL
Getting counts/totals at each level of a hierarchical query using CONNECT BY
Oracle SQL using Like for a wildcard
DBMS_XPLAN.DISPLAY_CURSOR vs Explain Plan if not using gather_plan_statistics hint
Solution to problem done in PL/SQL what would it look like in SQL?
Apache NiFi :Convert JSONtoSQL (Oracle Database)
Connecting to Oracle DB using Ruby
Why would “Where 1 <> 1” in a query return all rows?
Oracle SQL to change column type from number to varchar2 while it contains data
oracle if 0, like if null (nvl)
Multiple max values in a query
SQL Error: ORA-12899: value too large for column
Positive value to negative and negative to positive in oracle
Difference Between Timestamps in Milliseconds in Oracle
Select `n` last inserted records in table - oracle
Is it possible to have multiple rows with SELECT FROM DUAL?
Need to reset the value of sequence in Oracle
Oracle to_date, from mm/dd/yyyy to dd-mm-yyyy
List all the months using oracle sql
How to merge (combine) 2 columns into 1 in oracle?
Oracle SQL - Find special non numeric characters in field
SQL select & group by a period of time (timestamp)
How to generate DELETE statements in PL/SQL, based on the tables FK relations?
How do I get Oracle, see what procedures are running?
What ways can you create a string with 2000 “spaces”
Oracle query to find all occurrences of a charcter in a string
how to show only the time in oracle?
Oracle SQL: getting only one max row using multiple criteria
How should I deal with null parameters in a PL/SQL stored procedure when I want to use them in comparisons?
Oracle exporting SQL of the Database structure
Getting data from the next row in Oracle cursor
How does line numbering work in an Oracle trigger?
C# - How to get oracle long raw type value
Have PL/SQL Outputs in Real Time
Update Oracle timestamp to current date
Remove all characters after a specific character in PL/SQL
How to calculate average of a column and then include it in a select query in oracle?
Deleting rows from parent and child tables
Insert random data in Oracle table
Converting NOT IN to NOT EXISTS
Howto use Rollback/Commit in Oracle SQL
left join and group of inner join
Insert multiple rows from select into another table
ORA-00119: invalid specification ORA-00132: syntax error
List of Oracle views using specific table name
How do I CAST a NUMBER to VARCHAR2 in Oracle?
CREATE OR REPLACE v/s Dropping a function and re-creating it
ORA-00928 missing SELECT keyword in Oracle
How to create a database in oracle XE?
Problems inserting with PL/SQL Developer
Is this string Base64? How can I tell what is the encoding used?
Oracle: find index creation date from systables/information_schema?
Oracle Bankers rule
Importing selective data using impdp
SQL create table use %type at column
Proper Way To Use .Net DateTime in Parameterized SQL String
dbms_output size buffer overflow
How to make the resultset returned from oracle keeps its column aliases characters case
Update only date on datetime field on Pl/SQL
Oracle Stored Procedure with Alter command
Inserting data in oracle database using php
With clause not working with union
oracle — Split multiple comma separated values in oracle table to multiple rows
how to find partition of record oracle
How to generate list of all dates between sysdate-30 and sysdate+30?
Oracle 11g - Check constraint with RegEx
Where to get Oracle SERVICE_NAME?
plsql oracle check in constraint error
Oracle to_date function. Mask needed
Oracle's dbms_metadata.get_ddl for object_type JOB
Are these tables too big for SQL Server or Oracle
Database Case Insensitive Index?
MERGE table, do nothing when matched
oracle query between two dates with hours
View based on SELECT with 'WITH' clause
Column name as variable in PL/SQL ORACLE
Pass time interval via variable in Oracle SQL
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments
oracle regex replace (keep only a-z)
Converting a XSD date xs:dateTime to an Oracle Date
How can an Oracle NUMBER have a Scale larger than the Precision?
Execute procedure in a trigger
Dynamically add where clauses to a cursor in oracle
Getting unique constraint column names from oracle database
drop procedure if exists in DB Oracle
sum of multiple columns in ORACLE
Finding the count of characters and numbers in a string
SQL distinct with group by in Oracle
SQL Select; Concatenating strings, avoiding double commas where columns are null?
How can an get count of the unique lengths of a string in database rows?
Remove Single Quote from the column value in oracle sql
Oracle: Creating view across schemas?
ORACLE TIMEOUTS - how can i set a longer timeout using this connection string?
ORACLE 11g case insensitive by default
Single SQL SELECT Returning multiple rows from one table row
How to disable connection pool?
How to create a temporary / dynamic / virtual table when a SQL runs in Oracle?
MyBatis RowBounds doesn't limit query results
Oracle duplicate row N times where N is a column
Using the MIN function in the having clause
Generate test data using Oracle PL/SQL developer
How to run SQL in shell script
Pl/SQL- Get column names from a query
Oracle Unique Constraint based on column value
SET SCAN OFF purpose
Oracle Create Table AS and table comments and column comments
Create CLOB from long string using JDBC
Autoincrement Primary key in Oracle database
Update with self-join
Oracle: Check if rows exist in other table
Is it possible to view Oracle user table privileges without having DBA privilege?
How to retrieve the body of an Oracle procedure or function
Call Oracle stored procedure from PHP
SELECT *, ROW_NUMBER() OVER in Oracle
Sort result from xmlagg(xmlelement(…)
Oracle : How to update multiple columns from different table?
Oracle SQL group row count by time intervals of 10 minutes
Python 3.3 - Connect with Oracle database
Column Name of PL/SQL Table-Type
Oracle SQL unique constraint A to B, B to A
What to do to change materialized view column size when under line table column size changed?
Hibernate + oracle sequence + trigger
How to delete duplicate rows from an Oracle Database?
Update a column using a value from the same row in Oracle
Substring-indexing in Oracle
ORACLE: NO DATA FOUND — but data exists
How do I hide my Oracle table?
How do I call an Oracle stored procedure from an Excel VBA script?
Simple Select inside an Oracle Stored Procedure
Grouping by Fiscal Year (Oracle)
A better way to return '1' if a left join returns any rows?
database index: why pairing
Oracle SQL Developer How To Default To Other Users Tables?
Oracle PL/SQL: How to print a table type
Is possible to get a constant value declared in a database package? (SQL or Java)
ORACLE Rollback and Trigger
Dropping then adding a constraint fails in oracle
How to connect to Oracle using JRuby & JDBC
LINQ: How to get the Max Id with a group by clause?
Oracle Entity Framework provider doesn't store DateTime.Now with milliseconds
Keep JSON in oracle database
Oracle: What does 'execute immediate' mean?
Oracle 10: Using HEXTORAW to fill in blob data
exec gather table stats from procedure
selecting top record in ORACLE join statement between subqueries
Oracle SID and Service name; connection problems
how to call a function in plsql function
JDBC Metada retrieve Constraint information
How to check with if an Oracle's view exist in the DB ? Before execute a query
Is there a way to copy BLOB records between databases in Oracle 10g?
what is oci_bind_by_name for?
Oracle & Pagination
programmatically checking for open connection in JDBC
How can I count the number of unique pairs in a table that has a recursive relationship?
Add a row at the end of SQL Select using UNION
Select every columns, but rename one of them
Can I nest “WITH” clause in Oracle SQL?
select rows and generate a new column based on condition SQL
SQL Random String from List
Difference between attribute and a column created with ALTER?
Entity Framework and string as NCLOB on oracle Db
ORA-01756: quoted string not properly terminated when I try to execute my code
Commit and rollback Oracle transactions
How to tell oracle to sort by a specific sort order passed in from java?
Why doesn't PDO's Oracle driver implement lastInsertId()?
Create constraint in alter table without checking existing data
PL/SQL for implode function on custom types
Stored procedure not returning correct result
Python-Oracle Passing in a Cursor Out Parameter
Unique constraint with defined value
SQL question - find a number from a list
Can you give one direction for all columns in an order by?
How can i prevent duplicate rows being selected in a select query?
Does Oracle DB support multiple (parallel) operations per connection?
UNION on two select gives 'SQL Error: ORA-00907: missing right parenthesis'
returning multiple columns using Case in Select Satement in Oracle
Convert special String into Date in H2
Update Oracle table column with row number
How does the HAVING clause really work?
Why dropping a primary key is not dropping its unique index?
Oracle SQL - How to build where clause with optional search parameters
New Grails domain class is not creating a table in the database
Performance issue when using ORDER BY dbms_random.value for Oracle database
'Sequel::Error: id is a restricted primary key' when creating record using Sequel
Remove ORDER BY clause from PARTITION BY clause?
Oracle view pulling data from schemas in different instances?
Oracle: Is there a way to get recent SQL syntax errors?
find database size in Oracle SQL developer
oci_bind_by_name RETURNING INTO truncates value
How to save unicode data to oracle?
Updating a table with record type object
Converting Long to Varchar2
Using Multiple Oracle JDBC drivers in one Java application?
SQL Loader date format
How to enable extensions for oci8 (Oracle) in php.ini - PHP Warning: PHP Startup: in Unknown on line 0
Working with very large text data and CLOB column
How to convert a temporary table to permanent table in Oracle and vice versa
“with… as” in SQL Navigator
what is SQLPlus command to view a VIEW statement?
Old and new values in Oracle Form
Java JDBC query in separate thread lock parent
Reasons for getting (ORA-8102 “index key not found”)
Teradata equivalent for lead and lag function of oracle
Execute sql script in a different schema
Oracle - string combinatorial permutation
Comparing nulls in Oracle SQL
Exception handling in pl/sql
How to keep cursors in v$sql_plan alive longer
how to calc ranges in oracle
How can I pass parameters to a pass-through query in c#?
Dropping all objects of a schema
How convert CLOB to BLOB in Oracle?
Describe table SQL Oracle
How to call a stored procedure with a parameter of type table
PL/SQL Append_Values Hint gives error message
Oracle error: TNS: Listener was not given the SERVICE_NAME in CONNECT_DATA 1
Are update statements safe from race conditions?
Using Alias In When Portion of a Case Statement in Oracle SQL
Primary key composed of two foreign keys? Oracle
What is the difference between ojdbc6.jar and ojdbc14.jar?
Convert Int32 to Oracle number(5) with EF4
POI Appending .0 while reading numeric data from excel
Change all column units from byte to char
How to create text index for '%abc%' search?
Is it possible to do oracle import util as non-dba user?
Grouping rows considering “difference” between rows
Oracle - Updating one column or another based on a condition
Setting session timezone with spring jdbc oracle
How to bulk insert data from ref cursor to a temporary table in PL/SQL
cx_Oracle.DatabaseError: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
PHP Fill with values an existing .xlsb file with data from Oracle
How to get the 2 greatest values between multiple columns?
grant permission for dbms_crypto
ORA-00979: not a GROUP BY expression with a simple example
Order of evaluation of expression in the update-set-clause in oracle database
Oracle's OUTER JOIN (+) on string - Migration PostgreSQL
Deadlocked transactions with Hibernate on Oracle
SqlAlchemy Reflection of Oracle Table Not Owned
Entity Framework Ignore Schema
When does a deterministic function use the previous calculated value?
How to do Minus HQL
How to use SELECT… INTO with a JOIN?
Insert BLOB using java for both DB2 and Oracle
Oracle Sql Developer connections storage
Oracle nocopy method
Difference between IN, OUT, IN OUT parameters in PLSQL
How can I get odd numbered characters in a string using SQL
In Oracle, how do I declare a unique constraint over a pair of values AND it's reverse pair
How can a primary key column have duplicated values in Oracle?
Copy the values of a sequence from one Oracle database to another
Discover PL/SQL package-level types using Oracle dictionary views
Can't identify reason for “column ambiguously defined” error
Oracle 10g - Determine the date a Trigger was last updated
SQL Loader script help with adding SYSDATE, USER
Run multiple commands in one ExecuteScalar in Oracle
How to call a function with Rowtype parameter from a select statement in Oracle
Running Total - Date difference
GROUP BY Create group if at least one value in group meets condition
How to insert NULL in to date field Oracle SQL Developer
Load table to Oracle through pandas io SQL
Expression to remove carriage return in SSRS
ODP.net pass UDT as table to a stored procedure in C#
What is 'THE' keyword in Oracle?
SELECT * FROM TABLE(pipelined function): can I be sure of the order of the rows in the result?
PL/SQL developer how to get the row that made the insert fail?
Is it possible to include dual table in a join query
Error: Incompatible character encodings: UTF-8 and ASCII-8BIT
Query columns names from a table from another user
Oracle 11g CREATE VIEW using CONNECT BY and multiple tables
Interesting Oracle analytic query challenge
In PL/SQL, how do you update a row based on the next row?
How can I set a timeout on spring DriverManagerDataSource
Why does this query result in a MERGE JOIN CARTESIAN in Oracle?
How can i get rid of 'ORA-01489: result of string concatenation is too long' in this query?
PL/SQL: How to detect which browser is being used?
Is there a way how to truncate all tables using liquibase?
When opening an oracle connection, connection object is null
Oracle: year must be between -4713 and +9999, and not be 0
Can I have multiple statements in a native query in JPA 2
How to represent Oracle Interval in Java
Create user defined operator with left/right sides
Suggested method of handling non-overlapping ranges (e.g. scheduling)
Oracle SQL assign consecutive numbers to a subset based on column values
Perl DBI alternative to LongReadLen
SQL SELECT to find cyclic references in father-ID-organized tree?
Pass an array as value in an ado.net DBParameter
Hibernate Ignores DB Timezone Info when Binding to Java Timestamp Object
hibernate hql - return updated rows id list after execute update query
How to see the tables created on oracle cloud
Merge date ranges
Why does this Oracle DROP COLUMN alter the default value of another column?
Oracle 11g “Bind variable does not exist”
Removing duplicate subtrees from CONNECT-BY query in oracle
Materialized View Refresh On Commit