编辑位置概览页面

选择一个布局，然后将小组件拖动至您的概览页面进行自定义。位于下面页面上的小组件可通过选择符号进行配置。

确定请不要再向我显示此消息。

SQL & PL/SQL在 Database Application Development
所有位置
Oracle Groundbreakers
Database
Database Application Development
SQL & PL/SQL

概览
内容
人员
子空间
更多

操作
关于

通告 1 *** SQL and PL/SQL Frequently Asked Questions (FAQ) ***

通告：* SQL and PL/SQL Frequently Asked Questions (FAQ) *

显示详情
隐藏详情

由 BluShadow (2013年6月7日)

BluShadow has been kind enough to compile a handy FAQ for SQL and PL/SQL. Check out the details here: https://community.oracle.com/message/9361969#9361969 Also, check out the PL/SQL 101 community documents (http://tinyurl.com/jjrtzja) for information about frequently asked issues.

终止通告不会删除通告，但会从通告列表中将其移除。确定要终止该通告？

您确定要删除此公告？

登录用于关注、共享和参与该 community。

资源

正在载入...

Welcome to the SQL and PL/SQL Community

正在载入...

Steven Feuerstein-Oracle

txt/css

正在载入...

Steven's PL/SQL Feed

正在载入...

Unanswered SQL & PL/SQL Questions

正在载入...

Subsequent calls to Webservice(UTL_HTTP) from SQL fails
MERGE using GTT is not executed in PARALLEL
Query taking long time in Prod
dynamic date setting
How to put a case statement in a where clause

特色内容

正在载入...

Re: Regexp_substr
PL/SQL 101 : WITH Clause
PL/SQL 101 : Exception Handling
PL/SQL 101 : Cursors and SQL Projection
PL/SQL 101 : Understanding Ref Cursors
PL/SQL 101 : Substitution vs. Bind Variables
PL/SQL 101 : Grouping Sequence Ranges (Tabibitosan Method)
PL/SQL 101 - DBMS_OUTPUT
Oracle Function Result Cache | Steven Feuerstein [Video]
PL/SQL 101 : DataTypes - DATE
Why Use PL/SQL?
PL/SQL 101 : DataTypes - NUMBER
Re: 'Happy numbers' logic in SQL
Avoiding Spaghetti Code | Steven Feuerstein [VIDEO]
PL/SQL-Ville (Acapella) | Steven Feuerstein [VIDEO]
Code for Tomorrow | Steven Feuerstein [VIDEO]
The Cursor FOR Loop | Steven Feuerstein [VIDEO]
Re: 15. I want to store Dates in the Format...
SQL - The Natural Language for Analysis

个人领先者

正在载入...

Recent SQL & PL/SQL Content

正在载入...

	Subsequent calls to Webservice(UTL_HTTP) from SQL fails 20 分钟前在 SQL & PL/SQL	作者：zenshiva
	How to fetch the values from JSON in Oracle 11g SQL 52 分钟前在 SQL & PL/SQL	作者：1047637
	How to fetch the non matching rows from table joins ? 2 小时前在 SQL & PL/SQL	作者：Ramesh Selvam
	MERGE using GTT is not executed in PARALLEL 2 小时前在 SQL & PL/SQL	作者：vikramrathour
	Query taking long time in Prod 7 小时前在 SQL & PL/SQL	作者：user1014019
	How to put a case statement in a where clause 10 小时前在 SQL & PL/SQL	作者：4199981
	How to get easily numeric format value of nls_iso_currency ? 13 小时前在 SQL & PL/SQL	作者：panzer_hier
	dynamic date setting 13 小时前在 SQL & PL/SQL	作者：901277
	dbms_parallel_execute chunking a single partition 15 小时前在 SQL & PL/SQL	作者：2772914
	Not able to load CLOB data through the Command prompt 18 小时前在 SQL & PL/SQL	作者：Rajan Sw

获取此内容的资源

正在载入...

Recent SQL & PL/SQL Activity

筛选器

筛选条件：All Items

zenshiva 在 SQL & PL/SQL 中20 分钟前 (显示更多缩小显示区)

