Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in oracle

Strange Oracle XMLType.getClobVal() result

oracle xmltype

Referencing a two column primary key with multiple foreign keys

sql oracle key sqlplus

Materialized View vs View

oracle materialized-views

Call pl/sql function in java?

java oracle function jdbc plsql

Algorithm or SQL : to find where conditions for a set of columns which ensures result set has value in a particular column always > 0

java sql oracle algorithm plsql

SQL Datatype to use when inserting money

How can I validate SQL query syntax in oracle database?

Convert number to date sql oracle

sql oracle date-formatting

Materialized view and table with the same name

oracle materialized-views

How to pass date parameter inside the oracle procedure?

sql oracle

Oracle SQL or PL/SQL: How to identify candlestick pattern only in end of uptrend or downtrend and set a flag in column?

oracle plsql oracle-apex

Simulated OLAP

oracle olap cubes

How do you use telnet to check a connection to Oracle?

oracle telnet

Oracle query using 'like' on indexed number column, poor performance

IDLE timeout parameter in Oracle

Dynamic table partitioning in Oracle

How to (unit-)test data intensive PL/SQL application

Equivalent of MySQL's \G in Oracle's SQL*Plus

oracle sqlplus

Is it a good idea to index a date column in descending order?

database oracle indexing

Why does Oracle's varchar sort order not match the behavior of varchar comparison?

oracle sorting compare