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
- 2 Answers
- 4241 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suman rana
SELECT REGEXP_SUBSTR (filename, '[[:alpha:]]+') filename, data
FROM (SELECT 'AFGDFD-20112011' filename, 'hi how r u' data
FROM DUAL
UNION
SELECT 'bsdasd-23042011', 'name shoud be in bold' FROM DUAL)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ajit
select substr(file, 1, instr(file, '_',1,1) - 1) file, data from <table name>;
| Is This Answer Correct ? | 1 Yes | 0 No |
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
How to generate query output in html format?
What is primefaces used for?
What are the various constraints used in oracle?
What are the limitations oracle database 10g xe?
Explain a data segment?
How do we get field details of a table?
Is java required for oracle client?
What is a recycle bin in oracle?
what is insert all statement in sql
Does a Before form trigger fire when the parameter form is suppressed ?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
Oracle General 
