Hey this is my first Blog ...
Last month I joined new company, previously I was using C#,Asp.net at fronend and SQL Server 2005 at backend , currently I have to use C# as well as vb.net at the frontend and Oracle( which I havent used much before) at Backend , so currently I am giving time for learning PL/SQL, Today I learned some of the new functions that I want to share with you
1)bfilename : this would return physical file path if the directory is created
e.g bfilename('testdir','filename.ext')
2)group_id() : this is useful one this will retun 0 if no rows are duplicated at the group by function else will return value greater than 0
e.g select column1,column2,group_id() from table group by column1,column2
...Huh this is what I hate to type a lot......
Ok we will Continue
3)NULLIF(expr1,expr2) would match up the expressions if expressions are matched then NULL is returned else expre1 is returned
4)NVL(employeeId,'N/A') if null then replaces with N/A same as ISNULL inSQL Serever
5) NVL2(string,value if not null,value if null
6)UID returns user id
7)ASCII('Character') will return ascii value of that character
8)LPAD for Lft Padding
9)Substr('amit123',3,2) will retun 'it'
10)Translate('amit123',123,255) will return amit255
11)initcap('amit') will return 'Amit' as initial letter Capital
12)Bin_To_Num(1,0,1,1) returns number value i.e 11
thats it for today
leaving for my HomeTown................
Watched a nice movie yesterday "Unbreakable" starring Bruce Willis, Undoubtedly this is the best movie of m. night shyamlan. The end of the movie was really breath-taking and shocking.
