• 学术搜索
  • 科研智能体
    • Research Labs
    • AI 阅读
    • AI 文库
    • 深度研究
    • 学者亮点
  • 学术资源
    • AI2000
    • 期刊/会议
    • 学者库
    • 学术API
      MCP&Skill
    • 溯源树
    • 数据集
  • 知识沉淀
    • 学术空间
订阅小程序
旧版功能
aminer vip
开通会员低至0.73元/天
一次搞定AI科研
立即登录
  • English
  • 联系方式
    I

    Iowa Pork Producers Association

    EST. 1930
    22论文总数
    55引用总数

    论文量&引用量时间轴

    机构学者

    论文(22)

    年份
    起
    –
    止
    排序
    1Pro Oracle SQL Development
    Jon Heller

    This book teaches you to write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features.

    2023Apress eBooks(2023)
    引用
    AI阅读
    加入学术空间
    2Modify Data with Advanced DML
    Jon Heller

    Now that we learned how to write advanced SQL statements to retrieve data, it is time to learn how to write advanced SQL statements to change data. Oracle Data Manipulation Language (DML) lets us insert, update, and delete data.

    2022Pro Oracle SQL Development(2022)引用:2
    引用
    AI阅读
    加入学术空间
    3Use SQL More Often with Advanced Dynamic SQL
    Jon Heller

    SQL is Oracle's greatest strength. Dynamic SQL is important because it gives us more opportunities to use SQL. Chapter 14 introduced the basic features: using dynamic SQL for DDL, unknown objects, and simplifying privileges; EXECUTE IMMEDIATE and bind variable syntax; simplifying dynamic code with multiline strings, alternative quoting syntax, and templating; and the benefit of generating code instead of creating generic code.

    2022Pro Oracle SQL Development(2022)
    引用
    AI阅读
    加入学术空间
    4Understand SQL Performance with Algorithm Analysis
    Jon Heller

    Solving Oracle SQL performance issues is the pinnacle of SQL development. Performance tuning requires a combination of all the skills previously discussed in this book. We need to understand the development process (to know why problems happened and weren't caught sooner), advanced features (to find alternative ways to implement code), and programming styles (in order to understand the code and rewrite it into something better).

    2022Pro Oracle SQL Development(2022)
    引用
    AI阅读
    加入学术空间
    5Improve the Database with Advanced Oracle Schema Objects
    Jon Heller

    So far, this book has used pre-built objects, but now it's time to start making our own. This book assumes you are familiar with basic Data Definition Language commands like CREATE TABLE. This chapter describes advanced features of Oracle schema objects and the advanced DDL commands to create and maintain them.

    2022Pro Oracle SQL Development(2022)
    引用
    AI阅读
    加入学术空间
    立即登录,查看全部 22 篇论文

    合作机构(6)

    爱荷华州立大学合作论文 2
    Waukegan Public Library合作论文 1
    Norwalk Hospital合作论文 1
    Wilmington University合作论文 1
    韩国天主教大学合作论文 1
    South Johnston High School合作论文 1

    机构统计