Просторы интернета

19 Февраль 2015
Earlier
Пт, Мар 04, 2016
Deploying Customizations in Oracle E-Business Suite Release 12.2


This article describes how to deploy customizations in an Oracle E-Business Suite Release 12.2 environment.


A little bit background before we move onto the exact steps required to move the customization.


An Oracle E-Business Suite Release 12.2 installation now includes two editions (versions) of the [...]
Source: oracleanil.blogspot.ru
Пт, Мар 04, 2016
Create View Object through Personalization
This post will help you to understand on how we can create a view object with the help of OAF personalization.
1. Set 'Personalize Self-Service Defn' & 'FND: Personalization Region Link Enabled' Profile options so that you can get the personalization link.
2. In R12.2 we get the [...]
Source: oracleanil.blogspot.ru
Пт, Мар 04, 2016
Create View Object through Personalization
This post will help you to understand on how we can create a view object with the help of OAF personalization.
1. Set 'Personalize Self-Service Defn' & 'FND: Personalization Region Link Enabled' Profile options so that you can get the personalization link.
2. In R12.2 we get the [...]
Source: oracleanil.blogspot.ru
Чт, Янв 21, 2016
Имеем таблицы в двух схемах
create table MESSAGE
(
message_id INTEGER not null,
message_code VARCHAR2(128) not null,
message_name NVARCHAR2(256) not null,
message_type VARCHAR2(128) not null,
message_level [...]
Source: atyshenko.blogspot.com
Ср, Дек 30, 2015
A variation on Jonathan Lewis's SNAP_MY_STATS package to report the resource consumption of a unit of work between two snapshots. Designed to work under constrained developer environments, this version has enhancements such as time model statistics and the option to report on specific statistics. ***Update*** Now available in two formats: [...]
Source: www.oracle-developer.net
Ср, Окт 21, 2015
Maximum Key Length

Such an error might crop up when a table index is being created in the database:

ORA-01450: maximum key length (6398) exceeded

Oracle documentation duly lists the cause and action to resolve this error:

Cause: The combined length of all the columns specified in a CREATE INDEX statement exceeded the maximum index length. [...]

Source: www.oratable.com
Сб, Окт 17, 2015
:)

And special thanks to all the great people who voted for me!
I want to list all voters for all nomenees in one page: http://orasql.org/odevchoice/all-the-voters.html

The query (using xt_http of course )

with finalists(category, userid, name) as ( -- [...]
Source: orasql.org
Пн, Окт 12, 2015

A couple days ago i created simple package for HTTPS/HTTP, but I’ve decided now to improve it:

Timeout parameter – it would be better to control connection time; Simple page parsing with PCRE regular expressions – to speed up and simplify page parsing, because if you want to get big [...]
Source: orasql.org
Пт, Окт 09, 2015
:)

It’s very easy to get and analyze voters list using my new XT_HTTP package
We can get up-voters list by the URL: https://community.oracle.com/voting-history.jspa?ideaID=NNNN&start=0&numResults=1000

where NNNN is Idea ID from nomenee’s page.
For example my page – https://community.oracle.com/ideas/6901 so my voters page will be https://community.oracle.com/voting-history.jspa?ideaID=6901&start=0&numResults=1000
BTW, though this page [...]

Source: orasql.org
Пт, Окт 09, 2015
:)

I don’t like to import certificates, so i cannot use httpuritype for HTTPS pages and I decided to create package which will work with https as http.
It was pretty easy with java stored procedures
github/XT_HTTP
java source: xt_http.jsp create or replace and compile java [...]

Source: orasql.org
Сб, Сен 26, 2015
I've been selected as a finalist in the 2015 Oracle Database Developer Choice Awards...! September 2015 [...]
Source: www.oracle-developer.net
Ср, Июл 08, 2015

This post is just a compilation of the links to other people’s articles and short descriptions about new SQL PLAN OPERATIONS and HINTS with a couple little additions from me.


OPERATION_NAME Description Links JSONTABLE EVALUATION [...]
Source: orasql.org
Вс, Июл 05, 2015
:)

