English 中文(简体)
第一次学习甲骨文
原标题:
  • 时间:2009-04-15 01:29:29
  •  标签:

我是一个很有经验的MS Sql开发人员,和一些新的工作职位未来的路上,我将与甲骨文合作更多的日常生活。

与我所学到的所有技术一样,我想知道最好的地方和书籍开始,速度与设计和开发Oracle,但纯c#。

对我们有什么资源微软与甲骨文人跳去吗?我意识到oracle.com和asktom.oracle.com,以及大规模的文档在Oracle,我看起来更快速入门(设置一个服务器,让一些示例数据,等)深度而不是sql与Oracle技术比较。

提前谢谢。

最佳回答

< a href = " http://www.oracle.com/technology/tech/dotnet/tools/index.html " rel = " nofollow noreferrer " > Oracle开发工具Visual Studio < / >

< a href = " http://www.oracle.com/technology/tech/dotnet/pdf/ODT11_whatsnew.pdf " rel = " nofollow noreferrer " >白皮书:新在Oracle 11 g功能开发工具(PDF) < / >

< a href = " http://www.oracle.com/technologies/microsoft/docs/idc-interop.pdf " rel = " nofollow noreferrer " > Oracle数据库与Windows和。net < / >

< a href = " http://www.oracle.com/technology/obe/hol08/dotnet/asp/asp_otn.htm " rel = " nofollow noreferrer " >甲骨文的例子:建立ASP。净的Web应用程序与ODT < / >

< a href = " http://www.oracle.com/technology/obe/hol08/dotnet/buildnet/buildnet_otn.htm " rel = " nofollow noreferrer " >甲骨文的例子:构建. net应用程序使用ODT < / >

< a href = " http://www.oracle.com/technology/obe/hol08/dotnet/debugging/debugging_otn.htm " rel = " nofollow noreferrer " >甲骨文的例子:从Visual Studio调试Oracle PL / SQL < / >

< a href = " http://www.oracle.com/technology/obe/hol08/dotnet/udt/udt_otn.htm " rel = " nofollow noreferrer " >甲骨文的例子:使用Oracle用户定义类型Visual Studio . net和< / >

< a href = " http://www.oracle.com/technology/oramag/oracle/08-may/o38net.html " rel = " nofollow noreferrer " >甲骨文杂志:构建应用程序和ODT Oracle用户定义类型< / >

< a href = " http://www.oracle.com/technology/tech/dotnet/col/odt_faq.html " rel = " nofollow noreferrer " > ODT FAQ: OTN论坛常见问题的答案< / >

问题回答

试着让汤姆Kyte年代书< a href = " https://rads.stackoverflow.com/amzn/click/com/1590595254 " rel = " nofollow noreferrer " >专家一对一的Oracle < / >和< a href = " https://rads.stackoverflow.com/amzn/click/com/0072230657 " rel = " nofollow noreferrer " >有效甲骨文通过设计< / >。他们好intermediate-advanced水平甲骨文书一个人写的,谁知道产品好。

此外,了解数据字典。如果你有愿望只是一个工具的家伙在甲骨文世界数据字典是你的朋友。这年代也比在SQL服务器。

Finally, if you re moving to Oracle from a MS-Only world, get some background in unix and shell script programming. You will find this very useful when scripting automation infrastructure for Oracle systems, particularly if they sit on vanilla Unix installs. There is any amount of legacy Oracle/Unix kit still in production and vanilla installs of Solaris, AIX or HP/UX tend to be much more spartan than Linux. In the Unix/Oracle world you can t necessarily rely on being able to install Perl or Python.

当你访问Perl或Python,了解这些。如果你到python,最好的Oracle数据库界面库是< a href = " http://cx-oracle.sourceforge.net/ " rel = " nofollow noreferrer " > cx_Oracle < / >。我真的不能保证任何特定的Perl基础设施就像我从来没有机会使用它为这种类型的工作。< a href = " http://www.cpan.org " rel = " nofollow noreferrer " > CPAN < / >是规范化资源为Perl附加模块。

(相对不太可能),你在Oracle / Windows环境(Oracle在Linux上更广泛应用于低端Oracle部署),良好的Windows分布的Perl和Python可以下载从< a href = " http://www.activestate.com " rel = " nofollow noreferrer " > Activestate的< / >。

同时我看到你想要快速介绍我认为值得一提的是汤姆肚子年代路线图甲骨文文档

< a href = " http://asktom.oracle.com/pls/asktom/z?p_url=ASKTOM%2Edownload_file%3Fp_file%3D4266102912305380863&p_cat=Oracle%20inside%20cover%200703.pdf " rel = " nofollow noreferrer " > http://asktom.oracle.com/pls/asktom/z?p_url=ASKTOM%2Edownload_file%3Fp_file%3D4266102912305380863&p_cat=Oracle%20inside%20cover%200703.pdf < / >

看< a href = " https://stackoverflow.com/questions/718239/how-can-i-practice-my-sql-server-sybase-and-oracle-skills-on-a-linux-box " >这让Oracle服务器的一个副本。< / >

看< a href = " https://stackoverflow.com/questions/702500/sql-query-to-collapse-duplicate-values-by-date-range/ " >这里比较使用Oracle扩展与ANSI SQL表得到相同的结果集。< / >虽然不全面,它给,我认为,一些见解Oracle用户认为与ANSI SQL用户如何思考。





相关问题
热门标签