Oracle - Problematic Wish List

by Syed Aziz ur Rahman 21. November 2005 00:57
This is not a wish list like khurram use to post about different things. This is not a list of problems fahad use to post about oracle. This is a problematic wish list. Some solved, some left, some in searching phase, and some waiting for your comments so do comments the solution or add a problematic wish.
No bool datatype
Currently I am handling it in Business Objects by converting integer into boolean in properties
Auto generated column
I have to make one sequence for every table that have auto generated primary key.
CamelCase Naming convention
Oracle saves the table names in UPPER CASE. Initially I was having name like this LONGCONTRACTPAYMENTS :). The normal convention I have found is LONG_CONTRACT_PAYMENTS. Now I am following the same convention.
Long/Big Names
I cannot name a table like LONG_CONTRACT_PAYMENTS_DETAILS. I have to do it like LC_PAY_DETAILS. Cannot have big names.
Drag Drop ERD Diagrams
After some searching and going through the tools, I came to know that Toad 8.5 provide this but with limited functionality not like SqlServer Database designer. Toad has a model view as well to generate queries as we have in SqlServer.
Changing order of columns
What if I want to change the order of columns in a table. I cannot find a simple way. Same Toad8.5 comes for the rescue. It uses a little trick by making a new table with the changed order and transferring the data, renaming the old and new tables. You may be thinking why the hell I want to change the order of columns. Bottom line is : Put the mostly selected columns first. The select query will be faster. I have read it somewhere, do not remember the link now.
After some searching I found that Oracle has its own globalization client/server architecture i.e. you have to specify character sets for both database and the clients who will access it. I put UTF-8 for both. Now I can save/view Arabic data through my application as well the Oracle Enterprise Manager but SQL-PLUS and Toad is showing corrupted data. I do not know the remedy now but happy that now Arabic data can be handled in my app.

May be for you guys this is a small issue but here in Saudi Arab, this is THE MOST critical issue. You know globalization, you can understand arabization but you might be thinking what is Saudization. The term is used when we are using pure Saudi Arabi's Arabic :). May be you people can call it urduization in general and pakistanization or better pakization :).

Bottom Line
Now I know why oracle guys are paid more because oracle is difficult because it is difficult to do small things in oracle easily. :). My tip is: after trying different clients tools, I think Toad is far better than others.



Comments (4) -

11/21/2005 8:37:11 AM #

Start an article at wiki website... I will participate....

11/21/2005 2:33:24 PM #

I must appreciate the post by Aziz about Oracle. I am specifically refering to ...
Now I know why oracle...

11/21/2005 2:43:45 PM #

FK, i will be happy if you add some more problematic wishes or solve some . Where do you want to create wiki? yours or khurram's (the one for community, donot remember the link now)??

11/21/2005 2:51:56 PM #

I must appreciate the post by Aziz about Oracle. I am specifically refering to ...Now I know why oracle...

Purchasing Viagra
Purchasing Viagra
9/30/2013 10:57:56 AM #

Performance anxiety is a psychological issue that many men will suffer from on occasion; however, it becomes a problem when an overwhelming sense of anxiety is associated with doing the deed, thus reducing both performance and pleasure. Some men are so concerned about making their partner see fireworks that they essentially psych themselves out, which is a sure-fire way for the evening to become a disappointing dud. The big problem with performance anxiety is that it feeds upon itself and can set the stage for a negative self-fulfilling prophecy.

Visit this webpage for more  Purchasing Viagra - www.arcadegame-info.net/.../%E5%88%A9%E7%94%A8%E8%80%85:MWHTanesha .

voyance gratuite
voyance gratuite
10/26/2013 5:39:31 PM #

It's truly very difficult in this full of activity life to listen news on TV, so I simply use the web for that purpose, and take the hottest information.

Have a look at my homepage  voyance gratuite - http://www.lavoyance-gratuite.fr

voyance par telephone
voyance par telephone
10/26/2013 10:56:59 PM #

Hey! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no backup. Do you have any solutions to stop hackers?

my web page -  voyance par telephone - http://www.astralum.com

voyance canada
voyance canada
10/27/2013 5:23:28 AM #

Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your website? My website is in the very same area of interest as yours and my visitors would truly benefit from a lot of the information you present here. Please let me know if this alright with you. Cheers!

Here is my blog post ::  voyance canada - http://www.etoilesvoyance.com

10/27/2013 11:11:13 AM #

Incredible points. Sound arguments. Keep up the great spirit.

Here is my weblog ...  voyance - http://www.voyancetarots.com

videncia gratis
videncia gratis
10/29/2013 4:43:48 PM #

Hey There. I found your weblog using msn. That is a very well written article. I'll make sure to bookmark it and return to read more of your helpful information. Thank you for the post. I'll definitely return.

Check out my blog ...  videncia gratis - http://www.directotarot.com

voyance par telephone
voyance par telephone
11/1/2013 2:50:24 AM #

This is the perfect website for anyone who wants to find out about this topic. You realize so much its almost hard to argue with you (not that I really will need to…HaHa). You definitely put a fresh spin on a subject that's been discussed for ages. Great stuff, just wonderful!

my weblog ::  voyance par telephone - http://www.totalevoyance.com

Powered by BlogEngine.NET
Original Design by Laptop Geek, Adapted by onesoft