Subsequent calls to Webservice(UTL_HTTP) from SQL fails

Hi Team, Please help me in addressing this issue. I am using the below procedure to call HTTPS wsdl, this works fine for the first time when calling this procedure on SQL prompt logging into DB… (显示更多缩小显示区)

在 SQL & PL/SQL 中喜爱显示 0 喜欢(0)

0 条回复

1047637 在 SQL & PL/SQL 中17 小时前 (显示更多缩小显示区)

How to fetch the values from JSON in Oracle 11g SQL

Hi Dear Friends, Hope you are doing good . I am stuck in a situation where in I need to extract the values for keys from JSON and it has to be done in Oracle 11g, SQL only and no PL/SQL . Below… (显示更多缩小显示区)

在 SQL & PL/SQL 中喜爱显示 0 喜欢(0)

3 条回复显示更多活动显示更多活动

1047637 （至 Paulzip） 52 分钟前 (显示更多缩小显示区)

Thanks for your response .. As there is already in SQL statement written with proper Relational table and fields to fetch the data . But since type of data source now changes for new version of…

喜爱显示 0 喜欢(0) 操作

Ramesh Selvam 在 SQL & PL/SQL 中22 小时前 (显示更多缩小显示区)

How to fetch the non matching rows from table joins ?

Hi All, I need to get all the employees for whom all of the balances are not attached for each element. Element is attached to employees and balance is attached to elements. If any of the… (显示更多缩小显示区)

在 SQL & PL/SQL 中喜爱显示 0 喜欢(0)

6 条回复显示更多活动显示更多活动

Ramesh Selvam （至 mathguy） 2 小时前 (显示更多缩小显示区)

Thanks mathguy..it worked as expected.

喜爱显示 0 喜欢(0) 操作

vikramrathour 在 SQL & PL/SQL 中2 小时前 (显示更多缩小显示区)

MERGE using GTT is not executed in PARALLEL

Hi, I have 2 GTT tables that are used in a MERGE. When I look at the generated plan, I see that the actual MERGE is still happening in serial. This is not happening for permanent tables. Any… (显示更多缩小显示区)

在 SQL & PL/SQL 中喜爱显示 0 喜欢(0)

2 条回复显示更多活动显示更多活动

vikramrathour （至 Billy~Verreynne） 2 小时前 (显示更多缩小显示区)

What got me excited to expect PARALLELism in MERGE was this - https://danischnider.wordpress.com/2018/05/15/using-temporary-tables-for-complex-reports/ So, is INSERT behaving differently or…

喜爱显示 0 喜欢(0) 操作

载入更多条目

Links

正在载入...

Developer Center for PL/SQL
Developer Center for SQL
LiveSQL - Try it out in your browser.
Community space for SQL
PL/SQL Learning Library
Doing PL/SQL from SQL: Correctness and Performance
Doing SQL from PL/SQL: Best and Worst Practices
How to write SQL injection-proof PL/SQL
Practically Perfect PL/SQL with Steven Feuerstein
Learn how to leverage the power of PL/SQL using the DinoDate demo app.

PL/SQL 101 Articles

正在载入...

带有 plsql101 标记的项目

PL/SQL 101 : Exception Handling
PL/SQL 101 : WITH Clause
PL/SQL 101 : Grouping Sequence Ranges (Tabibitosan Method)
PL/SQL 101 : Substitution vs. Bind Variables
PL/SQL 101 : DataTypes - NUMBER
PL/SQL 101 - DBMS_OUTPUT
PL/SQL 101 : DataTypes - DATE
PL/SQL 101 : Understanding Ref Cursors
PL/SQL 101 : Cursors and SQL Projection

编辑位置概览页面

通告：*** SQL and PL/SQL Frequently Asked Questions (FAQ) ***

Welcome to the SQL and PL/SQL Community

txt/css

Steven's PL/SQL Feed

Unanswered SQL & PL/SQL Questions

特色内容

个人领先者

Recent SQL & PL/SQL Content

Links

PL/SQL 101 Articles

通告：* SQL and PL/SQL Frequently Asked Questions (FAQ) *