| Extracted data is displayed in wrong format [message #577291] |
Thu, 14 February 2013 01:17  |
 |
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 #577300 is a reply to message #577299] |
Thu, 14 February 2013 01:57  |
 |
Michel Cadot
Messages: 54712
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 #577304 is a reply to message #577302] |
Thu, 14 February 2013 02:18 |
|
Michel Cadot
Messages: 54712
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
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
