tag:blogger.com,1999:blog-59090115572737669582024-02-08T05:44:14.850+02:00Shahaf's Blogשחף עזריאליhttp://www.blogger.com/profile/07860962721495852012noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5909011557273766958.post-49330764048098564832010-05-08T11:05:00.003+03:002010-05-08T11:09:20.866+03:00Update table data in parallel using DBMS_PARALLEL_EXECUTE<div dir="rtl" style="text-align: right;" trbidi="on"><div dir="ltr" style="text-align: left;">An excellent post by Lazar Nakinov</div><div dir="ltr" style="text-align: left;"><br />
</div><div dir="ltr" style="text-align: left;"><a href="http://database.com.mk/?p=413">Update table data in parallel using DBMS_PARALLEL_EXECUTE</a></div><div dir="ltr" style="text-align: left;"><br />
</div><div dir="ltr" style="text-align: left;"><br />
<span class="miniprofile-container http://www.linkedin.com/miniprofile?vieweeID=6744074&context=nus&view miniprofile-initialized" id="yui-gen22"><b><a href="http://www.linkedin.com/profile?viewProfile=&key=6744074&goback=%2Ehom&trk=NUS_UNIU_SHARE-prfl"></a></b></span></div></div>שחף עזריאליhttp://www.blogger.com/profile/07860962721495852012noreply@blogger.com0tag:blogger.com,1999:blog-5909011557273766958.post-68159108137345382922010-05-05T11:51:00.003+03:002010-05-05T16:48:09.451+03:00Oracle APEX 4 Early Adopter Phase II<div dir="rtl" style="text-align: right;" trbidi="on"><div dir="ltr" style="text-align: left;"><meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 14" name="Generator"></meta><meta content="Microsoft Word 14" name="Originator"></meta><link href="file:///C:%5CUsers%5Cshahaf%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml" rel="File-List"></link><link href="file:///C:%5CUsers%5Cshahaf%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx" rel="themeData"></link><link href="file:///C:%5CUsers%5Cshahaf%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="colorSchemeMapping"></link><style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-520092929 1073786111 9 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:0cm;
margin-right:0cm;
margin-bottom:10.0pt;
margin-left:0cm;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
mso-themecolor:hyperlink;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-noshow:yes;
mso-style-priority:99;
color:purple;
mso-themecolor:followedhyperlink;
text-decoration:underline;
text-underline:single;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
mso-style-unhide:no;
mso-style-qformat:yes;
margin-top:0cm;
margin-right:0cm;
margin-bottom:10.0pt;
margin-left:36.0pt;
mso-add-space:auto;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst
{mso-style-priority:34;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
mso-add-space:auto;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle
{mso-style-priority:34;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
mso-add-space:auto;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast
{mso-style-priority:34;
mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:10.0pt;
margin-left:36.0pt;
mso-add-space:auto;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:10.0pt;
line-height:115%;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;
mso-header-margin:36.0pt;
mso-footer-margin:36.0pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1444808135;
mso-list-type:hybrid;
mso-list-template-ids:-529391986 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style> </div><div class="MsoNormal" dir="ltr" style="text-align: left;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">For a few years now I’ve been developing applications using oracle application express (what was HTML DB). <o:p></o:p></span></div><div class="MsoNormal" dir="ltr" style="text-align: left;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">APEX runs on top of oracle database. Since database version 11.1 the installation and configuration of APEX is made very easy and is one of the options within the database installer.<o:p></o:p></span></div><div class="MsoNormal" dir="ltr" style="text-align: left;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Because APEX is part of the database its maintenance is done by the DBA that maintain the company DB’s and no other special backup, monitor or any other actions are required.<o:p></o:p></span></div><div class="MsoNormal" dir="ltr" style="text-align: left;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">The application express as its name is fast to learn and results are shown in a few hours’ work. To develop a simple application all you need to know is SQL.<o:p></o:p></span></div><div class="MsoNormal" dir="ltr" style="text-align: left;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">More complex applications can be developed such as dynamic charts, interactive reports, dynamic operations on other servers and platforms can be created by using PL/SQL and java scripts.<o:p></o:p></span></div><div class="MsoNormal" dir="ltr" style="text-align: left;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Oracle has released APEX 4.0 for early adopters a few months ago. We are currently at phase 2.<o:p></o:p></span></div><div class="MsoNormal" dir="ltr" style="text-align: left;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;"><b>The new version includes a much needed enhancements such as</b>:<o:p></o:p></span></div><div class="MsoListParagraphCxSpFirst" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">1.<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span dir="LTR" style="font-size: small;"></span><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Websheets.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">2.<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span dir="LTR" style="font-size: small;"></span><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Team development.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">3.<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span dir="LTR" style="font-size: small;"></span><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Build in dynamic actions. Reduce the need for complex coding using PL/SQL and java scripts.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">4.<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span dir="LTR" style="font-size: small;"></span><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Plug-ins, widgets.<o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">5.<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Improved charting, current APEX chart are based on Anychart version 3, APEX 4.0 chart are based in Anychart version 5 that provide smarter flash chart (Anychart version 5 can be installed upon APEX 3 you can follow the installation instructions in APEX evangelist site </span><span style="font-size: small;"><a href="http://anychart.apex-evangelists.com/pls/apex/f?p=755:17:0::NO">http://anychart.apex-evangelists.com/pls/apex/f?p=755:17:0::NO</a>:::)</span><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;"><o:p></o:p></span></div><div class="MsoListParagraphCxSpMiddle" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">6.<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Enhanced interactive reports.<o:p></o:p></span></div><div class="MsoListParagraphCxSpLast" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">7.<span style="font-family: "Times New Roman"; font-size-adjust: none; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;"> </span></span><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Improved out of the box themes.</span></div><div class="separator" dir="ltr" style="clear: both; text-align: center;"><span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEktDflMZvqn9gvLcJ9pXk5hiN9BDhHI6ak7JA1-O_6F_wzE_5WUG1zIW7LwEAvLtpsq2YJX4CVaOV9O569FHI3S810wLap04FBb7bLAuGv0BnVENigTIRGHQIH4nAFYP9sz1Y2kGJ-ig/s1600/apex4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEktDflMZvqn9gvLcJ9pXk5hiN9BDhHI6ak7JA1-O_6F_wzE_5WUG1zIW7LwEAvLtpsq2YJX4CVaOV9O569FHI3S810wLap04FBb7bLAuGv0BnVENigTIRGHQIH4nAFYP9sz1Y2kGJ-ig/s320/apex4.JPG" /></a></span></div><div class="MsoListParagraphCxSpLast" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;"> </span></div><div class="MsoListParagraphCxSpLast" dir="ltr" style="text-align: left; text-indent: -18pt;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;"><o:p></o:p></span></div><div class="MsoNormal" dir="ltr" style="text-align: left;"><span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;">Oracle provides a playground for testing APEX 4.0 <a href="http://tryapexnow.com/">http://tryapexnow.com/</a> hosted on Amazon cloud, take into consideration that there are still many bugs and the application does not always run smooth.</span><br />
<span style="font-family: "Arial","sans-serif"; font-size: small; line-height: 115%;"><o:p>Have any questions let me know.</o:p></span></div></div>שחף עזריאליhttp://www.blogger.com/profile/07860962721495852012noreply@blogger.com0tag:blogger.com,1999:blog-5909011557273766958.post-45374950469166356212010-05-01T18:13:00.001+03:002010-05-01T18:16:20.959+03:00הצפון הרחוק<div dir="rtl" style="text-align: right;" trbidi="on">לפני כשלוש שנים אישתי ואני מימשנו חלום לקנות בית בגליל.<br />
לאחר תהליך חיפוש וועדות קבלה, סיפור ליום אחר, רכשנו בית בישוב מדהים בגליל המערבי.<br />
במקביל לשיפוצים, תוספות בניה וכדומה התחלתי לחפש עבודה באזור הגליל, מהר מאוד שמתי לב שמספר המשרות הפנויות בצפון נמוך ביותר, ושלא נדבר על עניין בעבודה ומשכורות. <br />
בתום מספר חודשי חיפוש, ושיחות עם תושבים נוספים בישוב הגעתי למסקנה שבכדי לעבוד בעבודה שהיא גם מעניינת וגם רווחית צריך לעבוד באזור המרכז. הבעיה שזו נסיעה של שעתיים לכל כיוון מה שאומר להיות ארבע שעות כל יום בדרכים. כפי שניתן להסיק החלטנו לגור בת"א ולהגיע לגליל לסופי שבוע וחופשות.<br />
כך אנו עושים מזה שנתיים, כל פעם שאחנו בצפון מכרסם בי הרצון לעבור ולהתגורר ביופי הגלילי, אין כמו לחיות בלב יער,לשמוע את הציפורים שרות כל היום, לאפשר לילדה ללכת לטייל חופשי בישוב על אופניים או למגרש המשחקים ללא חשש כפי שיש לי בת"א.<br />
אתמול ישבתי עם אחד מחברי לישוב שנוסע כל יום לת"א והוא הסביר לי שהוא עושה זאת מכיוון שזו איכות חיים למשפחה, אני שואל אותו מה איכות חיים בזה שאתה חוזר כל יום הביתה בשמונה או תשע בערב הרוס אחרי עבודה ונסיעות (אגב הוא נוסע ברכבת ומנצל את השעות לעבודה) ומתפקד כאב ובעל בסופי שבוע, האם זו איכות חיים?<br />
יצאתי מהשיחה הזו ללא תשובות ברורות ועם חומר למחשבה.<br />
כיום נוצר מצב שבו מרכז העבודה הוא במרכז הארץ והפריפריה הפכה לערי שינה, אנחנו כבלנו את מרכז החיים שלנו לאזור העבודה אנשים רוצים לגור קרוב לעבודה בכדי לא לבלות זמן בדרכים. במדינות רבות אנשים נוסעים ברכבים או ברכבות שעות כל יום בכדי להגיע לעבודה. <br />
במהלך החופש הגדול של הילדים המשפחה שלי תהיה בגליל, אני חושב שזו תהיה הזדמנות לעשות ניסוי בנסיעה יומיומית לת"א שבסופו תהיה תשובה מהי איכות חיים, לגור בת"א קרוב לעבודה ולהגיע לסופי שבוע לגליל או לגור בגליל ולהגיע לת"א לעבודה.<br />
רשמים ותוצאות במהלך חודש יולי. <br />
<br />
</div>שחף עזריאליhttp://www.blogger.com/profile/07860962721495852012noreply@blogger.com1