How to insert using Cursor in Oracle

Being a .net technologies guy I never be go on database level. but last night I have to face a small problem . I have to done 50000 record entries in one of table with relation to parent table. I used Pl Sql cursor. You already know much about Cursor they exists both in Oracle [...]

Pl Sql Built in Functions

hi find these build in function for orcale pl sql , These are really usefull Function Description String Functions upper(s), lower(s) convert string s to upper/lower-case initcap(s) capitalise first letter of each word ltrim(s), rtrim(s) remove blank char. from left/right substr(s,start,len) sub-string of length len from positionstart length(s) length of s Date Functions sysdate current date (on Oracle server) to_date(date, format) [...]