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

Answer / ajit nayak

select substr(filename,1,instr(filename,'-',1,1) - 1) from dual;

Answer / mohamed shafee

select left(filename,6),data from table1
or
select convert(varchar(6),filename),data from table1

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

How to create a table index in oracle?

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

0 Answers  

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

0 Answers  

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---

structural difference between bitmap and btree index ?

1 Answers   Infosys,

---

how to find the second highest salary in a given table????

5 Answers  

---

Explain table?

0 Answers  

---

How do we know whether an index is created on a table ???

2 Answers   TCS,

---

How to get a list of all tables in the database?

1 Answers  

---

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,

---