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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ajit nayak
select substr(filename,1,instr(filename,'-',1,1) - 1) from dual;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mohamed shafee
select left(filename,6),data from table1
or
select convert(varchar(6),filename),data from table1
Is This Answer Correct ? | 0 Yes | 2 No |
How do I spool to a csv formatted file using sqlplus?
what is query and types of query
how to do daily transactions with out sql* loader control file regesterd in apps?
What are the system predefined user roles?
what is the difference between data migration and production migration.
What is user managed backup in Oracle?
What is a select query statement in oracle?
What is SQL Tuning Advisor in Oracle?
Is there a function to split a string in plsql?
The join defined by the default data link is an outer join yes or no ?
what is the difference between dbms and rdbms?
What do you mean by merge in oracle and how can we merge two tables?