I finally decided to save a script that cleans out a couple of tables for me.
Now I have a script, how do I run it in SQL Dev? In SQL*Plus, I would run it like @clean_tables. Two things to note there, 1, I didn't have to put the extension on the file and b, I assumed SQL*Plus was running from the directory where my file was located. If I was running the script from a different directory, I would have to use either a relative path...or something, but I digress.
It's been a while since my last blog post but as I'm now looking for my next Oracle contract (hopefully Apex again purrrlease) I've a little time on my hands. So I thought I would share with you my latest creation. It's a variation on the Treadputer which is basically a treadmill adapted for use as a standup desk - you simply work and walk at the same time. Yes I know it seems a little crazy but here's a picture of mine.
Wie jedes Jahr in den letzten sechs Jahren, veranstalten wir (Dietmar Aust und ich) unser
Training in Bensheim an der Bergstrasse. Wir werden unsere bisherigen Themen überarbeiten und einige neue Themen hinzufügen. So werde ich auch folgende neue Themen in das Programm der Schulung aufnehmen:
- jQuery (Beispiele und Übungen)
- APEX Collections
If you write a lot of PL/SQL code, sooner or later you will be faced with a requirement to count the number of occurrences of a substring in a string. In that case you may use this example to help yourself:
It will search not only for a single character withing a string but also for a substring of any length up to 4000 characters.
Did you know that an authentication function in APEX is not used the way a function actually should be used. Normaly, this function has two input parameters and it will return TRUE or FALSE. However, you will name this function in your authentication schema by typing it into a box, without providing any parameters. I have never looked into that but my assumtion is that APEX will probably create a kind of a dynamic function call by prividing the parameters using login items (:p101_username, :p101_password) from your login page (101).
I already posted a forum entry to the topic but no one had answered yet. I think the bug is a real problem so people should know about it:
Here are the details:
Automatic browser language detection can not be used in APEX applications during their runtime.
(First off, sorry Mike, I'm hoping this will break my writer's block...)
On Friday I was asked to look at a report that wasn't returning all of the data. Sample:
Year/Month Total Sales Total Sales (YAGO)
01/31/2013 $1,000,000 $900,000
For reference, YAGO is "Year Ago."
Notice anything funny there?