-
Hi folks
I want a comma or tab or || delimiter file output for the data
generated thro a querry from two tables.Qry is simple sql querry
and i need to use this output to import into excel spread sheet
so guys help me on this its very urgent
thanks
SAT
sat
-
why not use:
select col1 || ','|| col2...
from tab1, tab2
...
-
hi sysdba,
can i import this into excel spread sheet .
sat
-
if you know how to import comma separated files (csv) sure.
-
HI sysdba,
THANKS a lot..i did imported into
excel worksheet .Now how can i trim the blank spaces
in columns which are i mean if datalength is varchar2(200)
and only few letters were occupied how can we trim this
thanks again
sat
sat
-
delimiters VERY URGENT
Hi there,
i often use msaccess to get data from oracle tables and import access tables into excel files. By this way, you don't have to worry about sql code writting.
jn
-
select rtrim(col1) || ',' || rtrim(col2) ...
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|