No question at this time
DBA Top 10
1 M. Cadot 17900
2 A. Kavsek 15900
3 M. Hidayathullah ... 9200
4 B. Vroman 8600
5 T. Boles 4900
6 P. Wisse 4700
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1400
10 A. Hudspith 800
10 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48079
Total active users1704
Act. users last 24h9
Act. users last hour0
Registered user hits last week295
Registered user hits last month1831
Go up

Query Output Format
Next thread: sqlldr ORA-01722: invalid number
Prev thread: Move partitions of table to new tablespace

Message Score Author Date
Hi, Anyone can help on sql statement query. ...... Ferdie Palero Nov 10, 2017, 14:21
select reguserid, success_timestamp, null as faile...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Tim Boles Nov 10, 2017, 17:26
Hi Tim, Working this all I need you save me. Th...... Ferdie Palero Nov 11, 2017, 11:25

Follow up by mail Click here


Subject: Query Output Format
Author: Ferdie Palero, Philippines
Date: Nov 10, 2017, 14:21, 12 days ago
Os info: Centos Linux
Oracle info: Oracle11g
Message: Hi,

Anyone can help on sql statement query.

Table : success_timestamp
REGUSERID SUCCESS_TIMESTAMP
--------- ----------------------
10004770 26 Oct 2017 12:39:33
10004770 26 Oct 2017 16:50:45

Table : failed_timestamp
REGUSERID FAILED_TIMESTAMP
--------- ----------------------
10004770 26 Oct 2017 12:40:35

Output :
REGUSERID SUCCESS_TIMESTAMP FAILED_TIMESTAMP
--------- ---------------------- ----------------------
10004770 26 Oct 2017 12:39:33
10004770 26 Oct 2017 16:50:45
10004770 26 Oct 2017 12:40:35

Thanks in advanced.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Query Output Format
Author: Tim Boles, United States
Date: Nov 10, 2017, 17:26, 12 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: select reguserid, success_timestamp, null as failed_timestamp from success_timestamp
union
select reguserid, null as success_timestamp, failed_timestamp from failed_timestamp;
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Query Output Format
Author: Ferdie Palero, Philippines
Date: Nov 11, 2017, 11:25, 11 days ago
Message: Hi Tim,

Working this all I need you save me. Thank you very much.

Regards,
Ferdie
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here