marrowyung
asked on
Oracle programming for starter
hi,
any good site for me to learn Oracle programming from starter to expertise?
any good site for me to learn Oracle programming from starter to expertise?
ASKER
"If I am not mistaken you have ms SQL background, the schemes are ......."
yes
and I may have a job that need Oracel and MYSQL progrmaming knowledge as well, so I need a fast jump start.
yes
and I may have a job that need Oracel and MYSQL progrmaming knowledge as well, so I need a fast jump start.
Programming you mean stored procedures?
Try this, formulate how you would have approached the issue if it were ms SQL, and "translate"
Similar to ms SQL boot camps, oracle. Has similar .. MySQL you ...
The extent .....
Try this, formulate how you would have approached the issue if it were ms SQL, and "translate"
Similar to ms SQL boot camps, oracle. Has similar .. MySQL you ...
The extent .....
ASKER
"Programming you mean stored procedures?"
database programming you can think of, SP/view/function, etc.
" issue if it were ms SQL, and "translate""
seems can't direct translate, I knew MS SQL and MySQL coding technique very close, but Oracle looks like C language.
" MySQL you ..."
?
database programming you can think of, SP/view/function, etc.
" issue if it were ms SQL, and "translate""
seems can't direct translate, I knew MS SQL and MySQL coding technique very close, but Oracle looks like C language.
" MySQL you ..."
?
Oracle uses pl/SQL not sure..
Not a DBA, but the scope might require the same training if you ..
See oreillys oracle/MySQL books.
Not a DBA, but the scope might require the same training if you ..
See oreillys oracle/MySQL books.
ASKER
"Oracle uses pl/SQL not sure.."
yes, Pl/SQL looks like C , e.g. A +=1, which means keep adding 1.
"See oreillys oracle/MySQL books."
any good suggestion from Amazon ?
yes, Pl/SQL looks like C , e.g. A +=1, which means keep adding 1.
"See oreillys oracle/MySQL books."
any good suggestion from Amazon ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
" Which versions of MySQL, oracle are you dealing or would be dealing with?"
MySQL 5.5 and above, oracle 10g, 11gR2 and 12C.
MySQL 5.5 and above, oracle 10g, 11gR2 and 12C.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
slightwv ,
"As for a site to start learning it, I would start here:
http://www.stevenfeuerstein.com/"
this is good one, I knew this oracle expert, tks for the sharing.
"Your future employer might be disappointed if you over exaggerate your skills."
this is one of the concern but I always tell people that I can only understand code but not starting from ground up. I can only copy code if so.
I will always tell them that I am not a coder and no one can do infrastructure as well as coding, I don't even see one can do this.
"HOWEVER: the "pl" (procedural language) of Oracle is quite unique to that product."
yeah, when I look at it, it seems a C language. I don't comfort with it .
"As for a site to start learning it, I would start here:
http://www.stevenfeuerstein.com/"
this is good one, I knew this oracle expert, tks for the sharing.
"Your future employer might be disappointed if you over exaggerate your skills."
this is one of the concern but I always tell people that I can only understand code but not starting from ground up. I can only copy code if so.
I will always tell them that I am not a coder and no one can do infrastructure as well as coding, I don't even see one can do this.
"HOWEVER: the "pl" (procedural language) of Oracle is quite unique to that product."
yeah, when I look at it, it seems a C language. I don't comfort with it .
>> it seems a C language. I don't comfort with it .
It is nothing like C. Not even close. Again, it is ADA:
https://en.wikipedia.org/wiki/Ada_(programming_language)
It is nothing like C. Not even close. Again, it is ADA:
https://en.wikipedia.org/wiki/Ada_(programming_language)
ASKER
ok. tks.
ASKER
tks.
Oracle.com there are many DBA resources including.
If I am not mistaken you have ms SQL background, the schemes are ....... You need to familiarize with the syntax, .....
Install