search for text in application

select aapb.application_id,
aapb.page_id,
aapb.button_name,
aapb.label,
aapb.button_id,
aapb.button_template,
aatb.template
from apex_application_page_buttons aapb,
apex_application_temp_button aatb
where aapb.button_template_id = aatb.button_template_id
and aapb.application_id = 101
and aapb.button_template is not null
and aapb.button_position = 'Region Position'
and upper(aatb.template) like '%#BUTTON_ID#%'

Bookmarking a Page in apex with its session_ID as Zero .

used for all public pages which doesnot require the authentication .

&APP_SESION.=0;

but the backend uses the cookie which was used for the previous session Id .
f?p=&APP_ID:2:0.

upgrading the tables with new values for certain col

create or replace procedure p1

(v_tab varchar,v_col varchar,v_val varchar)

as

v_sql varchar2(2000);

begin

null;

v_sql:='update  '||v_tab|| ' set  '||v_col ||' = '|| v_val;

EXECUTE IMMEDIATE v_sql;

end;

begin

p1('DEPT','LOC',1);

end;

Custom Help Link Creation Using PLSQL in APEX .

to Display the Custom Help Link Page in your Apex apllication Follow 3 simple Steps :-


1) Create the Page which u wanna open as help , Create a Dynamic PLSQL Region on it .

Copy and Paste the following PLSQL code in it.

APEX_APPLICATION.HELP(
p_flow_id => :APP_ID,
p_flow_step_id => :REQUEST,
p_before_page_html=>' this is the messafge displayed before actual message HEllo ',
p_after_page_html=>'after page html the data is as fiollowed ',
p_before_region_html => '
',
p_after_prompt_html => ' hello this is after Prompt html ');





2) Create a Main Page , Create the Navigation BAR link ex:- Need Help Click Here .

While creating this , Set the REQUEST field as :APP_PAGE_ID. & specify the Page to navigate as ur Help Page number.



Run the main Page and click on the Naviagtion .



For Example Refer .....
http://apex.oracle.com/pls/apex/f?p=33327:1:2834468399179620:::::
and click on help for using the apllication .

U can add pass values to different parameters available in the HElp function .

Either to display it on Item level , Region Level , Page Level .


Regards,
Nandini Thakur.

Thakurdurgeshnandini@gmail.com

generate url in apex.

APEX_UTIL.PREPARE_URL package is used to generate the url .

redirecting without submitting the page .

f?p=6000:6001:&APP_SESSION.

if u wanna rediurect to a page 6001 as sson as the button is clicked but dont want to submit the page 6000 then this is the only method using which u can do this .

sessionn in Oracle APex.

Session is logical construct gives stateful behaviour across pages.


session has unique identifier.


session stored in db until admin purges it , hence old session value can be sustained.

URL of aPEx:-

1) application Id
2) page no
3) sessio id

in url f?p is the prefix used by apex.

/ apex is the DAD i name , Database Access descriptior in the Http Server configurations.

APP_ID :- application Id.


full representaion of URL .


f?p=APP_ID:
PAGE_ID:
SESSION:
REQUEST:
DEBUG:
clearcache: app for all pages, RP for the reset paginatioon , 120,121... pages .
itemname:
itemvalue: \121,122\
printerfriendly.
v('PRINTER_FRIENDLY');


The way to acces them are
ex:-

&SESSION.
v('SESSION');
:APP_SESSION

simlarly others are accessed.



Page Alias :- 101:mypage


Application ALias :- coommon _alias:page_alias

common alias used by two diff application c but in two diff workspace can be distinguished by using the workspace name &c='workspace1';



.

few white papers from apex site

http://apex.oracle.com/pls/apex/f?p=44785:2:6890507114827455:FORCE_QUERY::2,CIR,RIR:P2_TAGS:APEX


Advance reporting techniques in apex :-
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/apex/r41/apexirradv/apexirradv.htm


Building and Customizing an Interactive Report in Application Express 4.1
http://apex.oracle.com/pls/apex/f?p=44785:24:6890507114827455::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5718,2

Dataloading application in apex

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/apex/r41/dataload/dataload.htm

report on function returning query

1)Create A page and Create a basic report on the page with the option of the source as the sql query (PLSQL function body returning the sql query).

2) Create an function which will take the table name as the input and return the query as the o/p.

create or replace function "QUERY_FOR_REPORT"

