Re: select sysdate from dual@othermachine not works!!!
- From: Igor Neyman <igor.neyman@xxxxxxxxx>
- To: verma.labs@xxxxxxxxx
- Date: Tue, 30 Mar 2010 13:03:06 -0400
Create a view on the "other machine":
CREATE OR REPLACE VIEW omSYSDATE
AS SELECT sysdate FROM dual;
and then:
select sysdate from dual
union all
select sysdate from omSYSDATE@othermachine;
Igor
On Tue, Mar 30, 2010 at 12:49 PM, AMIT VERMA <verma.labs@xxxxxxxxx> wrote:
>
> How can I check system date of other box using Oracle Query. I have two
> box's, on both of them Oracle 10g is installed while running the below
> command is gives the same output where there is difference in the time.
>
> *Command 1:*
>
> select sysdate from dual
> union all
> select sysdate from dual@othermahine;
>
>
> *Command 2:*
>
> select sysdate from dual
> union all
> select sysdate@othermachine from dual <dual@othermahine>;
>
>
> Please advice.
>
> --
> Amit Verma
> v.amit84@xxxxxxxxx
>
>
> "Winning takes talent but it takes character to keep winning"
>
>
Other related posts:
