Viewing 15 posts - 1 through 15 (of 26 total)
I converted Jeff's algorithm for determining ISO dates to Oracle, but it was only a matter of translating the algorithm. In the case of the splitter, the purpose was not...
September 7, 2022 at 6:57 pm
Another excellent article. I am currently working on a budgeting application in Oracle and decided to use these concepts in Oracle. WARNING: For anyone else wanting to use these concepts...
July 28, 2022 at 8:26 pm
As someone who has been around too long, I know the purpose of the semi-colon. It is to define the end of a statement. It is possible to put several...
February 2, 2022 at 3:38 pm
Examples of CTE's with semicolons has always bothered me. I started out in Oracle and the semi-colon is required and it only took about a year to finally include it...
January 29, 2022 at 10:27 pm
I indicated that the need for a cursor is rare but you need to be willing to use them. If you need to update 6 tables based on the data...
October 19, 2021 at 8:19 pm
9. How many loops were used to determine duration and is it clock or cpu time.
10. Was the load on the system constant like in a stand alone database on...
October 19, 2021 at 7:05 pm
I believe that the fast forward cursor of SQL Server is a great tool to use if, and only if, multiple actions need to be taken on each record returned. ...
October 19, 2021 at 7:00 pm
I am sorry for the late response and don't know if you are still looking for an example. By definition, a critical part of conceptual modeling is identifying the unique...
May 31, 2021 at 3:19 am
Since you are illustrating your process using a physical database, I think it would be instructive to include primary and foreign keys on your normalized tables to enforce your normalization. ...
February 22, 2021 at 5:28 pm
Great article, Sucharita. The explanation of these 4 normal forms is clear and concise. As Scott said, normal forms are a conceptual construct but I believe this analysis is useful...
February 9, 2021 at 4:15 pm
Nice article on cursors. I agree that cursors should be avoided when a simple set based operation can accomplish the task. By that I mean use INSERT INTO/UPDATE...SELECT ... FROM. ...
November 19, 2020 at 2:55 pm
Why don't the developers just lobby to use only JSON files. They are a lot cheaper. The developers can write the application to do what they usually ask the database...
November 3, 2020 at 4:38 pm
This was removed by the editor as SPAM
November 3, 2020 at 12:52 pm
If you are interested in returning all the values of Result and there are only two possible results, return Min(Result) and Max(Result). If there are more than 2 possible Result...
October 14, 2020 at 4:08 pm
Thanks, George. Put it on my account. On account I aint gonna pay. 😉 Or open an account on the Bank of San Seriffe and we will let Don Knuth...
September 3, 2020 at 5:59 pm