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 |
Explain the difference between a procedure and a function?
How to apply filtering criteria at group level in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What are the types of trigger in oracle?
Is oracle a relational database?
create one table to capture an employee details with a primary key.
What privilege is needed for a user to delete rows from tables in another schema?
What are inner join and outer join?
What is RULE-based approach to optimization ?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
What is concurrency in oracle?
How to select all columns of all rows from a table in oracle?