As you know, since 11.2 “relies_on” clause was deprecated and oracle tracks dependencies at runtime now.
Test function and tables create or replace function f_without_deps(p_tab varchar2) return varchar2 as res varchar2(30); begin execute immediate 'select '''||p_tab||''' from '||p_tab||' where rownum=1' into res; return res; end; / create table a as [...]

Source: orasql.org
Вс, Июл 05, 2015

Recently I showed simple example how result_cache works with non-deterministic functions and observed strange behaviour: a function gets fired once in the normal query, but twice with the result_cache hint.
Moreover, only third and subsequent query executions return same cached results as second query execution.
I didn’t want to investigate [...]

Source: orasql.org
Пт, Июн 26, 2015

You know that if we want to execute another script from the current script directory, we can call it through @@, but sometimes we want to know the current path exactly, for example if we want to spool something into the file in the same directory.
Unfortunately we [...]

Source: orasql.org
Вт, Июн 16, 2015
learn-oracle

Here is a simple guide to learning Oracle as a developer from scratch, on your own. For an absolute beginner to Oracle, it helps you navigate your way around the sea of information available at your disposal.

A 5-step answer to the question "How to learn Oracle?"

1. Get yourself an Oracle [...]
Source: www.oratable.com
Вт, Июн 09, 2015
CBO, RBO Oracle Optimizers

In large applications that juggle tons of data, it isn’t enough to get a query to run without errors. The query must also perform well – get the results in fastest possible time, using the least possible resources.

This is where Oracle’s inbuilt optimizers come into play. Till Oracle [...]

Source: www.oratable.com
Ср, Апр 29, 2015

Модное веяние — централизованный хаб для расчетов. Или единый репозиторий тарифов.

Далее небольшая демонстрация, как можно с помощью Oracle Policy Automation описать составные банковские продукты и оперативно вносить в них изменения.

ВконтактеFacebookTwitterGoogle+ [...]
Source: orablog.ru
Вт, Апр 28, 2015
:)

How many times have you guessed the right answer?
1 select * from dual order by -1; select * from dual order by 0;

[collapse] 2 select * from dual [...]

Source: orasql.org
Вт, Апр 28, 2015
:)

How many times have you guessed the right answer?
1 select * from dual order by -1; select * from dual order by 0;

[collapse] 2 select * from dual [...]

Source: orasql.org
Пт, Апр 24, 2015
При создании PLUGGABLE DATABASE командой

CREATE PLUGGABLE DATABASE PDBTest
ADMIN USER user1 IDENTIFIED BY user1
ROLES = (connect,dba)
DEFAULT TABLESPACE users
file_name_convert = ('+DATA/MYSERVER/A587A94B8C72405CB40663EF8F521E9E/DATAFILE/system.271.876592207', 'C:ORACLEORADATAMYSERVERPDBTestsystem.271'
[...]
Source: atyshenko.blogspot.com
Пт, Апр 24, 2015
utl_http

You can call a web service from within PL/SQL using the Oracle-supplied package UTL_HTTP. Here’s a demo of calling a public web service that returns latest city weather by ZIP.
PL/SQL Script Using UTL_HTTP

PL/SQL script that invokes the web service to get latest weather, then reads the response into [...]

Source: www.oratable.com
Вт, Мар 31, 2015
UTL_FILE

A simple example of using UTL_FILE in PLSQL to create a file and write into it. Plus, the common ORA errors you encounter with the use of UTL_FILE, and how to resolve them.

This script has been run on Oracle 10G Express Edition, on Windows OS.

Here’s the script:

-- [...]
Source: www.oratable.com
Вт, Мар 17, 2015
duplicate-sets-of-values

The query to identify duplicate records in Oracle in a single table is fairly straightforward. Things get tricky in a two-table (master-detail) scenario, in which the master table holds the header information (id, name, etc) and the detail table has sets of values associated with the master records.

What [...]

Source: www.oratable.com
Вт, Мар 17, 2015
SQL> with function f return int is 2 begin 3 for r in (select value from v$mystat natural join v$statname where name like 'IM scan rows') loop 4 [...]
Source: orasql.org
Ср, Фев 11, 2015

As you know, NaN is a “Not a Number”.
How do you think, what would be the result of the following query? (0f/0 == NaN)

select count(*) cnt from dual where rownum < 0f/0;

Spoiler:: Answer SelectShow SQL> select count(*) cnt, 0f/0 from dual where rownum < 0f/0; [...]
Source: orasql.org
Пн, Фев 09, 2015

I never thought I would have to optimize so simple query as

select col1, col2, col4, col7 from table where rownum=1

(even though I read recently “SELECT * FROM TABLE” Runs Out Of TEMP Space)
But a few days ago [...]

Source: orasql.org
Ср, Фев 04, 2015

I’ve just noticed an interesting thing:

Assume, that we have a simple query with “MIN(ID)” that works through “Index full scan(MIN/MAX)”:

SQL> explain plan for 2 select 3 min(ID) as x 4 from tab1 5 where [...]
Source: orasql.org
Вс, Янв 11, 2015

In this example we are going to integrate a simple XML publisher report with OAF. The business scenario is something like that we have a OAF page and on click of "Print" button we want to call a XML publisher report.

Steps
1. Create a OAF page with [...]
Source: oracleanil.blogspot.ru
Вс, Янв 11, 2015

In this example we are going to integrate a simple XML publisher report with OAF. The business scenario is something like that we have a OAF page and on click of "Print" button we want to call a XML publisher report.

Steps
1. Create a OAF page with table region and print [...]
Source: oracleanil.blogspot.ru
Комментирование отключено.