Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

13 August 2011

Remove quotation marks on field names of table while Database generation using Power Designer.

It is time consuming to find the solution, so here is the working result.

click Database
edit current DBMS
go -Script
-Sql-Format-CaseSensitivityUsingQuote,

then set the CaseSensitivityUsingQuote security to “NO”

this is all to remove quotation marks from fields.

Enjoy.

20 March 2009

ALL I LEARNED

Hi,

I am dealing with JEE and Java Development since 2006 June, in a large-scale marketing&telco company.

Time to market companies have common property, this is speed.
This speed word, can harm software development soul therefore it is quite hard to be a soldier in such an army. But this teaches you; discipline should be your guide.

My experiences, mistakes, faults, successes teach me several rules, in this very short(or very long) time period.

I've decided to note tens of them on my web log. If you want to earn yourlife as a developer, at least you should read them.


1. Never give a deadline , until you understand what is your task.
2. Never start to code , until you pretty sure about your development plan.
3. Arrange meeting(s) to yourself for just thinking on exceptions after development ends, and while development continues.
4. Test it, Do Test it, Do Test What you create. Test Yourself.
Never, Never, Never Trust Your QA Member.
5. Documantate what is going on, with all details but with 0(zero) unnecessary information. Your document should not be documented at the end. It should be a living period. It should start at the first day and you will not say documentation is finished until you put your code to the production.
6. Never give any support until He or She(Analyst,Tester,Developer,Support Member,Operation Contact..) right to ask it.
7. Never forget to report, any unplanned task.(Mail,Defect,Question)
8. Feel free to remove any detail,that makes you un-disciplined
9. Be Cool, Never hurt any of your colleague. Please do not forget, any of us can make mistake. Mistakes are temporary, but words are long lasting.
10. Lastly, but certainly not the least; Keep Yourself UPDATE!!! Always search for innovation.

I know the question will come as; WHEN?
Believe, it is more expensive otherwise :)

01 February 2007

Ooooooo racle Hint!!

Cardinality is the predicted number of rows.
Game is like that;

Step 1: Give me the conditions..
Step 2: Hımm.
Step 3: CBO Guess the # of Cardinality.

Yes the Result of the Guess is Cardinality.
And Taking this into consideration Oracle Makes Plan.

But You May spoil the game.
While he is in step 2 you can say: "Answer is 14." "hıhıhıhı"

Then it works as you want.

select * from audience where month_no = 12;
here cardinality is 100

but i know the result; it is 106 for month_no = 12
then...

select /*+ cardinality(x 106) */ * from audience x where month_no = 12;

Quick Result: I am Smarter than CBO and I can give cardinality as a hint ;)