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 [...]

Read Full Post »

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)
date formatting

Number Functions

round(x)
round real number x to integer

mod(n,p)
n modulus p

abs(x)
absolute value of x

dbms_random.random()
generate a random integer

Type Conversion Functions

to_char()
convert to string

to_date()
convert to date

to_number()
convert to [...]

Read Full Post »