(table_name in VARCHAR2 default 'EMP')
return VARCHAR2
is
l_query varchar2(2000);
begin
l_query:='select * from '||table_name;

return l_query;
end;

3)

Call this function on the report as following .

BEGIN
RETURN QUERY_FOR_REPORT('AGENDA ' ||';');
END;

4) to check the o/p pf your function you can  run the same function on the sql workshop and check it.

Declare

l_r varchar(200):=QUERY_FOR_REPORT('AGENDA ' ||';');

Begin
dbms_output.put_line(l_r);

END;

5) now runt the page , it displays the report .

Most basic things of apex

Page Rendering :- process of generating a page from database ( using show apge method / Procedure ). It assembeles all code into HTML format .


Page Processing :- evaluate & execute when page is Processed using ( accept apge Procedure ).
branching , computation , validation , processi ng .


when the page is requested then show page is executed.


when page is submitted then the accept page is executed,


Html Pages are mostly delivered on stateless protocol.

User Roles in APEx

Developer ---> create / edit application .

Workspace admin

1) manage workspace
2) carete suers
3) Viewing log file


END user :- end user to app

Instance Admin :- enitre hosted instance using admin services application .

Application Express Servers

The servers in apex are

!) APEX listeneer
2) http server

3) embedded plsql



Till 11.1 db there was the three tier architecture , hence the apex listener and http port had to be sperately installed.

Then in 11. or later or in XE , comes with embedded plsql

A two tier architecture .

hence no need to install the servers manually.

APEX and LDAP Authentication

1) Start Ldap Server.

2) Process=HTTP_server.

Go to the shared components of teh Apex Application .

Shared Components --->
authentication schema --->
Create--->
based on preconfig schems from the gallery ---->
LDAP Directory Credentials---->
select Login Page .



LDAP hosts .
LDAP Port .
DN name
( cn=%LDAP_USER%,l=owner , dc=orcale,dc=com)

Create scheme.
Aplly it on to a page.

APex installation in windows.

Orcale APEx installation is quite easy in windows.

Prerequisites one must have is

1) Oracel Database 10g (10.2.0.3) or higher version or Oracle XE.

all these databases comes with prerequisites which are required for Oracle APEX.


Steps :-
==========
1) Startup the database.

2) show parameter pfile

3) show Parameter shared_pool_size;


the u/p for teh above two commands are:-

SQL> show parameter pfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string E:\11G\PRODUCT\11.1.0\DB_1\DAT
ABASE\SPFILEORCL1.ORA
SQL> show parameter shared_pool_size;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size big integer 0


4)ALter system set shared_pool_size='100m' scope=spfile;

system altered .

5) if the system uses instilazation parameter set shared_pool_size='100mb'(atleast in initsid.ora).

6)shutdown

7)startup.


Browser Requirment :-

IE 7.0 / Firefox 3.5 / google chrome 4.0 / apple safar 4.0 .


Http server Requirements :-


when choosen the 10g and above all comes default.

1) Application Express Listener

2) Embedded PLSQL gateway .

3) Oracle Http Server & Modplsql.



Disk Space Requirement :-

1) 1 GB HD.

2) Oracle Apex tbspace 185 MB.

3) Sys table space 100 MB.

4) Each Additional Long uage takes (75 mb ) of space extra .



Orcale XML DB requirment

If using the preconfigures database then this is alreday installed and configured.


Oracle Text Requirment :-

- for online help option in Apex

---by default comes with dB.



Installation Steps :-


SQL > @connect sys as sysdba

sql>@apexins SYSAUX SYSAUX TEMP /i/

sql>@apxldimg.sql

connect to db

sql>@apxchpwd

To uninstall the apex

sql>@apxremov.sql


to configure teh apex

sql>apxconf.sql

to disable the port used by apex

sql>EXEC DBMS_XDB.SETHTTPPORT(0);

sql>EXEC DBMS_XDB.SETHTTPPORT(8082); enable the http port of apex xdb with the given port no .

Now go to the brwoser and type

http://127.0.0.1:8082/apex

login to apex using the admin password u set when exceuting the
@apxchpwd command

create the Workspace .
Assign the schema to it .

Create users and assign it to workspace.

Note the Workspace can be created and any schema can be assigned to it .

EX:- if u r trying to use the EBS then the schema of EBS can be assigned to it .



