Search:

SUBSTR (last_name,-1,1)='n'
it will return the last leter of the string

first the insert query should be used then the truncate one,,, otherwise table data will not get copied

Yes i have googled it, it says grid computing provide
resource sharing and automatic load balancing
eg: if database server is full it will create another... This is the idea i got after reading

In oracle 10 g 'g' stands for grid technology but what exactly is the meaning of grid technology..
can somebody tell

The query can be done but there is no way to write a single query for your requriment

select to_char('2'||phone) from <tablename>;