Blogs about: Plsql
Featured Blog
Duadic Supplementary Studies with regard to Aspartame and Brain trust Drinks Cross-check Headwaters in respect to Obesity, Fungus/Uncivilized Burn to death Skin eruption Epidemics
Distich Sempervirent Studies referring to Aspartame and Regime Drinks Stiffen Guiding light as for Obesity, Mildew/Despiteful Ticker Pain Epidemics(proofroom unfettering) The Wart Quest Secret place w… more →
Coryshm's Weblog
Till New Year
Bauyrzhan wrote 3 days ago: SELECT 'Til the New Year ' || to_char(extract(YEAR FROM SYSDATE) + 1) || ' - ' || trunc(months_betwe … more →
Convert seconds to Day hour : min : sec
Bauyrzhan wrote 3 days ago: variable vSec number; exec :vSec := 68400; select to_char(trunc(:vSec/60/60/24),'09')||' [day]' ||t … more →
Clock watching – Instrumenting PL/SQL with timing information
mikesmithers wrote 5 days ago: You know what it’s like, that piece of code you wrote last week and simply whizzed along in th … more →
Oracle PL/SQL and Pseudocolumn: ROWID
ctrlc wrote 5 days ago: Pseudocolumns are virtual columns that behave like a column of table, but is not actually stored in … more →
How to explain plan on views when you don't have access on base tables
— 4 comments
coskan wrote 5 days ago: One of my friends asked, how can developers see the explain plan on views without having access to … more →
The Secrets of Oracle Bitmap Indexes
hernk wrote 1 week ago: Overview Oracle’s two major index types are Bitmap indexes and B-Tree indexes. B-Tree ind … more →
Control Structure
jcsze wrote 1 week ago: For conditional statement: basic syntax: IF <condition> THEN –do sumthing here ELSIF … more →
PL/SQL Intro
jcsze wrote 1 week ago: PL/SQL refers to procedural languange + SQL feature of Oracle. Here, you can write loops, conditiona … more →
"Pretty" Date Format Function
— 7 comments
Tyler Muth wrote 1 week ago: I’m not sure who originally wrote this function (probably Tom Kyte), but I needed it yesterday and c … more →
Oracle PL/SQL and [query] operator [query]: Union, intersect and minus.
— 1 comment
ctrlc wrote 1 week ago: Union [ALL], intersect and minus are useful operators when is necessary merging of results two separ … more →
Tapasztalt Oracle Fejlesztő
Zsuzsanna Blau wrote 1 week ago: Feladatok: Oracle adatbázis fejlesztés, tervezés Java alkalmazásokhoz Adattárház továbbfejlesztése … more →
Just how Agile is Python Anyway ?
raychorn wrote 1 week ago: Just how Agile is Python Anyway ? … more →
Scripts - Flexfield Values
shameemakhtar wrote 2 weeks ago: Key Flexfields are stored in the following tables: FND_FLEX_VALUE_SETS FND_FLEX_VALUES SELECT * FR … more →
Delete/Keep one copy of duplicated rows
lianggang wrote 2 weeks ago: Using GROUP BY and ROWID in DELETE statement, keep/delete copies of duplicated rows in a single SQL … more →
New Walk-in for Jobs - June 16-17-18-19 2009
— 3 comments
Walkin Jobs wrote 2 weeks ago: Hi, Many new walkin interviews for jobs across india scheduled on June 16,17,18,19 2009. .NET Freshe … more →
Kill and disconnect mass SID using procedure
Ryan Stephanus wrote 3 weeks ago: Yesterday at my client office, I found that there are exists exclusive locks in the database that pr … more →
Oracle PL/SQL and null values: NVL Function
— 1 comment
ctrlc wrote 3 weeks ago: The NVL function lets you substitute a value when a null value is encountered. Applies To: Oracle 8i … more →
Senior Database Developer (Oracle) - 3-6 Month Contract - Fort Lauderdale, FL
Ruben Rabines wrote 3 weeks ago: PLEASE SEND RESUMES TO rrabines@compuquip.com Location: Plantation, FL Rate: On experience Duration: … more →
Lazy Insert
mikesmithers wrote 3 weeks ago: Do you ever get that annoying colleague quoting Kyte at you … “if you can do it SQL then … more →
Have your say. Start a blog.
See our free features →
An 
Contraption
