I've finally been able to get MSSQL server to replicate Oracle to Oracle without an intermediate database. I haven't found anywhere on the internet where this has been done. I've also been able to replicate CLOBS/BLOBS, which from what I understand hasn't been done either. This would be an alternative to buying GoldenGate - should I do a write up? Would there be any interest?
I just received a verbal offer from Oracle and am now waiting on the background check process. I have a public urination charge from 2013 and was curious if anyone still passed the screening and completed the offer with an equivalent or similar charge? I am worried this will affect my offer. Thanks.
Does anyone do any user login/forms usage/logoff events in EBS? I want to turn these features in to provide some minimal information on when users login, what forms they've touched and logoff times in order to provide forensic trails for our security teams when they need to conduct an investigation and have correlated information across systems in Splunk.
Do you know if this causes a material performance impact on EBS?
Hi. I am new to SQL and I started to learn MS Access and now I am currently studying Oracle SQL. However, I am very confused about the certification exams. Can someone please explain what exam is the entry-level exam? Because I have seen different types of exams, 12c, 12g, 11c. Thanks.
For various Reasons, the DBAs and management of my company want to purchase a used or refurb ODA. This would be for testing and development, separate from our production ODA. They are finding out what our consultants told them from the beginning: we need two.
I've checked in the usual server resale places, and even eBay. Does a used ODA market even exist? Or has some aspect of Oracle licensing crushed it?
We have an X-6 if it matters, although management would probably be open to anything.
Hi, I'm new to using Oracle but I want to learn how to use variables. I'm trying to start with something simple, this is what I have so far:
declare req_id number := 27; begin select id into :req_id from my_table where id=:req_id; end;
There is a row in my_table with an id of 27, so I'm expecting it to return the column id with a value of 27, but right now I'm getting "ORA-01403: no data found". I found this question and tried to follow it, but I haven't gotten it to work for me.
Or even simpler:
declare numb number := 27; begin select numb into :numb from dual; end;
I would expect it to return with the number 27 because I declared numb as 27, but it just says "numeric or value error: character string buffer too small"
Am I close, or am I thinking about this the wrong way?
Ultimately my goal is to define a variable once, and then reuse that variable in multiple different update statements so I don't need to type in the ID for each update statement. And if I can get that to work, I can put it all in a procedure.