How to rename a tablespace in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
After update how do u know how many records got updated
What is Water Mark in Oracle?
How to insert a record into a table?
IS it possible to built the oracle database without setting the kernal parameters?
What is an oracle user role?
How to get a list of all background sessions in the database?
how to get count of tables in particular database in Oracle?
How to join two tables in a single query using oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
The join defined by the default data link is an outer join yes or no ?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this