1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / mohamed shafee

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is java oracle used for?

527

What is the scope of a local variable?

585

How to save query output to a local file?

563

How to drop a tablespace?

574

Explain the use of rows option in imp command.

604




What is Data Dictionary Cache in Oracle?

664

What is sharded cluster?

520

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1927

How can you merge two tables in oracle?

569

How to invoke the data pump export utility?

565

What are the different pseudo commands? Explain in general?

541

What is logical backup in oracle?

580

Differentiate between pre-select and pre-query?

624

How to create a new oracle data file?

560

What is set verify off in oracle?

581