OraFAQ Forum: SQL & PL/SQL » What does @! mean in SQL?

Home » SQL & PL/SQL » SQL & PL/SQL » What does @! mean in SQL? (Oracle 11.2.0.3)

Fri, 04 January 2019 19:53

SmithXu
Messages: 5
Registered: December 2017

Junior Member

Hi,

I got a SQL as below. It can execute correctly. But what does @! mean?

 select to_char(sysdate@!,'YYYY') from dual;

Fri, 04 January 2019 20:55

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

SmithXu wrote on Fri, 04 January 2019 17:53

Hi,

I got a SQL as below. It can execute correctly. But what does @! mean?
 select to_char(sysdate@!,'YYYY') from dual;

unwilling or incapable of using GOOGLE yourself?

Please click on URL below for answer to your question

http://lmgtfy.com/?q=oracle+sysdate%40!

Previous Topic:	Login table connection to another table.
Next Topic:	Proxy Granted But Unable to Modified a Table owned by the Proxy Account

Goto Forum:

]

Current Time: Fri Jan 22 23:13:04 CST 2021