Edit Place Overview Page

Choose a layout and drag widgets onto your Overview Page to customize it. Widgets placed on the page below can be configured by selecting the symbol.

OKDon't show me this again.

SQL & PL/SQLin Database Application Development
All Places
Oracle Groundbreakers
Database
Database Application Development
SQL & PL/SQL

Overview
Content
People
Subspaces
More

Actions
About

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

Announcement:* SQL and PL/SQL Frequently Asked Questions (FAQ) *

Show Details
Hide Details

by BluShadow (June 7, 2013)

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.

Expiring the announcement will not delete it but will remove it from the public announcement list. Are you sure you want to expire this announcement?

Are you sure you want to delete this announcement?

More

Feeds

Welcome to the SQL and PL/SQL Community

Loading...

Steven Feuerstein-Oracle

txt/css

Loading...

Steven's PL/SQL Feed

Loading...

Unanswered SQL & PL/SQL Questions

Loading...

to find out historial sql queries causing LAG
SUM returns wrong results
Best way for data archiving
A simple max query on a partitioned table is not using fast full index scan min/max plan.
Count days excluding weekends.

Individual Leaders

Loading...

Recent SQL & PL/SQL Content

Loading...

	Determining the right UNDO Size 1 minute ago in SQL & PL/SQL	by vikramrathour
	Why client_info in v$session never show IP address even if creating trigger acquiring IP? 11 minutes ago in SQL & PL/SQL	by Quanwen Zhao
	SUM returns wrong results 58 minutes ago in SQL & PL/SQL	by Dmitrii Dunaev
	Replicating tables and views to remote DB 1 hour ago in SQL & PL/SQL	by David Balažic
	Merge two tables plsql procedure 2 hours ago in SQL & PL/SQL	by Bufoss
	Count days excluding weekends. 2 hours ago in SQL & PL/SQL	by 841137
	Best way for data archiving 3 hours ago in SQL & PL/SQL	by 4135353
	to find out historial sql queries causing LAG 3 hours ago in SQL & PL/SQL	by 913578
	Reg: query output 3 hours ago in SQL & PL/SQL	by chandra_1986
	ORA-12829: Deadlock - itls occupied by siblings at block 524520 of file 61 3 hours ago in SQL & PL/SQL	by S567

Get a feed of this content

Loading...

Recent SQL & PL/SQL Activity

Filter

Filtered by:All Items

vikramrathour in SQL & PL/SQL5 days ago (Show more Show less)

Determining the right UNDO Size

Hello All, We are migrating a Sybase IQ 16 Db to Oracle 12.2 Exadata. Most of the Sybase code is of the nature INSERT followed by a lot of UPDATE on a single table. This is leading to a huge UNDO… (Show more Show less)

in SQL & PL/SQLLike Show 0 Likes(0)

10 repliesShow more activityShow more activity

Mark D Powell (to vikramrathour) 1 minute ago (Show more Show less)

vikramrathour, how much data in Gigabytes the MERGE going to impact. Remember to include index update space. Then look at how much UNDO demand you have from other processes to make sure UNDO space…

Like Show 0 Likes(0) Actions

Quanwen Zhao in SQL & PL/SQL3 days ago (Show more Show less)

Why client_info in v$session never show IP address even if creating trigger acquiring IP?

Hey my guys and friends , I found a pretty weird situation on my this Oracle DB server (Version: 11.2.0.4.0 for single instance on Linux) - never showing IP on column "client_info" of view… (Show more Show less)

in SQL & PL/SQLLike Show 0 Likes(0)

22 repliesShow more activityShow more activity

Mark D Powell (to Solomon Yakobson) 11 minutes ago (Show more Show less)

Solomon, nice testing. As I said was possible, it would appear since your test does not duplicate the article test that there have been some changes on newer versions. It would appear Administer…

Like Show 0 Likes(0) Actions

Dmitrii Dunaev in SQL & PL/SQL4 hours ago (Show more Show less)

SUM returns wrong results

Hello, everyone. Has anyone encountered the following bug in 11.2 on Linux server? select sd_id, amount, sum(amount) over() … (Show more Show less)

in SQL & PL/SQLLike Show 0 Likes(0)

19 repliesShow more activityShow more activity

Paulzip (to Dmitrii Dunaev) 59 minutes ago (Show more Show less)

Your 0.48 number value isn't valid. I've seen things like this before on data imports or loads, you can get Oracle to accept data that isn't actually valid. declare num number; begin --…

Like Show 0 Likes(0) Actions

David Balažic in SQL & PL/SQL3 days ago (Show more Show less)

Replicating tables and views to remote DB

Hi! I'm looking into the following problem: replicate a few tables and views to another database DB is both 11.2.0.4 (possible update to 19c, after the wrong result bug is resolved) For a… (Show more Show less)

in SQL & PL/SQLLike Show 0 Likes(0)

7 repliesShow more activityShow more activity

L. Fernigrini (to Stefan Jager) 1 hour ago (Show more Show less)

first of all: As I mentioned I was just throwing some ideas around. Sure! I used this approach on some situations, but I always finished having some issues regarding uncommitted transactions. I have…

Like Show 0 Likes(0) Actions

Load more items

Links

Loading...

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

Loading...

Items tagged with plsql101

PL/SQL 101 : Cursors and SQL Projection
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

Edit Place Overview Page

Announcement:*** 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

Featured Content

Individual Leaders

Recent SQL & PL/SQL Content

Links

PL/SQL 101 Articles

Announcement:* SQL and PL/SQL Frequently Asked Questions (FAQ) *