Somebody wanted to know how to find any non-unique indexes in MySQL. The query takes a session variable with the table name and returns the non-unique indexes by column names. It uses a correlated subquery to exclude the table constraints.
You set the session variable like this:
SET @sv_table_name := 'member_lab';
You can query the indexes result with the following query:
, s. (more...)
It seems that the most popular PHP frameworks are: Laravel (1st), Phalcon (2nd), and Symphony2 (3rd). I found the following graphic (from December 2013) that highlights popularity by percentage of the market (though I can’t (more...)
Ever want to run a Stored Procedure or a PL/SQL anonymous block and just want to "print out" the results of a query ? Even as a little bit of debug information?
In Oracle 11g you have to create a SQL*Plus REFCURSOR variable and then bind it within the anonymous block or pass it as an argument to a procedure/function. Run the code and then print the refcursor.
This requires a bit of know how in (more...)
I finally upgraded from VMware Fusion 6 to VMware Fusion 7 to take advantage of the new features. It was interesting to upgrade the Windows 7 virtual machine because of the unique failure message it raised. The message said it was incompatible, and that I should navigate to:
Virtual Machine -> Settings -> Compatibility -> Upgrade
The Upgrade button checks the Allow upgrading the virtual hardware for this virtual machine checkbox. You will get prompted (more...)
Rows to String
Just a note about a powerful way to convert a column of values in a query into a coma separated list in a text string:
select 'LISTAGG' fx,
within group (order by table_name) ),
listagg(table_name, ',') within group (order by table_name)
We've struggled to figure out what to call this next generation of video delivery. Is it "video on demand?" The industry insiders are very specific in calling it TVOD and SVOD, which stands for transactional and subscription video on demand respectively. Transactional video on demand means that consumers can buy or rent a video and watch it on their device. Subscription video on demand means that consumers buy a subscription and they can watch (more...)
People will commonly ask me this question, which has a very wide range as the answer. You can get an app build on oDesk for nearly free - i.e. $2000 or less. Will it provide the functionality you need? It might! Do you need a website that does the same thing? Do you need a database (i.e. something beyond the app) to store your data for your customers?
Our first round of apps (more...)
When I first heard about Amazon's offering called CloudFront I really didn't understand what it offered and who would want to use it. I don't think they initially called it a content delivery network (CDN), but I could be wrong about that. Maybe it was just something I didn't think I needed at that time.
Amazon states it well today (as you might expect). The offering "gives developers and businesses an easy way to distribute (more...)
A recent question on the Oracle-L mailing list was about generating dates in a given period. If you had a string like 'MWF', all Mondays, Wednesdays and Fridays between the from- and to-dates should be generated.
That reminded me of a quiz on plsqlchallenge.com
I did on using DBMS_SCHEDULER.EVALUATE_CALENDAR_STRING. I had created a table function to test calendar expressions - that might be useful for something similar to what was asked on the (more...)
It's Christmas time... It's a time for giving... It's a time for warm-hearted feelings...
But there are people battling for their lives against cancer, who may not have much energy left to enjoy the holidays. Almost everybody has family or friends whose life has been impacted by cancer. Let us all reach out however we can, help wherever we can, and let good thoughts go out to the victims.
All cancer is terrible - but (more...)
It's amazing how much work goes into a one page website these days! We've been working on our new version of our website (which is basically one page) for the last month or so. The content is "easy" part on one hand and the look and feel / experience is the time consuming part. To put it another way, it's all about the entire experience, not just the text/content.
Since we're a video company, it's important that they (more...)
Most every startup that I've watched (and been part of) has grand plans of virality. Build it and they will not just come to you, but they will flock to you! There is a dream that what you have built is going to change the world and it's going to be so obvious to everyone that they will want to share the news with all of their friends. It's a good dream and there is (more...)
Nikolay Savvinov hat vor einiger Zeit einige Artikel veröffentlicht, die sich damit beschäftigen, dass DML-Operationen für Blocks einer Größe von 4K eine deutlich schlechtere Performance liefern als entsprechende Operationen für Blocks der Standardgröße (8K). Hier eine Liste der Artikel:
Ich spare mir eine detaillierte Zusammenfassung der Artikel und springe gleich zur Pointe, die der Titel des letzten (more...)
Since we dropped our beta out of SQLDeveloper 4.1
and announced SDSQL
, we've been busy getting some of the new things out to users. We support SQL*plus editing straight out of the box, but one thing that was always annoying was the time when you make a mistake and can't fix it to you have finished typing to go back and add a line like this.
This was always the way as console (more...)