It is possible to create a dblink from Oracle TO Sqlserver? there is any special attention required in this case? It's just putting a command in sqlplus and this is all? How many informations need I to do this?
Could someone give me an example and some tips for this?
You don't mention your OS, but here are some details from Windows. The method is the same as posted by EugeneZ, but with a few more diagrams
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…