You can include dynamic SQL in a SELECT statement in Oracle 12 by using an embedded function. Ill show you how
Learn how to copy pages between applications in different ApEx repositories.
Oracle ApEx allows you to export pages, but you can only import them into the same application in the same repository. If you try to import into another application or another repository you will get an error.
This page was exported from a different application or from an application in different workspace. Page cannot be installed in this application.
I’ll show you a simple workaround for that limitation
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
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
The Usual Suspect
– Scott Hollows –
- Oracle and Delphi software developer.
- Australian Delphi User Group – Western Australia Chief Cat Herder
- Australian Delphi User Group – President