Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

New To Oracle

981588Dec 25 2012 — edited Dec 25 2012
Hello Forum,
I am a sql server guy and have to make the change to oracle for work reasons
I am a software engineer not a dba, but I still need to interact with oracle
I have access to toad, oracle 11g

What I need is a starting point for reference.
I am looking for a beginner to intermediate guide to oracle to include the syntax, and other complex operations
another guide for toad, pl/sql,
and if this exists a guide that is designed for the transition from sql server to oracle

So far after spending some time goggling I have found a lot of oracle admin books, but the tend to skip the basics including syntax which is important as there are big differences between the two languages
example> in sql server I can have an auto increment identity column in a table, but in oracle this does not exist but rather uses some kind of system sequence -- I have sort of figured this out but still would like a reference to it

can anyone recommend a book or a list of books that might get me started in the right direction

thanks to any who can help

Comments

Nick Gorman-Oracle

Supanut,

See the processor help here:

http://www.oracle.com/webfolder/technetwork/data-quality/edqhelp/index.htm

The details are only added when used in a real time [i.e. web services] call or run as part of a job.

regards,

Nick

2 people found this helpful
S_Srisaksakul

Thank you for your helpful reply.

I make a test and it is really as you and the help file stated.

It is working on realtime data input.

If you would be kind to help me more,

My destination data table has a field named "UPDATE_USER" to record  name of who put  or update the data.

Are there anyway to link EDQ username to be put in the output data so that non EDQ user know which of the edq user put the data in?

Nick Gorman-Oracle

Hi,

If you're talking about writing the EDQ data back to a database table then you need to read the help topic on Exports.

regards,

Nick

1 person found this helpful
S_Srisaksakul

thanks again

I forgot to mention that  the input data is non-real time and  the problem that I currently have is to aqquire the username from EDQ user since from what i understand  "User data detail" only work  on  real time data. I have no problem writting data back to the database.

regards,

T

Nick Gorman-Oracle

Yes, this processor is specifically designed for real-time mode. The username that invoked a batch job is stored in the event log [which can be snapshotted - see System Information - Event log data store] but it's not easy to add this to batch data [as this would require some post-processing to do the lookup].

Mike-Matthews-Oracle

Batch jobs that write data to external targets are normally run from a schedule by a system user (with rights to execute batch jobs) in any case, rather than by a specific 'user' who is logged into EDQ. Depending on your use case, it might therefore be that you need to identify the update as from EDQ rather than from anyone specific?

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 22 2013
Added on Dec 25 2012
#sql-developer
2 comments
108 views