Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Openquery with ALTER SESSION SET NLS_DATE_FORMAT = "DD/MM/YYYY HH24:MI:SS Expand / Collapse
Author
Message
Posted Thursday, November 13, 2008 6:43 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, January 16, 2012 7:05 AM
Points: 1,149, Visits: 109
Hi

I need to know if it is possible to use openquery within a statement to execute the alter session sentence for oracle db.

Sorry for my english
If this is not the rigth place for the question, would you please direct me ?

thanks in advance for any help !
Post #602047
Posted Monday, June 1, 2009 9:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 6, 2011 10:51 AM
Points: 21, Visits: 86
use Execute immediate statement
Post #726751
Posted Monday, June 1, 2009 10:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, January 16, 2012 7:05 AM
Points: 1,149, Visits: 109
How?
Post #726818
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse