Home » SQL & PL/SQL » SQL & PL/SQL » Extracted data is displayed in wrong format (Oracle )
Extracted data is displayed in wrong format [message #577291] Thu, 14 February 2013 01:17 Go to next message
KamalMoorthy
Messages: 4
Registered: February 2013
Location: bangalore
Junior Member
Hello All,

I use SQL to extract data from Quality Center (QC) to excel.
I have a field type String.
It contains the following values.
1) 1161, 1162, 1163
2) DHM, 162
3) DTH, 163
etc

But when i extract this to excel the data is displayed as
1) 116111621163
2) DHM, 162
3) DTH, 163

The value in the first row is displayed with out commas...

Can you please let me, know how to extract the data as it is in the field???
Thanks in Advance.

Regards,
Kamal.
Re: Extracted data is displayed in wrong format [message #577293 is a reply to message #577291] Thu, 14 February 2013 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 58481
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the correct way.
You have a bug, fix it.

Regards
Michel
Re: Extracted data is displayed in wrong format [message #577294 is a reply to message #577293] Thu, 14 February 2013 01:22 Go to previous messageGo to next message
KamalMoorthy
Messages: 4
Registered: February 2013
Location: bangalore
Junior Member
Hello Michel,
Can you please let me know, the details of the bug???

Regards,
Kamal.
Re: Extracted data is displayed in wrong format [message #577297 is a reply to message #577294] Thu, 14 February 2013 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 58481
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It does not display in the format you want.

Regards
Michel
Re: Extracted data is displayed in wrong format [message #577299 is a reply to message #577297] Thu, 14 February 2013 01:40 Go to previous messageGo to next message
KamalMoorthy
Messages: 4
Registered: February 2013
Location: bangalore
Junior Member
Hello Michel,

How to fix it? Is there any patch?
Or it has to be fixed in query?

Help me to fix it.

Regards,
Kamal
Re: Extracted data is displayed in wrong format [message #577300 is a reply to message #577299] Thu, 14 February 2013 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 58481
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, I will state it more clearly.
You did not say anything about what you did.
You did not say anything about what you have.
We know nothing but what you told us that is almost nothing.

For instance, what does mean "I use SQL to extract data from Quality Center (QC) to excel."? What is QC? Which SQL? What is your environment? Which Oracle? Which Excel?

My first answer would be: it is not an Oracle problem but an Excel one, change the format in Excel.

Please read OraFAQ Forum Guide.

Regards
Michel

[Updated on: Thu, 14 February 2013 01:57]

Report message to a moderator

Re: Extracted data is displayed in wrong format [message #577302 is a reply to message #577300] Thu, 14 February 2013 02:09 Go to previous messageGo to next message
KamalMoorthy
Messages: 4
Registered: February 2013
Location: bangalore
Junior Member
Hi Michel,
I am sorry, I dont have answers to all your question.

QC means Quality Center, it is a Tool for Test Management.
This tool allows you to write SQL quries to extract data to excel.
For the rest....I have no answer....
I am not a techie....I am a Tester.

I will check and try to provide more information.

Regards,
Kamal.
Re: Extracted data is displayed in wrong format [message #577304 is a reply to message #577302] Thu, 14 February 2013 02:18 Go to previous message
Michel Cadot
Messages: 58481
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's the plan:
1/ Get the SQL to extract the data
2/ Execute the SQL in a SQL tool (SQL*Plus, SQL Developer...)
3/ Compare the result of this execution with what you want
4/ If correct, examine the way data are imported in Excel
5/ If import options are correct, examine the cell format options

Regards
Michel
Previous Topic: Row with Subtotal
Next Topic: PipeLined Function
Goto Forum:
  


Current Time: Tue Jul 22 08:42:53 CDT 2014

Total time taken to generate the page: 0.09456 seconds