The Default Workspace with which the Admin connects in the admin login page is the internal workspace .

and the user is admin by default.



The users can be created as Workspace Admin , developer.


Regards,
Nandini Thakur.

I was told by mgr that i need to Oracle Apex, i started learning it , but i had to learn it myself as we had only one resource with minimum knowledge of it.
The days were on ...and i started learning it .

Oracle Apex 3.2 (Application Express) is the new technology by oracle , which is used for
developing the RAPID application. The tool was simple to understand.

The technologies which are required for this are :-

1) PL/SQL
2)Java script
3)JQuery
4)XML

i wanted to do something which combines both Oracle and Java ,m and here is how my dream en i come true when i got into Oracle Fusion MiddleWare Team.

hmmm...though Oracle Apex is not part of FMW, but i got an oppurtunity to work on it.

One fine day , i was given a task, as i was new to this technology i was unaware of many things in , i search on forums atlast i posted it .

I got an reply from a person called "Shijesh".

hmmm i got an answer & my task was done. but again after certain days i faced the problem i searched for result , i got the List of ShijeshKumar blog.

Then i realised what are the diiferent things in apex and what all can be done.
I mailed him my query regarding ajax by using his email id on blog . He suggested me few things but i had never wrote the ajax program hence iu requested him to explain and tell me how to implement .I got the very positive reply from him.

I got an confidence to share my difficulties with him, thats how he responded to many of my queries .

Then on a project i had to move to Pune, there again i was struggling with the difficulty and then i had to search for his contact .


He had given a brief description of himself during a chat, then this clue made me to get his number theu one of my friend who is into same company.

Then he replied me . This is how he statred mentoring me . As it was my first project and welacked a senior resource , he mentored me so perfectly .He used to answer all my stupid questions and make them clear. There are many things i learnt from him .

He is b around 50 , but he just too good, cool , simple, settled.I have seen many common things among us .

One day i came to know that he is nor from developer background or Engineering Science
in his whole life time, he is just a consultant .

When i asked him how did u learn this , he said "I dont want developers to cheat him ,so he learnt".

He has tremedous positive waves in him that inspired me and was just there online or on a call moment i call him or ping online.

Then slowoly i described about mine and then abt his , i wasn't believing wt he said.
He said that

The Proactiveness Plays a crucial role in life.

Hi ,

In short i wanna describe that , Proactiveness can find paths & solve ur hurdles.

I used to Post the Queries in the Otn forums , thats how , i got to know a very good person .

He is working in a top most leading organization in IT sector , he used to answer my queries, though he never worked on technical side , he was just a consultant , he was too good techinically .

He always used to respond to my queries and then i statred mailing him on his gmail id , which i found on his blog .

Then one day when i was in need and was unable to get any solution , then i found his contact details from teh same company he was working along with my colleague who was on Deputation there .

Thats how , i built a rapport with him .

Since the day i started communicating with him , i learnt many things in life.

How to face situations .
How to enjoy Life .
What should be ur priority .
How to approach for solution to the problem .

He is the man who lives the life to the fullest .

I treat him as my mentor , at times when i had fallen sick , he had treated me like his child and cared for me.


I have no words to describe him , he is simply down to earth , simple , great guy i have ever met ..... :)

I have never ever seen him but i dont know why i think he ressembles like my dad .... :)

Today's Indian Techies.

Hi All,

This Post is for every one. Especially for the one who belongs to todays famous trend in India (Techy). Its the Blog which can make all of us get communicated with each other.

Each of us is especial , each of us is unique . So, here is the Platform to let others know how are u unique from others.

hmmmm, if u r thinking that its something kind of "pravachan" and all , huh ! then u r taking me wrong.

I know that u will agree that most of the time we spend is in office and in day to day life we get inspired by some one or we inspire some body . So, we know that we can be inspiration for
somebody , though some times we don't consider that we can .

Each of has might have experienced something unique in our life which can make us a unique from others , no matter how funny or how great is it . I think Both are equal as both require Guds.

Most of us from college, get into a MNC , we may be in touch with each other , but we still dont know wt technology they are working . How is there experience of working.

Most of us come across various situations , it can be help full ,if we post it .

No Matter let it be techincal or personal , any funny experience any struggled time.

I welcome and appreciate the Post .

We can learn alot from the sourrounding we got .

Lets contribute and learn from the most Talented People among our-self.

Posted by,
Nandini Thakur.