PL SQL
657 views | +1 today
Follow
PL SQL
pl sql and oracle news
Curated by sim83
Your new post is loading...
Your new post is loading...
Scooped by sim83
Scoop.it!

Single quote manipulation Oracle | sqlandplsql.com

Single quote manipulation Oracle | sqlandplsql.com | PL SQL | Scoop.it
There are few tricks/workarounds. 1. Traditional or trivial way. Append with another single quote. SQL> select 'it”s a rainy day' as trivial from dual;. TRIVIAL —————- it's a rainy day. ' Below pl/sql block inserts a record with ...
more...
No comment yet.
Scooped by sim83
Scoop.it!

PL SQL Tips & Tricks: The PL SQL REPEAT-UNTIL Loop

The PL/SQL REPEAT-UNTIL Loop The WHILE loop test at the start of the loop and it the condition is false, the loop code is never executed. If you want to ensure that the loop code is executed at least one, the test must be ...
more...
No comment yet.
Rescooped by sim83 from Oracle Database Tips
Scoop.it!

Oracle SQL Developer v3.2 is Now Available!

Oracle SQL Developer v3.2 is Now Available! | PL SQL | Scoop.it
Today we released the latest version of Oracle SQL Developer - v3.2.09.23.

Via Antonio Turibbio Liccardi
more...
No comment yet.
Scooped by sim83
Scoop.it!

Oracle SQL Developer Tips and Tricks Series, Episode 1

Oracle Product Manager Jeff Smith shows you how to navigate and work with your PLSQL code with fewer clicks and much more efficiency.youtube.com...
more...
No comment yet.
Scooped by sim83
Scoop.it!

PL SQL Tips & Tricks: How to Start Oracle From Oracle SQL ...

PL SQL Tips & Tricks: How to Start Oracle From Oracle SQL ... | PL SQL | Scoop.it
Oracle SQL Developer: Developed in Java, the tool runs on Windows, Linux, and Mac operating system (OS) X platforms. You can install SQL Developer on the database server and connect remotely from your desktop, thus ...
more...
No comment yet.
Scooped by sim83
Scoop.it!

Wireless: IRN Immediate need for -- PL/SQL Oracle Developer ...

Wireless: IRN Immediate need for -- PL/SQL Oracle Developer ... | PL SQL | Scoop.it
IRN Immediate need for -- PL/SQL Oracle Developer -- Chandler, AZ -- 18 month contract. Posted by Wireless | Tuesday, October 16, 2012 | Category: |. Dear Employers, Hope the day is treating you well!
more...
No comment yet.
Scooped by sim83
Scoop.it!

PL/SQL Challenge Adds New Feature: Favorites

PL/SQL Challenge Adds New Feature: Favorites | PL SQL | Scoop.it
We upgraded to version 2.4 today and it has a single new feature - requested by many players: Favorites.
You can now "tag" authors, players, quizzes, resources, features and more as Favorites.
more...
No comment yet.
Scooped by sim83
Scoop.it!

Oracle Developer (Forms, Reports, PL/SQL) - Preston - 30-40K - The Independent

Oracle Developer (Forms, Reports, PL/SQL) - Preston - 30-40K - The Independent | PL SQL | Scoop.it
Oracle Developer (Forms, Reports, PL/SQL) - Preston - 30-40KThe IndependentMy client are urgently seeking an experienced Oracle database developer. Please find the specification below and respond by submitting an up to date CV ASAP if interested.
more...
No comment yet.
Rescooped by sim83 from BIG data, Data Mining, Predictive Modeling, Visualization
Scoop.it!

Deep Data Mining Blog: Build Predictive Models Using PL/SQL

Deep Data Mining Blog: Build Predictive Models Using PL/SQL | PL SQL | Scoop.it
Many data analytics professionals/data miners are not aware that predictive modeling can be done within Oracle database. I probably have built more than one hundred predictive models this way in recent years.

Via AnalyticsInnovations
more...
No comment yet.
Scooped by sim83
Scoop.it!

oracle – PL/SQL how to write multiple statement in a single stored …

