Sunday, August 29, 2010

My weak concepts...

constraints for calling functions in sql


how to commit in trigger
Error Hadling
Pass by value, Pass by reference, Nocopy
Default values
Overloading : what can be different? Return type?
Can procedure have a return clause?
Reference data types?
PL/SQL collections
Bulk collect
Forall
restrict reference : purity level
In cas of Set oprators what if datatype diff in two queries?
does decode ignores null?
Possible: decode(gender, ' Male',1,'Female', 'F')?
Database Triggers?

select
having
group by

update

Followers

About Me

My photo
I think. A lot. Logical. Try to be fair and Neutral. A patriot. Contemplated a lot about Sanatan Dharama and Logically understood many of its seemingly strange aspects, which I took up so far. Concluded that rest of it is definately correct as well. This life is too short to understand even just few % of it logically. So all (east west north south of Dharati) of us must just follow its implementation suiting to respective part of the planet. Hence spiritual. Believe in concept of Bharat.Cherish its past glory. Blood tear for all wrongs happened and happening later on and now. Much more about me..... (feel free to contact!)