Using SELECT to create a range of numbers or duplicate rows – Oracle SQL

This simple technique will show you how to write a SELECT statement that dynamically creates a number of rows.  It can be used to duplicate data or create a numbers on the fly, so the data looks like this.

DATA
1
2
3
4
5

Continue reading “Using SELECT to create a range of numbers or duplicate rows – Oracle SQL”

More Oracle and Delphi posts coming soon

I just got started with this site

Ill be putting out a post every week or so as I dig through my collection of source code.

Drop by soon while I get stuck into creating more Delphi and Oracle posts

About The Author

scott_circle
The Usual Suspect
– Scott Hollows –

  • Oracle and Delphi software developer.
  • Australian Delphi User Group – Western Australia Chief Cat Herder
  • Australian Delphi User Group – President
blog email linkedinlogo

Converting Delphi Angles between Degrees, Radians and X/Y

If you need to convert angles in Delphi between degrees (0 – 360), radians and X/Y coordinates you have come to the right place.  Ill show you how to do it in just one line of code, two if you count the USES entry

angle_conversions

Continue reading “Converting Delphi Angles between Degrees, Radians and X/Y”

Open WebLoc files in Microsoft Windows with WinWebLoc free software

Do you need to open *.WebLoc files in Microsoft Windows ?
This will show you how using some free software that I developed called WinWebLoc
Continue reading “Open WebLoc files in Microsoft Windows with WinWebLoc free software”