oracle – PL/SQL how to write multiple statement in a single stored … | PL SQL | Scoop.it
See on Scoop.it – PL SQL PL/SQL how to write multiple statement in a single stored procedure. up vote 0 down vote favorite. I need to do … Browse other questions tagged sql oracle plsql...
more...
No comment yet.
Scooped by sim83
Scoop.it!

PL SQL Tips & Tricks: Data Type Conversion

Convert data to comparable data types. Are of two types: Implicit conversions. Explicit conversions. Some conversion functions: TO_CHAR TO_DATE TO_NUMBER TO_TIMESTAMP Data Type Conversion (continued) ...
more...
No comment yet.
Scooped by sim83
Scoop.it!

PL SQL Tips & Tricks: How to Start Oracle From Command Prompt ...

PL SQL Tips & Tricks: How to Start Oracle From Command Prompt ... | PL SQL | Scoop.it
See on Scoop.it – PL SQL C:\Documents and Settings\winuser>net start oracleserviceorcl. The requested service has already been started. C:\Documents and Settings\winuser>set oracle_sid=orcl. C:\Documents and ...
more...
No comment yet.
Scooped by sim83
Scoop.it!

Oracle PL/SQL Tutorial - NDS Part 1

www.infiniteskills.com This InfiniteSkills PLSQL Tutorial offers a solid introduction to NDS.youtube.com...
more...
No comment yet.
Scooped by sim83
Scoop.it!

May's Site - online Oracle PL/SQL for dummies

Oracle PL/SQL for dummies by Michael Rosenblum, Paul Dorsey.
more...
No comment yet.
Scooped by sim83
Scoop.it!

Advanced SQL SubQueries in Oracle Database

Learn to code advanced correlated SQL subqueries in the Oracle Database. From SkillBuilders.com/Oracle.
more...
No comment yet.
Scooped by sim83
Scoop.it!

PL SQL Tips & Tricks: How to Start Oracle From Command Prompt.

PL SQL Tips & Tricks: How to Start Oracle From Command Prompt. | PL SQL | Scoop.it
C:\Documents and Settings\winuser>net start oracleserviceorcl. The requested service has already been started. C:\Documents and Settings\winuser>set oracle_sid=orcl. C:\Documents and Settings\winuser>sqlplus ...
more...
No comment yet.
Scooped by sim83
Scoop.it!

Oracle PL/SQL Tutorial - Package Specifications

www.infiniteskills.com This Oracle training video clip from the InfiniteSkills course demonstrates PLSQL package specifications.youtube.com...
more...
No comment yet.
Scooped by sim83
Scoop.it!

PLSQL : How to save a dynamic SQL query result into a two ...

PLSQL : How to save a dynamic SQL query result into a two dimension array? ... Browse other questions tagged sql arrays oracle dynamic plsql or ask your own question.
more...
No comment yet.
Scooped by sim83
Scoop.it!

The Professionals Point: 6 Very Simple PLSQL Programs to Explain ...

6 Very Simple PLSQL Programs to Explain Cursors. Cursors in PL/SQL are used to retrieve more than one row at a time. The data that is stored in cursors is known as Active Data Set. These cursors are of two types: 1.
more...
No comment yet.
Scooped by sim83
Scoop.it!

PL/SQL Programming | Database Administration | Oracle | SQL

PL/SQL Programming | Database Administration | Oracle | SQL | PL SQL | Scoop.it
I need someone to complete a PL/SQL programming assignment today. The code must use basic PL/SQL functions such as cursors, and for loops. May not contain.
more...
No comment yet.
Rescooped by sim83 from DevOps in the Enterprise
Scoop.it!

Continuous Integration with Oracle PL/SQL, utPLSQL and Hudson – The Server Labs Blog

Continuous Integration with Oracle PL/SQL, utPLSQL and Hudson – The Server Labs Blog | PL SQL | Scoop.it

This is a problem near and dear to my heart and this is very much at the heart of the solution we are employing combined with our own internal versioning table and utility package.


Via onCommit
more...
No comment yet.