Create linked server to Oracle

EXEC master.dbo.sp_MSset_oledb_prop N'OraOLEDB.Oracle', N'AllowInProcess', 1;
EXEC sp_addlinkedserver
@server = 'XE',
@srvproduct = 'Oracle',
@provider = 'OraOLEDB.Oracle',
@datasrc = '//localhost/orcl';
Exec sp_serveroption 'XE' , 'rpc' , TRUE;
Exec sp_serveroption 'XE' , 'data access' , TRUE;
Exec sp_serveroption 'XE' , 'rpc out' , TRUE;
EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname = N'XE',
@useself = N'False',
@rmtuser = N'jjs',
@rmtpassword = N'jjs';


SELECT * FROM OPENQUERY(XE,'SELECT * FROM test_Tbl where p2  < 1000 and reg_dt >=' || '2012-10-01');
select * from [XE]..JJs.TEST_TBL;

댓글

댓글 쓰기

이 블로그의 인기 게시물

Oracle NLS_DATE_FORMAT 변경

1) 오라클 환경변수 조회하기 select * from v$nls_parameters; 2) 날짜형식 변경하기 alter session set nls_date_format = 'YYYY-MM-DD'; //datefromat변경 alter session set nls_timestamp_format = 'YYYY-MM-DD HH:MI:SS'; // timestamp_format변경 3) 정상적으로 변경되었는지 확인 select * from emp where hiredate = '1981-02-22'; /*alter [session/system]  1. session : 현재접속한 session(쿼리)에서만 변경  2. system : database자체를 변경   scope=[both/spfile]   -both : 바로적용 또는 재시작(오류날 가능성이 높다)   -spfile : DB를 재시작후에 변경 */ **SQL Command Line으로 들어가서 system계정으로 접속해서 바꿔야 한다.(영구적 변경) alter system  set nls_date_format = 'YYYY-MM-DD'   scope=spfile; alter system  set nls_timestamp_format = 'YYYY-MM-DD HH:MI:SS'   scope=spfile; 4)sqlplus에 sys as sysdba 로 접속해서, shutdown immediate;startup; 실행
자세한 내용 보기

Stop console process using Ctrl+C.

http://stackoverflow.com/questions/813086/can-i-send-a-ctrl-c-sigint-to-an-application-on-windows https://msdn.microsoft.com/en-us/library/ms686016(VS.85).aspx private void Button1_OnClick(object sender, RoutedEventArgs e) { var file = new FileInfo(@"C:\temp\video.mp4"); if (file.Exists) { file.Delete(); } ct = new CancellationTokenSource(); Task.Factory.StartNew(() => { var pInfo = new ProcessStartInfo("cmd.exe", string.Format("/c {0} \"{1}\"", new object[] {"adb.bat", file.Name})); pInfo.CreateNoWindow = true; pInfo.UseShellExecute = false; pInfo.RedirectStandardError = true; pInfo.RedirectStandardOutput = true; pInfo.RedirectStandardInput = true; var p = Process.Start(pInfo); ...
자세한 내용 보기

Alternative to IValueConvert, QuickConverter

https://quickconverter.codeplex.com/ Quick Setup Steps Add the assembly reference to your project. This can also easily be done using  the NuGet package . Add the namespaces to Quick Converter that it will need to know about (before any xaml that uses it is loaded). e.g. In your WPF application's App.xaml.cs file: public   partial   class   App  :  Application { public  App() :  base () { // Setup Quick Converter. // Add the System namespace so we can use primitive types (i.e. int, etc.). QuickConverter. EquationTokenizer .AddNamespace( typeof ( object )); // Add the System.Windows namespace so we can use Visibility.Collapsed, etc. QuickConverter. EquationTokenizer .AddNamespace( typeof (System.Windows. Visibility )); } } Add the Quick Converter namespace to your xaml files so you can ref...
자세한 내용 보기