Tech. Biz. Culture. Law.
Ok, so listen … there’s no time to waste. Things are happening way too fast.
First, this site is about a bunch of people I know – family members, friends, and acquaintances of mine – who are outrageously talented in the most amazingly diverse ways imaginable. I want to brag about them all. And I will. And I guess that’s all you need to know for now.
More later as we get going. And I’m telling you that now so I can blab out the next post …
Nail, nail, nail, nail. Gerhunk. WHAM-O! Click.
In my book OCA Oracle Database SQL Expert Exam Guide (Exam 1Z0-047), I mention the use of something called “dynamic SQL” on page 391. I’ve since received some email asking for more information about it. The concept I was referring to with the phrase “dynamic SQL” is simple: write software code to create SQL statements in real time, based on the logic within the script. A typical use in many websites today is to create some sort of code using PHP or Perl to display an HTML page, ask the user questions, and then issue a custom-written SQL statement to interact with the database accordingly. An example might be to create an HTML page that displays a form:
<html>
<head>
<title>Sample Form</title></head>
<body>
<h1>Click Display list of customers</h1>
<form id="form1" name="form1" method="post" action="test.php">
Choose order for displaying the results:
<select name=parm_OrderBy>
<option value="DESC" selected>Descending
<option value="ASC">Ascending
</select><br>
<input type=submit value='Display Results' />
</form>
</body>
</html>
The form might appear this way:
This HTML could then invoke a PHP script that looks something like this:
<? php
... receive incoming parameters ...
$vQuery = "SELECT FIRST_NAME, LAST_NAME FROM CUSTOMERS ORDER BY LAST_NAME"
if (parm_OrderBy == "DESC")
$vQuery .= " DESC";
... run query ...
?>
The idea is that the PHP script is bulding a text string in the $vQuery variable that may or may not include DESC after the ORDER BY, based on the value selected in the HTML form.
This is obviously just a very simple example. You can use much more complex code structures to build a variety of SQL statements, including SQL statements that may or may not include joins, GROUP BY clauses, and more. It’s just a matter of building text strings based on input, nothing more.
So that’s it! Now you know what dynamic SQL is about.
Happy developing!
And now for something completely different … if you haven’t seen the 2009 blog post of “Hey Jude” flowcharted, you owe it to yourself and your technical education to check it out:
It’s a classic. And if you really like it, you can even order a print:
Order Prints of Hey Jude Flowcharted
Way cool.
I’ve received a number of requests for an electronic copy of the SQL scripts in my book, OCA Oracle Database SQL Expert Exam Guide (Exam 1Z0-047). I’ve emailed them to readers who have asked. And I’m probably overdue for publishing them here in this blog. So … now you can!
For info, visit the SQL Scripts page!
Enjoy! And as always, please let me know if you have any questions!
Steve
soh@corbinian.com
Hello out there … the Skere9 world is taking shape, slowly but surely … the Skerinators are working in the background to hammer the dots and cross the eyes and get the parts connected and the parameters passing and all the cool nifty bells and whistles … uh … well … belling and whistling, I guess. Yes, that’s it. BUT – you wouldn’t necessarily know all of that because the work so far has been in the background, but WAIT … more is coming soon …
Stay tuned.
The Skere9 wiki is now alive and well – for more information visit the Wiki page.
This is the first blog post of the new Skere9 website! Here we go!
And now for something completely different.
Jesus was wandering around Jerusalem when he decided that he really needed a new robe.
After looking around for a while, he saw a sign for Finkelstein, the Tailor. So, he went in and made the necessary arrangements to have Finkelstein prepare a new robe for him.
A few days later, when the robe was finished, Jesus tried it on — and it was a perfect fit! He asked how much he owed.
Finkelstein brushed him off: “No, no, for the Son of God there’s no charge! However, may I ask for a small favor. Whenever you give a sermon, perhaps you could just mention that your nice new robe was made by Finkelstein, the Tailor?”
Jesus readily agreed and as promised, extolled the virtues of his Finkelstein robe whenever he spoke to the masses.
A few months later while Jesus was again walking through Jerusalem , he happened to walk past Finkelstein’s shop and noted a huge line of people waiting for Finkelstein’s robes. He pushed his way through the crowd to speak to him and as soon as Finkelstein spotted him he said: “Jesus, Jesus, look what you’ve done for my business! Would you consider a partnership?”
“Certainly,” replied Jesus. “Jesus & Finkelstein it is.”
“Oh, no,” said Finkelstein.”Finkelstein & Jesus. After all… I am the craftsman.”
“I understand, Mr. Finkelstein, but I am the son of God,” Jesus replied.
The two of them debated this for some time. Their discussion was long and spirited, but ultimately fruitful. They finally came up with a mutually acceptable compromise. A few days later.. the new sign went up over Finkelstein’s shop:
(Scroll down …)
(Scroll down …)
HA!
I was honored to be a panelist on the television show White House Chronicle, which was broadcast last weekend, and in what I believe to be a somewhat unusual step, is being re-broadcast again this weekend. The show is also published online at the show’s website, White House Chronicle.
I had a total blast doing that show! I was very honored to be invited, and I was immensely impressed with the outstanding professionalism and integrity of everyone associated with WHC. And the other panelists – Bob Franken and Lauren Ashburn – are top notch in their respective areas of expertise and beyond. I was definitely with a very illustriuous group and it was a great privilege to be included.
One surprise to me was how incredibly funny everyone was! Llewellyn King is to be credited for a good-natured spirit that he instills in the show, a process that begins long before the show’s taping and made the entire experience very fun for me. It’s to his credit that the show is both relaxed and energetic at the same time, a rare combination that’s hard to foster, yet Llewellyn King makes it look easy. He’s well established as one of the most respected journalists in the business, but I’m not sure everyone is fully aware of what a great wit and fun individual he is.
Linda Gasparello exhibits great insight, and I know her to be quite innovative. Both she and Llewellyn are in tune with the quickly evolving state of technical changes in the industries of media and broadcasting, and the world at large. They recognize the current changes before other mainstream news outlets, and more than that, they recognize the potential implications in the future. Yet they are gracious enough to allow their guest panelists to share the spotlight. Each one of us had valuable contributions to share, all of which is to the credit of Mr. King and Ms. Gasparello.
Speaking of my fellow panelists, Bob Franken needs no introduction to news “consumers” like me, he’s one of the most accomplished journalists in the industry with impeccable credentials, not to mention a fantastic personality off camera as well. His insight into the state of technology goes far beyond what was able to be represented in this brief but power-packed broadcast, it was evident to me from the moment we all arrived at the studio that he’s on top of the major trends and more importantly – understands their implications and how best to navigate the future. And if Bob and Llewellyn ever decide to do a stand-up comedy act, I’ll be the first in line to buy tickets.
Lauren Ashburn is one of those remarkable and rare people to be a visionary and also to do something about it. She recognized the power of video on the web before most in the biz and oversaw USA Today’s work in that area while others were still figuring out what was going on. Many people talk the talk, Lauren is one of the rare few who have impacted the industry for the better in substantial ways. And if you happened to notice how much the camera loves her – and it does, everybody knows that – I can tell you this: she is even more of a babe in person. Yes, it is possible, I’m a witness.
If you view the program, you’ll see that I had a camcorder running during the broadcast itself. I began filming several minutes before the show began, and caught some interesting discussion before and after what you see in the broadcast. I’ll be coordinating the publication of that footage with the good folks at WHC in the very near future. Keep an eye out for it, and in the meantime, if you wish to be notified when it’s up, just follow me on Twitter, or send me a request via our online form, and I’ll be sure to let you know.