-
Archives
Recent Comments
- Michael on How to build a Wireshark plug-in
- Simeon on How to build a Wireshark plug-in
- Michael on How to build a Wireshark plug-in
- Simeon on How to decode the Nikon DSLR firmware
- Barry on How to decode the Nikon DSLR firmware
Category Archives: SQL
When removing columns rebuild your views
If remove a column from a table in your Oracle DB, and you have a views that select * from tablename, you need to recreate the view. I was comparing my old schema and new schema, and had all the … Continue reading
Posted in SQL
Leave a comment
Slow sub-select maybe LAG or LEAD might help
One of the queries in our application is used to edit event entries. Event entries have a start time and an end time, but when they are processed from the data files, they can be entered with just a start … Continue reading
Posted in Programming, SQL
Leave a comment
Oracle’s Lag in MS SQL Server 2005
I am currently porting our new database from Oracle 10g to MS SQL Server 2005, and I have it all done except the views that use the Oracle LAG and LEAD functions (non-ANSI). What these functions provide (for the MS … Continue reading
SELECT * FROM USER_ERRORS
The most important Oracle pl/sql right now is: SELECT * FROM USER_ERRORS I’ve been “developing” some new functions, and I was getting sick and tired of being told: Warning: execution completed with warning function MissingProd Compiled. Now I can know … Continue reading
Oracle SQL Developer
Having been developing my PL/SQL in Toad Data Modeler, and running via a customer VB program, the debugging effort has been poor at best. A co-worker pointed me to Oracle SQL Developer, it’s in the league as MS SQL Server … Continue reading
