Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by bjorneh
-
Referencing fields fetched from a cursor
Hi A classical example of a developer wanting a simple/easy way of coding something. The downside to this, is complex/unreadable/unmaintainable code. Many lines simple code is better than few lines complex code (In most situations, where you aren't dependant of having very few lines optimized...- bjorneh
- Post #5
- Forum: Oracle: All versions
-
pattern matching for sqlldr
Hi I'd use WHEN clause with WHEN (01:04) > and (01:04) < 10 I think that's possible, but if it isn't, then you could also just duplicate the WHEN clause for explicitly matching the records you are after. (After all, a wildcard is effectively not having a WHEN clause at all)- bjorneh
- Post #4
- Forum: Oracle: All versions
-
Column Order
Hi As far as I know, there is no impact on performance (noticeable) on which order you have your columns. However, a good rule of thumb, is to have the primary key columns in the table as the first columns. (These are least likely to be updated as well) What causes performance impact, is...- bjorneh
- Post #2
- Forum: Oracle: All versions
