Familiar with MS SQL, Oracle now transformation, convenient for quick learning advice!-CodePudding

Before the company with ERP system is a MS SQL database

Now the new system in Oracle, seek a great god advice and Suggestions.

CodePudding user response:

Dig a hole, it is easy to get started

CodePudding user response:

Remember 2012 and 2015, I was doing this, the company's erp system upgrade, let me to do the database programming, process is all sorts of pit, but also accumulated a lot of experience!

CodePudding user response:

Look at the oracle architecture principle

CodePudding user response:

refer to the second floor dbs_service response:

remember from 2012 to 2015, I am doing this, the company's erp system upgrade, let me to do the database programming, process is all sorts of pit, but also accumulated a lot of experience!

Feel this version is very cold and cheerless,

Such as: what process all kinds of pit, can you share? I have a psychological preparation, thank you!

CodePudding user response:

Just start will be very not adapt, comparison is a big gap between the organizational structure, how to use it,
Then can put before is essentially a stored procedure, function, to the oracle

CodePudding user response:

There is no shortcut to what, look at oracle, the official document

CodePudding user response:

reference 4 floor qinghuallt response:

Quote: refer to the second floor dbs_service response:

Remember 2012 and 2015, I was doing this, the company's erp system upgrade, let me to do the database programming, process is all sorts of pit, but also accumulated a lot of experience!

Feel this version is very cold and cheerless,

Such as: what process all kinds of pit, can you share? I have a psychological preparation, thank you!

Most commonly is some development issues, such as table data types, syntax, stored procedure syntax conversion and so on!