|
|
| About site: Programming/Languages/PL-SQL - PL/SQL tips |
Return to Computers also Computers
|
| About site: http://www.oracledba.co.uk/tips_plsql.htm |
Title: Programming/Languages/PL-SQL - PL/SQL tips Short tips and code fragments written (or collected) by Connor McDonald. Includes bit operations, undocumented features, and 8.1.7.
|
|
|
|
|
TrackGear A web-based bug tracking system, requires Windows NT and MS SQL server as back end. (LogiGear Corporation)
| RFC_2026 The Internet Standards Process -- Revision 3. S. Bradner. October 1996.
| See_Fun\'s_Wallpaper A variety of desktop images for your opening screen. This includes fantasy, art, digital, nature and 3D art.
| RFC_1620 Internet Architecture Extensions for Shared Media. B. Braden, J. Postel, Y. Rekhter. May 1994.
| Dreamscenes Animated screen savers include winter, dolphin, and by water themes. Free trial downloads.
| SNIN Provides design, development, consulting, promotion, and hosting services. Based in Antelias, Lebanon.
|
|
| Alexa statistic for http://www.oracledba.co.uk/tips_plsql.htm |
Please visit: http://www.oracledba.co.uk/tips_plsql.htm
|
| Related sites for http://www.oracledba.co.uk/tips_plsql.htm |
| 123_Greetings Includes holidays, everyday, birthdays, flowers and pets. Features cards for several religious faiths. Animated images. | | Wolkowicz,_Henry University of Waterloo. | | Information_Resources_Inc_ Company engaged in the marketing, sales, logistics and distribution of consumer goods in the U.S., Europe and Latin America theaters obtained using business planning, product development, supply chain | | Alia_Systems_Limited UK company performing bespoke software development for IBM mainframes, AS400, and UNIX systems. Also integrates legacy systems with emerging technologies. | | Hostedboard Provides free phpBB hosting. Ad-supported. | | Smokescreen A Java class file obfuscator, that supports selective renaming, unused method and field removal, as well as bytecode obfuscation. [Shareware] | | YamIpod_-_Yet_Another_iPod_Manager Freeware application enabling adding and deleting music from the device. Includes software news, development information, and downloads. | | @enterprise_Web_Workflow_System @enterprise is a workflow system based on Internet technologies. It supports customers in definition, execution and controlling of business processes. | | Forbes_com__Apple\'s_Supercomputing_Scientists Some biology and genetic scientists are big fans of the Mac. (January 12, 2004) | | Calxalot_Software Open source freeware for Mac OS X. | | Road_Rock Hosted service providing rock bands with the ability to email fans from the road, display updated schedules on the band's website, and track schedule, show, and merchandising information for the tour. | | Password_Protector Helps you organize and safely store your passwords. This program can also generate passwords for you. Besides passwords you can store URLs, e-mail addresses and other notes with it. | | RetinaJoy Links to tutorials plus a lightwave boxes tip. | | LDW_Software Developer of innovative games for Palm OS including Plant Tycoon and Little Palm Pet. | | EEMame A port of the MAME arcade game emulator for mobile phones. Includes discussion forum, downloads and list of supported roms. [Series 60, UIQ] | | FoCul_Home_Page An IBM Lotus Business Patrtner specialising in solutions for the manufacturing sector. | | Innovative_SoftSystems Provider of various Netware maintenance utilities including Automated Volume Purge Utility and additional consulting services. | | Rendezvous_with_Ada_95 Description, table of contents, and online ordering. | | Excite_Designs,_Inc_ Professional Web site, graphics, multimedia design and Internet marketing services. Details on services and pricing. | | Counter_Lite Counts both unique visits and page views. [Freeware] |
|
This is websites2007.org cache of m/ as retrieved on 2008.10.12 websites2007.org's cache is the snapshot that we took of the page as we crawled the web. The page may have changed since that time.
|
www.oracledba.co.uk
PL/SQL
Topic
Description
15/10/2007
PEBKAC substring
Looking to reinvent SUBSTR ? Maybe use the SUBSTR function :-)
15/08/2007
BULK records
Handling bulk collect with PLSQL record datatypes
16/07/2007
RETURNING clause
Good but not good enough for INSERT
20/06/2006
SQL and Collections
Using collections to spice up SQL
11/01/2006
Altering types (updated)
How to alter a type without dropping and recreating it
08/09/2005
NVL costs (updated)
Some hidden costs with NVL you might not expect
14/06/2004
DBMS_SQL
Just a reminder about DBMS_SQL overuse
04/02/2004
PL/SQL upsert
Staying efficient with PL/SQL upsert
04/12/2003
File deletion
File deletion in version 8i
08/08/2003
As bad as it gets
Surely the worst piece of PL/SQL code ever
01/01/2003
Fast SYSDATE
(Updated) A faster SYSDATE then SYSDATE
21/06/2002
Speed increase
A simple mechanism for increasing the speed SQL within PL/SQL
24/04/2002
Array fetch
(Updated)Fetching into a PL/SQL table in a single call
03/03/2002
MOD vs TRUNC
(Updated)When using counters in loops, for that extra little bit more speed, TRUNC is faster than MOD
06/02/2002
Loading LOBs
A 'gotcha' when using DBMS_LOB.LOADFROMFILE
11/11/2001
Packaged Cursors
Defining a public and private component to a packaged cursor
15/07/2001
Cursor speed
Putting to rest the myth about explicit cursors being better than implicit ones
30/05/2001
Fast SYSDATE
A faster SYSDATE then SYSDATE
04/03/2001
DES Encryption
A (very) simple wrapper to ease use of DBMS_OBFUSCATION_TOOLKIT
14/01/2001
Semi-autonomous?
A "semi-autonomous" transaction in 8.1.7!
02/01/2001
Fetch across commits
You were never meant to do this anyway...but now 8.1.7 stops you!
19/12/2000
PL/SQL in 8.1.7
A weird bug in PL/SQL in 8.1.7 (that will cause you grief if you use Designer)
06/07/2000
Encryption
A PL/SQL encryption routine to tide you over until 8i.2
12/04/2000
PL/SQL table memory
Reclaiming the memory used by large PL/SQL tables
04/04/2000
More on tracing
A nifty little (undocumented) PL/SQL package for tracing
29/03/2000
Tracing sessions
An undocumented PL/SQL procedure to give more flexibility to your tracing
16/02/2000
Checksum
A PL/SQL function to perform checksums
09/02/2000
Bit operations
Bitwise calculations in Oracle with the 'bitand' function
06/02/2000
Cube & Rollup in PL/SQL
Using the CUBE and ROLLUP features in PL/SQL
06/02/2000
Images to the web
Retreiving a GIF image from a database column and showing on a web page
06/02/2000
Writing to alert.log
You can use PL/SQL to write your own messages to the alert.log
(always more to come...)
All content on this page is provided
on an "all care, no responsibility or liability" basis
The use of very basic html on this page is designed to increase the
speed at which each page is downloaded.
It has nothing to do with my wealth of html knowledge :-)
|
|
| |
Short | tips | and | code | fragments | written | (or | collected) | by | Connor | McDonald. | Includes | bit | operations, | undocumented | features, | and | 8.1.7. |
|
http://www.oracledba.co.uk/tips_plsql.htm
PL/SQL tips 2008 October
dvd rental
dvd
Short tips and code fragments written (or collected) by Connor McDonald. Includes bit operations, undocumented features, and 8.1.7.
Rules
|
© 2008 Internet Explorer 5+ or Netscape 6+
|
|
Recommended Sites: 1.
Arts -
Business -
Computers -
Games -
Health -
Home -
Kids and Teens -
News -
Recreation -
Reference -
Regional -
Science -
Shopping -
Society -
Sports -
World
Miss Gallery
- Top Anime Hentai
- DVD rental by mail
- MPAA - Electricity - Fast Loans - Money - Video game rental
|
