No question at this time
DBA Top 10
1 M. Cadot 15900
2 B. Vroman 15500
3 A. Kavsek 10000
4 T. Boles 6800
5 J. Schnackenberg 5800
6 M. Hidayathullah ... 3900
7 P. Wisse 1800
8 T. P 700
9 B. Derous 500
9 R. Wauben 500
9 H. Steijntjes 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48208
Total active users1645
Act. users last 24h7
Act. users last hour0
Registered user hits last week163
Registered user hits last month788
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, 222 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, 222 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, 221 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