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
- 3 Answers
- 4324 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / david
select substr(filename,1,6),data from table1;
tjis is ur solution ..if any confusion regards this question
plz post there...
thanks
gunjan david
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to convert characters to numbers in oracle?
Can you create a synonym without having a table?
Explain an integrity constrains?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How can we delete duplicate rows in a table?
How to call a stored function with parameters?
How to turn on or off recycle bin for the session?
What is a dead lock in oracle?
How do I find the database name in oracle?
When do we use group by clause in a sql query?
How do I uninstall oracle client from windows?
What is a nvl function? How can it be used?
various types of hints and their usage
How to create a new table in your schema?
What is the difference between a primary key & a unique key?
