Examples of programming questions in oracle

Is there a version control system for database structure changes?
cx_Oracle: How do I iterate over a result set?
How to see the actual Oracle SQL statement that is being executed
Business Logic: Database or Application Layer
How to check if a trigger is invalid?
Oracle Insert via Select from multiple tables where one table may not have a row
Can Multiple Indexes Work Together?
Oracle merge constants into single table
How to choose and optimize oracle indexes?
Is there a good alternative to SQL*PLUS for Oracle?
Should I delete or disable a row in a relational database?
oracle left outer joins not showing right null values
Hidden features in Oracle
is there a PRODUCT function like there is a SUM function in Oracle SQL?
Oracle: Combine multiple results in a subquery into a single comma-separated value
OracleParameter and IN Clause
What is the best way to escape non-format characters in Oracle's to_char?
SQL not equals & null
Deleting a LOT of data in Oracle
installing Oracle Instantclient on Mac OS/X without setting environment variables?
SQL Query to Collapse Duplicate Values By Date Range
Oracle 10g - optimize WHERE IS NOT NULL
Selecting all rows until first occurrence of given value
Retrieve value of an xml element in Oracle PL SQL
how to create a stored procedure in oracle which accepts array of parameters
Oracle stored procedure OUT parameters
What's the difference between the Oracle SYS and SYSTEM accounts?
Oracle 'printf' equivalent
Relation between Oracle session and connection pool
When does Oracle index null column values?
Oracle get stored procedure last modified date
Spring JDBC support and large dataset
PL/SQL function in Oracle cannot see DBMS_AQ
Reverse in Oracle this path z/y/x to x/y/z
Why is Select 1 faster than Select count(*)?
how to set a null value to a field in a table using oracle sql developer tool?
Oracle dba_data_files table doesn't exist
How do you check if a row is locked for update?
How do I show fields in a table in oracle?
Impact of defining VARCHAR2 column with greater length
How to sync and optimize an Oracle Text index?
Update Oracle table with values from CSV file
Oracle subquery does not see the variable from the outer block 2 levels up
Inserting data in oracle database using php
Why does Oracle varchar2 have a mandatory size as a definition parameter?
SQL recursive query on self referencing table (Oracle)
How can I check the last time stats was run on Oracle without using OEM
How is Oracle's JDBC query timeout implemented?
Executing an Oracle Stored Proc as Another User
Can Hibernate automatically uppercase a column on read/insert via configuration?
Retrieving Stored procedures, Views, Functions, Triggers using Toad for Oracle
PL/SQL Package invalidated
How to use Data Pump utilities without a tnsnames.ora file
Oracle equaivalent of java System.currentTimeMillis()?
Filter on count(*) in oracle
How to optimize an update SQL that runs on a Oracle table with 700M rows
Two PLSQL statements with begin and end, run fine separately but not together?
Convert OracleParameter.Value to Int32
How to reclaim storage for deleted LOBs
Oracle exporting SQL of the Database structure
How can I see queries that are executed against Oracle?
ORA-27101: shared memory realm does not exist
What SQL data type does Oracle assign to "count(*)"?
How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
How to call oracle stored procedure which include user-defined type in java?
Oracle - drop table constraints without dropping tables
How to do Outer Join on >2 Tables (Oracle)
How can I mock an OracleConnection and OracleCommand?
WebSphere to Oracle - doesn't accept correct password
Convert epoch to date in sqlplus / Oracle
pl/sql - Is there a NVL() for empty rows
What's the SQL national character (NCHAR) datatype really for?
Oracle Create View issue
What's the difference between "commit" and "commit work"?
Writing a select statement inside an Oracle user-defined function
SQL ignore case in group by? (oracle)
What does this Oracle SQL Developer icon mean on my stored procedure?
oracle "table or view does not exist" from inside stored procedure
Find Size of a Database in Oracle
What are materialized views?
How do I call an Oracle stored procedure from an Excel VBA script?
Conditions (like "like") on binary field (blob) in oracle
how to insert current date into a DATE field in dd/mm/yyyy format in oracle
SQL Error: ORA-02298: cannot validate (SYSTEM.AEROPUERTO_FK) - parent keys not found
Creating a trigger to only run when a new table is being created
Getting index of element in PL/SQL collection
Conditionally define a Cursor
What is better? Subqueries or inner joining ten tables?
Duplicated definition for: 'identifiedType'
Online SQL syntax checker conforming to multiple databases
Delete all duplicate records from Oracle table except oldest
Where to get Oracle SERVICE_NAME?
SQL select & group by a period of time (timestamp)
Generate Upper and Lowercase Alphanumeric Random String in Oracle
Is there any hash function in PL/SQL?
CLOB vs. VARCHAR2 and are there other alternatives?
how to fetch, delete, commit from cursor
Oracle select for update behaviour
interval function in oracle
Should I be using JDBC getNString() instead of getString()?
MD5 in Oracle (DBMS_OBFUSCATION_TOOLKIT.MD5)
Oracle: How to add 6 months to current date
Grant Select, Insert, Update to a Tablespace
Optimal way to create a histogram/frequency distribution in Oracle?
Using Dapper with Oracle
Is an index clustered or unclustered in Oracle?
PostgreSQL - query syntax without quotes
How can I extract files from an Oracle BLOB field?
Ref cursor with Execute immediate
SQLDeveloper displays no tables under connections where it says tables
SQL: if cannot convert to_number set as null
Is Oracle's SYS_GUID() UUID RFC 4122 compliant?
Inserting national characters into an oracle NCHAR or NVARCHAR column does not work
Index on view (Oracle)
How to make use of SQL (Oracle) to count the size of a string?
Oracle SQL trigger for automatically set a column value
Join to an oracle table valued function
Difference between SELECT DISTINCT and SELECT UNIQUE
Group by vs Partition by in Oracle
Oracle date to Java date
where to define default value in oracle package
AES Encryption in Oracle and MySQL are giving different results
How to compare two DATE values based only on date part in Oracle?
How to get information about a User-Defined Type?
SQL query to find rows with at least one of the specified values
SQL ORACLE ORA-00969: missing ON keyword?
ORACLE and Entity Framework. Error:the specified store provider cannot be found in the configuration or is not valid
Column headings keep appearing throughout Oracle output
Oracle 11g - Check constraint with RegEx
Why is there a SELECT 1 from table?
What is correct JDBC URL syntax if Oracle wallets are used?
Mapping java.long to oracle.Number(14)
how to select the most frequently appearing values?
How can I list the scheduled jobs running in my database?
Does ODP.NET require Oracle Client installation
Connecting to Oracle DB with JavaScript
Unable to create table using pl/sql
How to handle versioning with Oracle Apex
Strange Oracle error: Identifier too long ORA-00972
How to drop all triggers within given DB in Oracle at once?
Create more than one procedure in a SQL file?
work with json in oracle
SQL not displaying null values on a not equals query?
New Line while inserting into VARCHAR2 column
dbms_output size buffer overflow
List the contents of Oracle export dump file
sql - insert if not exists
Oracle always uses HASH JOIN even when both tables are huge?
How to configure UTF8 character set in Oracle?
Dynamic 'LIKE' Statement in SQL (Oracle)
Using Merge statement inside a cursor
Adding columns to existing index in Oracle
ORACLE: NO DATA FOUND -- but data exists
Get list of table names in different schema of an Oracle database
Select all Rows with "Now minus 30 minutes" in Oracle SQL (11g)
How to see refcursor result/output in Oracle SQL Developer?
Could not load file or assembly Oracle.DataAccess
Fail to convert to internal representation
Does Oracle use short-circuit evaluation?
How to copy data from one database/table to another database/table
dataaccess error--> getInt not implemented for class oracle.jdbc.driver.T4CDateAccessor
How can I automatically unlock tables in Oracle after a given time?
SET SCAN OFF purpose
creating parameterized views in oracle11g
SELECT COUNT(*) with an ORDER BY
ORA-00907 Missing right parenthesis issue - select with order by inside insert query
How do I rename a table in Oracle so that all foreign keys, constraints, triggers and sequences are updated and any existing data is preserved?
PL SQL trigger to insert history record when a column is updated
Referring to a cursor in an anonymous block
SQL (Oracle) Select without an actual table containing static data
SQL: Get records created in time range for specific dates
Manually forward a sequence - oracle sql
Oracle Time Comparisons
How to get current GMT in Oracle
Oracle parents key not found
How to test read/write filesystem permissions of directory Oracle?
SQL Command not properly ended?
Select a single column value and store it in variable oracle sql
Speed up bulk insert operations with NHibernate
ORA-02085: database link DBLINK_NAME connects to ORACLE
How can I fetch the data from the SYS_REFCURSOR from one stored proc and use it in another?
In SQL, what does using parentheses with an OR mean?
Optimal way to DELETE specified rows from Oracle
How to group by each day in PL/SQL?
Hibernate custom type to avoid 'Caused by: java.sql.SQLException: Stream has already been closed'
How to get a single value back from query vs resultset
Making a Dictionary List with cx_Oracle
SQLite: Something like Oracle Decode or MS "If
Convert Unixtime to Datetime SQL (Oracle)
Error(5,3): PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: language
Where's my invalid character (ORA-00911)
How to get the latest employee record in oracle?
How to show comments of a column with desc operation
oracle pl/sql results into one string
Store Date Time with Oracle Apex
oracle - integrity constraint violated - child record found
Repeating rows based on column value in each row
how to write Oracle Function For Convert Date to persian (jalali)
JDBC Batch insert exception handling
Oracle: INSERT values from SELECT...JOIN, SQL Error: ORA-00947: not enough values
SQL Group By - counting records per month/year, error on insert - NOT A VALID MONTH
WFMLRSVCApp.ear file not found
How To Handle Table Column Named With Reserved Sql Keyword?
How I can create a table having two long columns?
create synonym for table in a database hosted in a different server
How to insert 1 million random row into table database Oracle
how to use Oracle's regexp_like in Hibernate HQL?
Pivoting of data using two columns
Oracle Sequence Transactionality
Delete from two tables with circular foreign keys
Any disadvantages to bit flags in database columns?
ORACLE SQL get difference of two values retrieved from 2 select statements
How do I check index building status on Oracle 11?
Why is this check for null associative array in PL/SQL failing?
How to terminate Oracle procedures which is running
Procedure in package specification
How to Pass Java List of Objects to Oracle Stored Procedure Using MyBatis?
Why in SQL NULL can't match with NULL?
Oracle - Why should I use packages instead of standalone procedures or functions
How to create unique index on fields with possible null values (Oracle 11g)?
Need to count records and group count by date on oracle db using sql developer
Finding week number in a month in oracle
oracleConnection.close() dont close the connection in my session browser
How do I connect to Oracle with SSIS? I am getting the error: "tns listener was not given the service_name in connect_data
Is there a difference between Surrogate key, Synthetic Key, and Artificial Key?
How to return primary key from oracle merge query
Table rownum returns 0 records if rownum is tested for value greater than 100
Oracle - Clone table - Structure, data constraints and all
Oracle 'INSERT ALL' ignore duplicates
TNSNames.ora doesn't appear when setting up a oracle odbc driver connection
Import .sql file in Oracle?
Why is Oracle ignoring index with ORDER BY?
PL/SQL How to get X day ago from a Date as Date?
Oracle Sequence value are not ordered
How are dates stored in Oracle?
Whatis is best approach on executing multiple UPDATE statement in one connection?
how to find partition of record oracle
Are a CASE statement and a DECODE equivalent?
Deploying and Configuring ODP.NET to work without installation with Entity Framework
SELECT INTO and multiple variables for UPDATE
Cannot connect to database using JDBC on Glassfish3
Get started link does not work in oracle 11g server
What to do to change materialized view column size when under line table column size changed?
Oracle: Create a View with Auto Increment id column
java.sql.SQLException: ORA-03115: unsupported network datatype or representation
How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
Sql adding a string and number and displaying it as a single column
Referencing a two column primary key with multiple foreign keys
conditional order by clause in sql
Does `EXCEPTION WHEN OTHERS THEN RAISE` do something?