Technical Blog

Pages

▼
Showing posts with label SELECT. Show all posts
Showing posts with label SELECT. Show all posts
Oct 29, 2010

To get only numeric values

›
To  retrieve only numeric values from both numeric& character value In 10 g Select  regexp_replace(regexp_replace('5RTYDDB',...
May 28, 2009

Some Good Queries

›
To get size of a table select segment_name table_name,sum(bytes)/(1024*1024) table_size_meg from user_extents where segment_type='TA...
›
Home
View web version
Powered by Blogger.