Alaska Cowboy
asked on
Need to understand some Oracle tools, functions (Web PL/Sql Modules, Oracle Designer, etc.)
I need to get some background on several Oracle tools / functions. I have experience with your basic Pl Sql development but not much experience on the Web.
- what are "Web PL/Sql Modules" ? I found this but wanted to get your take.
- What is Oracle Designer ? I mainly use Pl Sql Developer, some TOAD and some Oracle Sql Developer. How hard would this be to learn ? Should I look at this Windows download to try and learn it ?
- Is Sql Data Modeler (part of Sql Developer I assume) your basic data modeling tool, ala Erwin ? I have used Sql Developer a fair amount but not the Data Modeler component
- what are "Web PL/Sql Modules" ? I found this but wanted to get your take.
- What is Oracle Designer ? I mainly use Pl Sql Developer, some TOAD and some Oracle Sql Developer. How hard would this be to learn ? Should I look at this Windows download to try and learn it ?
- Is Sql Data Modeler (part of Sql Developer I assume) your basic data modeling tool, ala Erwin ? I have used Sql Developer a fair amount but not the Data Modeler component
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.
>>but I'm not sure how to access it on Oracle/Windows 7.
The online docs are always the best place to start:
Oracle® Database 2 Day + Application Express Developer's Guide
Setting Up Your Own Local Environment
http://docs.oracle.com/cd/E11882_01/appdev.112/e11946/setup_env.htm#CCHDIHJA
>>- can't you also develop web applications in JDeveloper
Never used it but a quick look for documentation seems to suggest you can develop apps with it:
http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_55/jdtut_11r2_55_1.html
What I was suggesting is just because you 'can' do something with some tool/product, should you?
I can write a 10,000 page novel with Notepad. Would probably be a pretty silly thing to try...
The online docs are always the best place to start:
Oracle® Database 2 Day + Application Express Developer's Guide
Setting Up Your Own Local Environment
http://docs.oracle.com/cd/E11882_01/appdev.112/e11946/setup_env.htm#CCHDIHJA
>>- can't you also develop web applications in JDeveloper
Never used it but a quick look for documentation seems to suggest you can develop apps with it:
http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_55/jdtut_11r2_55_1.html
What I was suggesting is just because you 'can' do something with some tool/product, should you?
I can write a 10,000 page novel with Notepad. Would probably be a pretty silly thing to try...
ASKER
slightwv,
thanks, I'm trying to punch out from my one-trick pony PL/SQL using PL Sql Developer, so appreciate the tips.
thanks, I'm trying to punch out from my one-trick pony PL/SQL using PL Sql Developer, so appreciate the tips.
ASKER
- good links and info on PL/SQL Web toolkit and Oracle Designer, thanks
- I looked at JDeveloper briefly, looks fancy-schmancy, it also looks like one can do Sql querying with this, and I assume standard PL/SQL programming as well ?
Slightwv
>>What 'problem' are you trying to solve?
- I'm trying to increase my knowledge of Oracle / tools to improve my own toolkit . . .
- I took a quick look at APEX. It says it "is installed by default in all editions of the Oracle Database", but I'm not sure how to access it on Oracle/Windows 7.
- can't you also develop web applications in JDeveloper
Thanks !