No question at this time
DBA Top 10
1 M. Cadot 13000
2 B. Vroman 11900
3 A. Kavsek 11200
4 J. Schnackenberg 5600
4 M. Hidayathullah ... 5600
6 T. Boles 5400
7 P. Wisse 3200
8 T. P 700
9 A. Rai 600
10 R. Wauben 500
10 H. Steijntjes 500
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 users48147
Total active users1697
Act. users last 24h6
Act. users last hour1
Registered user hits last week261
Registered user hits last month1385
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, 103 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, 102 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, 102 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