Development

Oracle package for HTTPS/HTTP[version 0.2]

XTended Oracle SQL - Sun, 2015-10-11 16:30

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

  1. Timeout parameter – it would be better to control connection time;
  2. Simple page parsing with PCRE regular expressions – to speed up and simplify page parsing, because if you want to get big number matched expressions from CLOB with regexp_xxx oracle functions, you have to call these functions many times with different [occurance] parameters, passing/accessing to the clob many times. But within java procedure it will be just one pass.
  3. Support of plsqldoc – the tool for automatically generating documentation in HTML format.(javadoc analogue)

Upd 2015-10-11:

  1. added HttpMethod parameter – so you can choose POST or GET method
  2. added function get_last_response – returns last HTTP response code.

You can download new version from github: https://github.com/xtender/xt_http
Also it may be interesting if you want to see how to get collection of CLOBs/varchar2 from JAVA stored procedure.

So with new functions I can even more easy get UpVoters list from prevous post:

select * 
from table(
         xt_http.get_matches(
            pUrl     => '&url'
           ,pPattern => 'alt="([^"]+)"'
           ,pGroup   => 1
         )
    ) t
Results
select * 
from table(
         xt_http.get_matches(
            pUrl     => '&url'
           ,pPattern => 'alt="([^"]+)"'
           ,pGroup   => 1
         )
    ) t
/
Enter value for url: https://community.oracle.com/voting-history.jspa?ideaID=6901&start=0&numResults=1000

NAME
--------------------------------------------------
Denes Kubicek
Pavel Luzanov
Martin Preiss
AlexAA
scherbak
TimHall
Toon Koppelaars
Dom Brooks
mweedman
BluShadow
Dmitry-Oracle
Mahir M. Quluzade
SA2
Dmitry A. Bogomolov
SQL*Plus
Alexander.Ryndin-Oracle
Mohamed Houri
Randolf Geist
ctrieb
UltraBlast
Kot Dmitriy
user9506228
Timur Akhmadeev
Franck Pachot
pudge
user12068799
user11933056
user11994768
iRAV
user12228999
nicher100
vva
Alexander Semenov
Dmitry_Nikiforov
Bud Light
user7111641
dbms_photoshop
AcidMan
achervov
GokhanAtil
user2616810
Harun Kucuksabanoglu
_Nikotin
Maki
user9066618
user10487079
IgorUsoltsev
edw_otn
Vigneswar Battu
user11198823
be here now
869219
user7543311
VladimirSitnikov
kamineff
Asmodeus
djeday84
Oleh Tyshchenko
87Rb-87Sr
911978
KoTTT
Konstantin
945154
953255
user12217223
Alexander_Anokhin-Oracle
oragraf.sql
Jack10154746
user9502569
Yury Pudovchenko
Sergey Navrotskiy
985277
xifos
MatthiasRogel
Mikhail Velikikh
user12134743
1025067
Oren Nakdimon
1051964
1094595
1209426
user11211533
user6115180
user3990689
d.nemolchev
user8925862
user11222376
user882251
user12279047
1284785
1323138
1336159
Grigory-OC
1373320
1373354
1411786
1421824
user13287062
1442254
1443436
1447180
KSDaemon
user12097700
Sergei Perminov
user3539222
Victor Osolovskiy
1560322
user13609377
user6672754
Alfredo Abate
user11315510
user12245839
1636030
user5399907
user3983717
user12276855
1744386
user9171605
ksAsmodeus
user12058508
1856219
user3214869
Trihin Pavel
1879578
1886567
user8869337
1890583
1913344
user11978061
user1438531
Menno Hoogendijk
2616420
2646629
rpc1
user4770257
user5217858
user11949728
al.netrusov
2693742
AKalugin
2721788
RZGiampaoli
2728073
2769955
2786798
2789541
BobDJ
2816036
user10123230
2831055
DBA_Hans_007
2880604
2896072
2902504
ApInvent
Pinto Das
natalka
2913706
2924025
2957186
2960288
-KE-
user5337688
3001391
3004351
oleksii.kondratenko
zeynep.samsa
Mehmet Kaplan
adbee6ae-dcb4-4c59-915b-487b33773a3f
6648e909-359d-4a32-b7bd-6cea3fd9fec3
mehmetyalcin
60e3f71b-bd5d-422c-b479-7a087d5b3827
3032511
c09042fd-15da-494b-b7b0-243ff4ceeb4b
5e087e18-4789-4923-92cb-cce149ba3072
5291adcf-242b-4f01-bbe6-b7ce44db1aac
9c0321bf-a358-49f9-88e4-462bd4fd5674
03b9266b-53f4-4503-ae04-b339c039bffd
user12044736
4a89f5a6-cc35-424e-8e3c-59964ad8d56b
54113fd4-6592-4a32-9920-663813bdd4c5
590d4b9f-32b6-43ad-b0c4-3b767407c055
ffb03087-d390-4068-98e5-4cfd73e66d00
3fa47a10-7b28-4857-9274-d175f3b7fd48
user5814569
d0b20163-7a58-4d4d-9a7d-01ec973bc3e1
8aaa1ed8-e0f6-4712-bef7-6b1e6579798f
1aee554c-832b-4fa5-bead-0680a53d1cc5
5daa756f-80aa-4260-b91d-10d2c51b78d6
e7897e6a-993d-46db-ad93-215b61b715ad
9f982eda-2b58-4d61-aad9-4c6a50d2dab7
user2503867
3032876
f3012cfb-62b5-4c86-a102-2172c3640d5b
68fe6d1e-d41c-4528-b076-ac3bc5289cc5
41232c56-5a29-442c-a1c6-d5b94477be1d
0682b6e1-8662-498c-8455-629032a25cea
user6592033
59961cb1-b4a6-470c-9802-44432911a7ff
user7345691
ab7980ce-71ba-4ec1-a578-6b716f2ae1ae
user5844404
723b639c-f6c6-4780-8ad6-0315564ef937
28e651f6-c9c3-4d2a-af03-001837eb99ba
3032942
841b96b4-ab84-461e-aed9-58f9df710406
user9961876
d7e48e5c-868f-4b2d-88b5-8614e9d35c80
3033022
f095cbb6-707a-4f40-8f18-a6a9dc37894d
3033091
9e9d3c99-9b5e-4fa2-89ac-4e6216209566
a9e702d3-f8e5-43ee-8e6c-0fe722d9ab50
bdd07d60-c467-4115-8149-8ef2af880d9a
d5571104-4726-4f06-b529-293dc667ae6e
user10865764
petrelevich
87a6503f-5717-4887-ac77-cd916002f53a
user7355088
user6083916
user2300447
user12299863
81ddc21a-7cb3-4298-a96b-ea7c9774b2c4
3405d13c-9d19-4903-8eb0-14a2544cb32b
user2427414
4670adeb-1c9d-4ce4-98eb-962bc4c68f5d
oldhook
1e4428aa-3a63-4a1a-90b3-f2b74292f502
user6367919
7c75e315-487d-4797-8e5b-f3dee58bbc79
user8828289
1a8ad4e7-759f-48ee-8054-c449540d0573
6f3b1262-c9d6-42d6-b703-fc4e6a40b7a1
037f209b-f643-4642-a059-79988d19d77b
PL99
3034106
3034166
user5489918
user2340616
naeel maqsudov
3036157
user2626322
52e8d732-4289-4d0d-b8c5-80e701f3c07d
4b2deedd-84c4-4b8b-8724-837c54dd764e
user12569643
07292d40-2bab-4e94-b68e-cfaae6c093a8
8ec394ac-fd54-4896-9810-0381bb75260e
caec3a42-0f98-440b-ad71-9522cb1e0a0e
9c52d45b-e2e4-489c-9a32-548c77f159b3
f6e966be-8576-4da9-a0df-8fec374b6cd3
5214be2e-d761-4a4e-aeba-23ff7bb4cf4e
f070b484-017d-4d4c-a740-f6ad9db37286
d4f322d3-0265-458d-948d-83bd66d5c7e3

[collapse]
Categories: Development

Oracle Database Developer Choice Awards (2nd)

Denes Kubicek - Fri, 2015-10-09 00:49
I was just looking at the voting results for ORDS and APEX. In the ORDS category Dietmar Aust is leading and in the category APEX it is Morten Braten. So far so good. These men deserve the award for sure - they did a lot for the community and the most of us are using (or have used) their solutions. Think of Morten's PL/SQL Utility Library or Dietmar's PDF Printing...

The only thing I have a problem with is the absolutely microscopic number of votes. The most votes in the category ORDS has Dietmar - 134. In APEX it is 98 votes for Morten. Even Jari Lane who is very well known in the APEX community and has helped numerous people with his solutions has received all together 103 votes - obviously almost the half of it as down-voitng. To my point of view this is incredible. But if I think back and do a comparison with my own experience then this is actually normal. In the last seven years I have received more than 9.000 emails from the community asking either for access to my workspace, my Demo Application or asking for an APEX solution of some kind. As a result of that I have created almost 4.000 accounts and answered 95% of those emails. But all together, maybe 50 receivers responded saying thank you.

Conclusion:

Shame on us. We are lazy and cynic. We are constantly talking about how big the APEX community and how strong it is. Maybe, because there are a few people out there like Dietmar, Jari, Jürgen Schuster, Morten and few others. The rest seem to be there only when they need something.

Categories: Development

Oracle Database Developer Choice Awards: Up-Voters list

XTended Oracle SQL - Thu, 2015-10-08 20:13

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 is called “VotingHistory”, but it shows up-voters only :)

-- create table upvoters as
with 
  finalists(category, userid, name) as (
      --                               SQL~ Voting:
      ------ ------------------ -------------------------------------------------------------------------------------
      select 'SQL'     , 6899,  'Stew Ashton      ' from dual union all
      select 'SQL'     , 6900,  'Sean Stuber      ' from dual union all
      select 'SQL'     , 6901,  'Sayan Malakshinov' from dual union all
      select 'SQL'     , 6902,  'Matthias Rogel   ' from dual union all
      select 'SQL'     , 6903,  'Kim Berg Hansen  ' from dual union all
      select 'SQL'     , 6904,  'Justin Cave      ' from dual union all
      select 'SQL'     , 6905,  'Erik Van Roon    ' from dual union all
      select 'SQL'     , 6906,  'Emrah Mete       ' from dual union all
      --                               PL/SQL~ Voting
      ------ ------------------ -------------------------------------------------------------------------------------
      select 'PL/SQL'  , 6907,  'Sean Stuber      ' from dual union all
      select 'PL/SQL'  , 6908,  'Roger Troller    ' from dual union all
      select 'PL/SQL'  , 6909,  'Patrick Barel    ' from dual union all
      select 'PL/SQL'  , 6910,  'Morten Braten    ' from dual union all
      select 'PL/SQL'  , 6911,  'Kim Berg Hansen  ' from dual union all
      select 'PL/SQL'  , 6912,  'Bill Coulam      ' from dual union all
      select 'PL/SQL'  , 6913,  'Adrian Billington' from dual union all
      --                               ORDS ~ Voting
      ------ ------------------ -------------------------------------------------------------------------------------
      select 'ORDS'    , 6881,  'Tim St. Hilaire  ' from dual union all
      select 'ORDS'    , 6882,  'Morten Braten    ' from dual union all
      select 'ORDS'    , 6883,  'Kiran Pawar      ' from dual union all
      select 'ORDS'    , 6884,  'Dimitri Gielis   ' from dual union all
      select 'ORDS'    , 6885,  'Dietmar Aust     ' from dual union all
      select 'ORDS'    , 6886,  'Anton Nielsen    ' from dual union all
      --                               APEX ~ Voting
      ------ ------------------ -------------------------------------------------------------------------------------
      select 'ORDS'    , 6887,  'Trent Schafer    ' from dual union all
      select 'ORDS'    , 6888,  'Paul MacMillan   ' from dual union all
      select 'ORDS'    , 6889,  'Morten Braten    ' from dual union all
      select 'ORDS'    , 6890,  'Kiran Pawar      ' from dual union all
      select 'ORDS'    , 6891,  'Karen Cannell    ' from dual union all
      select 'ORDS'    , 6893,  'Juergen Schuster ' from dual union all
      select 'ORDS'    , 6894,  'Jari Laine       ' from dual union all
      --                             DatabaseDesign ~ Voting
      ------ ----------------- -------------------------------------------------------------------------------------
      select 'DbDesign', 6896,  'Michelle Kolbe   ' from dual union all
      select 'DbDesign', 6897,  'Mark Hoxey       ' from dual union all
      select 'DbDesign', 6898,  'Heli Helskyaho   ' from dual union all
      select 'DbDesign', 6919,  'Rob Lockard      ' from dual
)
,finalists_with_voters_pages as (
      select finalists.*
            ,xt_http.get_page('https://community.oracle.com/voting-history.jspa?ideaID='||to_char(userid,'fm0000')||'&start=0&numResults=1000') page
      from finalists
      where rownum>0
)
,finalists_with_voters as (
      select fp.category
            ,fp.userid
            ,fp.name
            ,voters.column_value as voter
      from finalists_with_voters_pages fp
          ,table(cast(multiset(
                      select regexp_substr(page,'alt="([^"]+)"',1,level,'c',1)
                      from dual
                      connect by level<=regexp_count(page,'<li>')
                      ) as ku$_vcnt)) voters
)
select *
from finalists_with_voters
Categories: Development

Very simple oracle package for HTTPS and HTTP

XTended Oracle SQL - Thu, 2015-10-08 19:54

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 named xt_http as
package org.orasql.xt_http;

import javax.net.ssl.HttpsURLConnection;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.HttpURLConnection;

import java.sql.Connection;
import oracle.jdbc.driver.*;
import oracle.sql.CLOB;
 

public class XT_HTTP {

   /**
    * Function getPage
    * @param String Page URL
    * @return String
    */
    public static CLOB getPage(java.lang.String sURL)
    throws java.sql.SQLException
     {
        OracleDriver driver = new OracleDriver();
        Connection conn     = driver.defaultConnection();
        CLOB result         = CLOB.createTemporary(conn, false, CLOB.DURATION_CALL);
        result.setString(1," ");
        try {
            URL url = new URL(sURL);
            HttpURLConnection con = (HttpURLConnection)url.openConnection();
            //HttpsURLConnection con = (HttpsURLConnection)url.openConnection();
            if(con!=null){
                BufferedReader br =
                        new BufferedReader(
                                new InputStreamReader(con.getInputStream()));
                StringBuilder sb = new StringBuilder();
                String line;
                while ((line = br.readLine()) != null){
                    sb.append(line);
                }
                br.close();
                result.setString(1,sb.toString());
            }
        } catch (MalformedURLException e) {
            result.setString(1, e.getMessage());
        } catch (IOException e) {
            result.setString(1, e.getMessage());
        }
        return result;
    }
    
    public static java.lang.String getString(java.lang.String sURL) {
        String result="";
        try {
            URL url = new URL(sURL);
            HttpURLConnection con = (HttpURLConnection)url.openConnection();
            if(con!=null){
                BufferedReader br =
                        new BufferedReader(
                                new InputStreamReader(con.getInputStream()));
                StringBuilder sb = new StringBuilder();
                String line;
                while ((line = br.readLine()) != null){
                    sb.append(line);
                }
                br.close();
                result = sb.toString().substring(0,3999);
            }
        } catch (MalformedURLException e) {
            return e.getMessage();
        } catch (IOException e) {
            return e.getMessage();
        }
        return result;
    }
}
/

[collapse]

package xt_http
create or replace package XT_HTTP is
/**
 * Get page as CLOB
 */
  function get_page(pURL varchar2)
    return clob
    IS LANGUAGE JAVA
    name 'org.orasql.xt_http.XT_HTTP.getPage(java.lang.String) return oracle.sql.CLOB';

/**
 * Get page as varchar2(max=4000 chars)
 */
  function get_string(pURL varchar2)
    return varchar2
    IS LANGUAGE JAVA
    name 'org.orasql.xt_http.XT_HTTP.getString(java.lang.String) return java.lang.String';
    
end XT_HTTP;
/

[collapse]

We have to grant connection permissions:

dbms_java.grant_permission(
   grantee           => 'XTENDER'                       -- username
 , permission_type   => 'SYS:java.net.SocketPermission' -- connection permission
 , permission_name   => 'ya.ru:443'                     -- connection address and port
 , permission_action => 'connect,resolve'               -- types
);

And now we can easily get any page:

USAGE example:
declare
  c clob;
  s varchar2(8000);
begin
  --- Through HTTPS as CLOB:
  c:=xt_http.get_page('https://google.com');

  --- Through HTTP as CLOB
  c:=xt_http.get_page('http://ya.ru');
  
  --- Through HTTPS as varchar2:
  s:=xt_http.get_string('https://google.com');

  --- Through HTTP as varchar2
  s:=xt_http.get_string('http://ya.ru');
end;
/
select length( xt_http.get_page('https://google.com') ) page_size from dual
Categories: Development

How to delete older emails from GMAIL

Arun Bavera - Wed, 2015-10-07 09:40

image

image

 

Other category:

category: social older_than:45d

Categories: Development

About My Son, Chris Silva, Amazing Artist, Father and All-Around Human Being

FeuerThoughts - Tue, 2015-10-06 14:59
"For the record...."




Chris is the 2015 recipient of a 3arts grant, which makes me incredibly proud and also gives me the opportunity to share his professional art bio (I mostly experience him these days as Papa to my two wonderful granddaughters).

Born in Puerto Rico, Chris Silva has been a prominent figure in Chicago’s graffiti and skateboarding scenes since the 1980s, as well as an enthusiastic fan of a wide range of music genres which have resulted from the influence of metropolitan life. Building on his solid graffiti art foundation, Silva proceeded to play a significant role in the development of what is now commonly referred to as "street art." He now splits his time between working on large-scale commissions, producing gallery oriented work, and leading youth-involved public art projects. As a self-taught sound artist with roots in DJ culture, Silva also anchors a collaborative recording project known as This Mother Falcon, and has recently started integrating his audio compositions into his installation work.

In the early 90s, Silva worked on a mural with the Chicago Public Art Group and was eventually brought on board to help lead community art projects with other urban youth. As a result, the act of facilitating art experiences for young people has become an important part of his art practice, and he regularly includes students as collaborators on large-scale artwork that often leans heavily on improvisation. Over the years, Silva has helped orchestrate youth art projects both independently and in partnership with Chicago Public Art Group, Young Chicago Authors, Gallery 37, Yollocalli Arts Reach, After School Matters, and the School of The Art Institute of Chicago.

Silva was awarded a major public art commission by the Chicago Transit Authority to create a mosaic for the Pink Line California Station (2004); created block-long murals in Chicago's Loop “You Are Beautiful” (2006); created a sculpture for the Seattle Sound Transit System (2008); won the Juried Award for Best 3D Piece at Artprize (2012); and created large commissions for 1871 Chicago (2013), the City of Chicago, LinkedIn, CBRE (2014), OFS Brands, and The Prudential Building (2015). He has exhibited in Chicago, San Francisco, Los Angeles, New York City, Philadelphia, London, Melbourne, Copenhagen, and The International Space Station. In 2007 Silva received an Artist Fellowship Award from The Illinois Arts Council.
Categories: Development

Column Group Headings in an Interactive Report (APEX 5.0)

Dimitri Gielis - Tue, 2015-09-29 06:12
In 2008 I blogged about how to add Group Headings into an Interactive Report in Oracle Application Express (APEX 3.x!).

Here's an example what I mean with Group Headings, you want to logically group certain columns (e.g. Empno, Ename) and have a group name above them (e.g. Group 1):


The approach I used at that time worked, but it required a lot of manual work. In 2009 Martin D'Souza improved it and wrote a blog post about that. In 2010, when plugins were introduced in APEX 4, Martin wrapped it all in a nice APEX plugin which made adding Column Group Headings almost declarative. The plugin was further improved and put on GitHub.

Today, having APEX 5, and the Interactive Reports being changed a lot behind the scenes, the plugin was broken. As we're in the middle of restructuring how to share code, plugins etc., I forked Martin's git repo and made the plugin compatible with APEX 5 and Universal Theme (see version 1.0.4), so when you need it, you can grap it from the forked repo. At a later time the plugin will be moved to OraOpenSource, so depending when you read this post, check out OraOpenSource as Martin, I and many other developers will start putting our open source code on OraOpenSource.

Here's a quick how to use the plugin.

Step 1: Download the file dynamic_action_plugin_com_clarifit_apexplugin_ir_column_grouping.sql
Step 2: Import the plugin in your APEX application
Step 3: Define the Groups in the Interactive Report (you can right click on Column Groups in the  Attributes of your Interactive Report and add the Groups you need):


Step 4: Assign the group to the columns of your report (you can multi select the columns and in the right pane you can select the group):


Important: define for every column that has a group defined, a static id equal to the name of the column (e.g. ENAME).

Step 5: Add the dynamic action plugin to the page
When:
- Event: After Refresh
- Selection Type: Region
- Region:
Action:
- IR Column Grouping [Plug-In]



That's it... note that when you scroll down and you have sticky headers, the group will stay with it.


Categories: Development

Lot's Wife

Greg Pavlik - Mon, 2015-09-28 11:57
Lot's Wife
by Anna Akhmatova
an interpretive translation by Greg Pavlik
The righteous Lot heard the voice of God
As if coming from the distant and black mountains.
But his wife,
She saw what was until yesterday her blessing.
Under the beautiful spires of Sodom,
Where she sang spinning cloth -
The empty window of the room,
In which her children were born.
She looked – and her pain died with her,
For she could look no more:
Her body translucent salt,
Her feet joined the earth.
Who will mourn for Marah?
An insignificant role in a grand saga -
Yet my conscience cannot forget
The one who gave her life for a fleeting glance.
-----
Original poem
И праведник шел за посланником Бога,
Огромный и светлый, по черной горе.
Но громко жене говорила тревога:
Не поздно, ты можешь еще посмотреть
На красные башни родного Содома,
На площадь, где пела, на двор, где пряла,
На окна пустые высокого дома,
Где милому мужу детей родила.
Взглянула – и, скованы смертною болью,
Глаза ее больше смотреть не могли;
И сделалось тело прозрачною солью,
И быстрые ноги к земле приросли.
Кто женщину эту оплакивать будет?
Не меньшей ли мнится она из утрат?
Лишь сердце мое никогда не забудет
Отдавшую жизнь за единственный взгляд.

Custom image on your APEX app login page

Dimitri Gielis - Sun, 2015-09-27 16:15
In a comment on my post APEX 5.0: pimping the Login page I got a question how to put your own logo or a custom image on the login page, instead of an icon.

You only need a bit of CSS to do the trick:

You can add the above CSS to your login page - Inline CSS in page attributes or you can add it to your page template or custom CSS in Universal Theme.

The result is this:


To differentiate the login page you can do a lot more, here're some things we show during our APEX UI training:

  • add transparency to the login box
  • add a background image to your entire page (blurred or not)
Again, you can do that with just some CSS.
Categories: Development

ORDS... Yes we can!

Dimitri Gielis - Fri, 2015-09-25 04:55
On September 13th I got a nice surprise, an email of Steven Feuerstein with the message: "You have been selected as a finalist in the ORDS category for the 2015 Oracle Database Developer Choice Awards!"

It's always nice to get recognition for the efforts you do, so thanks so much already for the nomination. I didn't make publicity yet in order to get some up-votes, but I hope by reaching out to the people who read my blog, I gain some more up-votes :)

 

To be honest, I wondered why I deserved this nomination, especially in a category that I'm probably less "known" for.
After giving this more thought, I remembered ORDS actually started being very much linked to APEX. In the early days ORDS was even being called the "APEX Listener", and I was one of the early adopters and promoters of using the APEX Listener (now ORDS) in your APEX architecture.

In 2012 I literally travelled around the world (Belgium, the Netherlands, UK, San Francisco, San Antonio, Uruguay, Brazil, Chile) to talk about why you should move to the APEX Listener.



When looking back at that presentation, today it still stand; you still have different options for your APEX architecture, but we don't have to convince anymore about the benefits of choosing for ORDS. ORDS is now main-stream, widely adopted and proven technology. Unless it's a legacy system, I don't really see any reason anymore why you should not use ORDS in your architecture.

ORDS evolved a lot over time, and the new name reflects more what the core feature is "Oracle REST Data Services". REST web services became so important in the last years and that is exactly what I've been blogging and talking about lately (see further).

In my presentation of Microsoft Sharepoint and Oracle APEX integration (given in San Francisco, BeNeLux and Germany) I talk about the architecture and how you get your APEX data in Microsoft Sharepoint by using ORDS. But also the other way round, by using Sharepoint APIs, REST web services come into play. When you want to integrate with other systems, ORDS can really help.



I didn't blog much yet about a really interesting R&D project we've been working on in the last months - using wearables to capture sensor and patient data. At the Oracle Mobile day in the Netherlands I did a presentation which explains it in more detail. We developed native smarth phone applications that call REST web services all build in ORDS. ORDS is getting or pushing the data into our Oracle Database using JSON. Next to that we've dashboards in APEX to "see" and work with the data. We learned and still learn a lot of this project; about the volume of data, the security etc. but without ORDS it would not have been possible.



And finally a product where I'm really proud of APEX Office Print (AOP). I found it always a challenge to get documents out of APEX. I'll do some more blog posts about it in the future, but where APEX is so declarative to build your web applications, it's far from declarative to get documents out in Word, Excel, Powerpoint or PDF (at least without BI Publisher). With APEX Office Print we hope to address that. Just one APEX plugin where you define the template and which data you want to use and presto you get your document. Behind the scenes we use JSON and having ORDS makes it really easy to generate it. If you want to know more about the components behind the printing solution (and do it yourself), you'll find that in my presentation about Printing through Node.js which I presented in different countries and will present at Oracle Open World.



Furthermore, if you're interested in reading more about JSON, I've done a series of blog posts and was interviewed by Oracle about it, you find the links here.

Hopefully by doing this post you see the power of ORDS and you get some ideas yourself how to best leverage the power of this wonderful piece of software. If you liked my "ORDS-efforts" and want to give me an up-vote in the Database Developer Choice Awards, I really appreciate that.

Thanks so much,
Dimitri

Categories: Development

Oracle Database Developer Choice Awards

Denes Kubicek - Wed, 2015-09-23 00:28
Don't forget to vote for the expert of your choice at https://community.oracle.com/community/database/awards. There are a lot of good men there deserving your voice for their activities in the community and for their selfless engagement.

Categories: Development

EM12c 12.1.0.5 Upgrade Tasks

Arun Bavera - Mon, 2015-09-14 14:51
1.      Upgrade Primary OMR, OMS using Installer of 12.1.0.5   - 2 Hours
   Check if OMR requires upgrade:
12c Database has been Certified as an EM 12.1.0.4 or 12.1.0.5 Repository with Certain Patchset and PSU Restrictions (Doc ID 1987905.1)
12.1.0.2 Patch Set Updates - List of Fixes in each PSU (Doc ID 1924126.1)
12.1.0.2 Patch Set - Availability and Known Issues (Doc ID 1683799.1)
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1)


Applying Enterprise Manager 12c Recommended Patches (Doc ID 1664074.1)

2.     Upgrade Primary Agent      - 6 Minutes

3.      Cleanup Agent

4.      Cleanup OMS

5.      Upgrade Secondary  OMS     - 30 Minutes

6.      Cleanup Agent

7.      Cleanup OMS

8.      Apply Monthly Agent/OMS Patches available 
    Oracle Recommended Patches (PSU) for Enterprise Manager Base Platform (All Releases) (Doc ID 822485.1)
    Document 2038446.1 - Enterprise Manager 12.1.0.5.0 (PS4) Master Bundle Patch List

9.  Install Latest JDK 1.6 (Note: 1944044.1) JDK 1.6.0.95.. 
        Refer:
All Java SE Downloads on MOS (Doc ID 1439822.1)
  How to Upgrade JDK to 1.6 Update 95 on OMS 12.1.0.4 or 12.1.0.5 (Doc ID 2059426.1)
How to Upgrade the JDK Used by Oracle WebLogic Server 11g to a Different Version (Doc ID 1309855.1)
How to Upgrade the JDK Used by Oracle WebLogic Server 12c to a Different Version (Doc ID 1616397.1)
         How to Install and Maintain the Java SE Installed or Used with FMW 11g/12c Products (Doc ID 1492980.1)

10.     Install Weblogic latest PSU (1470197.1)  

11.  Verify Load Balancer

12.  OMS Sizing 

Refer:
Enterprise Manager Cloud Control Upgrade Guide

EM 12c R5: Checklist for Upgrading Enterprise Manager Cloud Control from Version 12.1.0.2/3/4 to 12.1.0.5 (Doc ID 2022505.1)

12c Database has been Certified as an EM 12.1.0.4 or 12.1.0.5 Repository with Certain Patchset and PSU Restrictions (Doc ID 1987905.1)

EM 12c: How to Patch the EM-Integrated Oracle BI Publisher (Doc ID 1982656.1)

http://oraforms.blogspot.com/2014/05/oracle-em12c-release-and-patch-schedules.html


Categories: Development

Forcing Garbage Collection in JDK manually using JVisualVM

Arun Bavera - Mon, 2015-09-14 14:43
You might have seen many times heap crossing the limit and GC algorithm not working properly and keeping old object long time.
Even though it is not advised to force major GC manually if you come across a situation you can use the following method to clear the Heap.
Note. If the Heap size is huge more than 6GB doing major GC may cause application to wait for couple of seconds. Also, make sure you have enough system memory(RAM) to invoke the tool JVisualVM.
This is typical method in many corporates where X-Windows is not installed on their *NIX machines and app account is locked down for direct login.
1) Login as yourself into Linux/Unix machine and make sure your laptop/Desktop has X-emulator like xming running.
2) Note down the authorized X-keys:    xauth list
3) Login as app owner :     sudo su – oracle
4) Add the X-keys to oracle(App owner session)
xauth add <full string from xauth list from previous session>image

5) Do ps –ef|java , note down the JDK directory and go directly to JDK bin (/opt/app/oracle/jdk1.7.0_55/bin ) in this case we are using JDK7
6) Invoke  ./jvisualvm &
7) Choose the Weblogic PID and make sure in the Overview tab the server name is the one you are interested and Perform manual GC.
  Note: From JDK 7 onwards if your Heap size is more than 6GB then G1GC algorithm works in best possible ways. 
     Also refer: https://blogs.oracle.com/g1gc/

image
Categories: Development

Report Carousel in APEX 5 UT

Dimitri Gielis - Mon, 2015-09-14 10:45
The Universal Theme in APEX 5.0 is full of nice things.

Did you already see the Carousel template for Regions
When you add a region to your page with a couple of sub-regions and you give the parent region the "Carousel Container" template it turns the regions into a carousel, so you can flip between regions.

I was asked to have the same functionality but than on dynamic content.
So I decided to build a report template that would be shown as carousel. Here's the result:



I really like carousels :)

Here's how you can have this report template in your app:
1) Create a new Report Template:


Make sure to select Named Column for the Template Type:


Add following HTML into the template at the given points:




That's it for the template.

Now you can create a new report on your page and give it the template you just created.
Here's the SQL Statement I used:

select PRODUCT_ID          as id,
       PRODUCT_NAME        as title,
       PRODUCT_DESCRIPTION as description,
       product_id,       
       dbms_lob.getlength(PRODUCT_IMAGE) as image,
       'no-icon'           as icon,
       null                as link_url 
  from DEMO_PRODUCT_INFO

Note 1: that you have to use the same column aliases as you defined in the template.
Note 2: make sure you keep the real id of your image in the query too, as otherwise you'll get an error (no data found)

To make the carousel a bit nicer I added following CSS to the page, but you could add it to your own CSS file or in the custom css section of Theme Roller.


Note: the carousel can work with an icon or an image. If you want to see an icon you can use for example "fa-edit fa-4x". When using an image, define the icon as no-icon.

Eager for more Universal Theme tips and tricks? check-out our APEX 5.0 UI training in Birmingham on December 10th. :)

For easier copy/paste into your template, you find the source below:

 *** Before Rows ***  
<div class="t-Region t-Region--carousel t-Region--showCarouselControls t-Region--hiddenOverflow" id="R1" role="group" aria-labelledby="R1_heading">
<div class="t-Region-bodyWrap">
<div class="t-Region-body">
<div class="t-Region-carouselRegions">
*** Column Template ***
<div data-label="#TITLE#" id="SR_R#ID#">
<a href="#LINK_URL#">
<div class="t-HeroRegion " id="R#ID#">
<div class="t-HeroRegion-wrap">
<div class="t-HeroRegion-col t-HeroRegion-col--left">
<span class="t-HeroRegion-icon t-Icon #ICON#"></span>
#IMAGE#
</div>
<div class="t-HeroRegion-col t-HeroRegion-col--content">
<h2 class="t-HeroRegion-title">#TITLE#</h2>
#DESCRIPTION#
</div>
<div class="t-HeroRegion-col t-HeroRegion-col--right"><div class="t-HeroRegion-form"></div><div class="t-HeroRegion-buttons"></div></div>
</div>
</div>
</a>
</div>
*** After Rows ***
</div>
</div>
</div>
</div>
*** Inline CSS ***
.t-HeroRegion-col.t-HeroRegion-col--left {
padding-left:60px;
}
.t-HeroRegion {
padding:25px;
border-bottom:0px solid #CCC;
}
.t-Region--carousel {
border: 1px solid #d6dfe6 !important;
}
.t-HeroRegion-col--left img {
max-height: 90px;
max-width: 130px;
}
.no-icon {
display:none;
}
Categories: Development

Count Selected Rows

Denes Kubicek - Sat, 2015-08-29 06:44
This small example is showing hot to make sure at least one row in your tabular form has been selected prior to proceeding:

https://apex.oracle.com/pls/apex/f?p=93000:806

Categories: Development

Switch Panes in Page Designer

Denes Kubicek - Sat, 2015-08-29 04:36
This is definitely worth of mentioning. Go here and download this plugin for Firefox or Chrome. You will like it. It switches the panes in the Page Designer so you can much easier access the properties of the selected elements. Congrats Filip. This is a cool feature. Thanks.

Categories: Development

Expert Oracle Application Express (second edition) available

Dimitri Gielis - Thu, 2015-08-20 06:03
During my holiday Apress released the second edition of Expert Oracle Application Express.
In the second edition we not only updated the content to APEX 5.0, but there're some new chapters in too from new authors. In total you get 14 chapters from 14 different authors.
I believe it's a very nice book with great content and it's for a good cause. Roel describes it very nicely in his blog post "the goal is to raise as much money as we can for the funds that support the relatives of two of the greatest Oracle APEX Development Team members who passed away a few years ago: Carl Backstrom and Scott Spadafore."


You can get it from the Apress website or from Amazon. Happy reading :)

Categories: Development

How To Use The SQL Developer Export Connections With Passwords Function

Complete IT Professional - Thu, 2015-08-13 06:00

SQL Developer Export ConnectionsOracle’s SQL Developer tool lets you export a list of connections that you have created. This is great for saving time for your team. Learn how you can do that in this article.

Why Export Connections?

First of all, why would you want to export your connections?

There are a few reasons I can think of.

  1. Keep a separate file that contains your connections in case your computer crashes
  2. Save time setting up your computer if you get a new one
  3. Sharing common connections with the rest of the team so they can easily import and use the same connections

Let’s take a look at how to export connections in SQL Developer.

 

SQL Developer Export Connections Process

I’m going to assume you have at least one connection created in SQL Developer.

If you don’t you can read my guide or watch my video on how to set up a connection in SQL Developer.

In the image here, I have three.

connection 01

Now, to find the SQL Developer Export Connections menu option, right click on the Connections item in the tree, and select Export Connections…

connection 02

The Export Connections wizard will appear.

connections 03

Select the connections you want to export by clicking in the checkbox next to each item. You can select all items by clicking on the top-level Connections item, which is what I have done.

Then, click Next.

You’ll then be asked for an output file.

connections 04

You can enter the full path name for the file (location and filename), or click on Browse.

connections 05

Find the location where you want to save your connections file, and enter a filename. Connections are saved as an XML file, and I’ll show you an example later in this article.

Click Save.

Now, click Next.

You’ll be asked if you want to encrypt passwords or remove passwords.

connections 06

This is an important step, as you don’t want passwords in free-text fields in your exported file. You have two options

  • Encrypt all passwords with a key. You enter an encryption key to use, which you’ll need to enter again in the Verify Key box.
  • Remove all passwords from the exported connections. This removes the passwords, which means you’ll need to re-enter them when you go to use them.
I personally prefer the encryption option, as it saves time. If you’re OK with this, select this option. Enter a key in both boxes and click Next.

The Summary is shown. Click Finish.

connections 07

Your connections file is created, which is an XML file listing all of your connections.

connections 08

So, that’s how you use the SQL Developer Export Connections function.

Lastly, if you enjoy the information and career advice I’ve been providing, sign up to my newsletter below to stay up-to-date on my articles. You’ll also receive a fantastic bonus. Thanks!

Categories: Development

20 Things Every Computer Science Graduate Should Know Before Starting a Job

Complete IT Professional - Mon, 2015-08-10 06:00

20 Things Every Computer Science Graduate Should Know Before Starting a JobYou’ve completed your Computer Science degree and have got yourself a job. Well done! Welcome to the real world! Now, there are a few things you should know before starting your first day, which I’ve listed in this article.

1 – The Days Can Be Long

Finishing a Computer Science degree will often lead you into a software development-related role. There are usually standard hours for this kind of role, which is something like 9AM to 5PM. The actual hours may be slightly different, but in general, it’s an 8 hour day.

That’s a long time to be at work if you’re new to the industry. If you’re coming from college or university, you may have had a part-time job, where you worked a few hours at the local grocery store or in a cafe or something.

Coming into a role in software development is different. You’ll be in an office. You’ll be sitting down. And you’ll be there for about 8 hours each day.

This is something I didn’t really consider when I started working. Sure, 8 hours may not seem like much, but when you’re sitting down for most of it, you can get pretty tired pretty quickly.

Also, it requires a lot of concentration. University classes are broken up into blocks and often have breaks. The day doesn’t always go for 8 hours at university, either.

So, it might not be something you are used to. The days may seem long.

You’ll get used to them though.

My part-time job in uni was in a restaurant. I found it hard going from a job where I was walking around all the time to a job where I was sitting down all day. But I got used to it.

 

2 – Don’t Be Afraid To Ask Questions

Being a graduate and starting a job means you’re new to the job and new to the industry. People have lower expectations of graduates than other employees.

So, if you’re not sure what to do, ask someone. If you’re not sure what something means, or how something works, ask someone.

You shouldn’t be afraid of asking questions. Everyone in the workplace was new at one stage, so they know what it’s like. They may know the kind of questions you want to ask and the struggles you might have.

If you have a question, ask someone. Ask your manager, ask a co-worker, ask someone you see around in the kitchen. People will usually be happy to help, especially if they know you’re new.

I still ask questions at work when I don’t know what something is. It’s much better to ask a “stupid” question than to make a stupid mistake (even though I don’t think any question is stupid).

 

3 – Take Lots Of Notes

When you start your first job, you’ll be learning a lot. You’ll learn how the company works, how the systems work, who people are, and what each department does.

You should take notes on this. Lots of notes. Don’t rely on your memory, as you’ll be learning a lot of things when you start. There’s no slides or lecture material that’s available that people will send out.

Sure, there may be some documentation and information on the Intranet that describes how the company works, but in most places, the documentation is not kept up to date, or they may be “exceptions” to the document.

Whenever you go to a meeting or are learning something from someone, take notes. Write them down in a notebook, or write them on your computer.

I prefer taking notes on the computer as they’re easy to read (my handwriting is messy), searchable, and accessible anywhere. I use Evernote for this, and if you’re interested in learning how to use it as a software developer, you can get a copy of my Evernote guide.

 

4 – Dress For The Job

If you’ve had a job before, such as a part-time or casual job during your college years, you may have had to wear a uniform. If not, at the very least you might have had some dress standards you needed to stick to.

The same concept is true for full-time work in the IT industry. You’ll need to dress for the job that you’re doing. When I say this, I mean that each company has dress standards, which is criteria of what is appropriate to wear at the office, and what isn’t.

I suggest that when you start working, get an understanding of this dress code, and stick to it. If you are required to wear a suit and tie every day, then wear a suit and tie every day. If you need to wear a shirt and pants but no tie, then wear that every day. If it’s neat jeans and a collared shirt, then you can wear that.

If there is no dress code, just ask about it. Ask someone during the interview or after you have received an offer for the job (if they don’t tell you during this process anyway).

It’s better to know before you start work, than to show up on day one with something inappropriate.

 

5 – If You Have Nothing To Do, Ask For More

Your manager’s role at work is, among many things, to monitor your workload. They will give you tasks to do for the project or team that you’re in.

If you get to a point where you finish the work they have given you, then you have nothing to do. In this situation, ask for more work. Don’t sit there with nothing to do and browse the Internet aimlessly, or play with your phone.

Ask your manager for something else to do. They may not be aware that you’ve run out of work or that you’ve finished it.

They may also want to review what you’ve done. So, if you need to, you can show it to them, or send the work to them to review.

The point of asking for more is to show initiative, and show that you are there to get the job done and help the team, not to slack off until 5PM arrives.

 

6 – Programming In The Real World Is Not Like College

You would have done some programming in college as part of your degree. When you write code, they would have taught you to do some design at the start, and then build your program from there. You would perform tests, compile the code, find an issue, fix it, and repeat.

It would usually move pretty quickly, and the only constraints would be how much effort you wanted to put in. You were often working on it by yourself, so if you wanted to work late to fix something, you could. You could add in any features or designs that you wanted.

Now, in the “real world” of working as a programmer, it works quite differently.

You usually start with the requirements which are provided to you by the business analysts, who get those from the users. The BA’s document them in a way that makes sense for the team, such as in Agile stories or a BRD.

From there, you, as a developer, would analyse them and see if they make sense to you. If they do, you can build them. If not, then you’ll need to clarify them.

After your requirements have been confirmed, you would them start some kind of design. This is done all at the same time, or in stages, depending on the methodology that your team uses.

At some point during the design phase, you may need to estimate how long it would take to build it. In many projects I’ve been on, this is one of the hardest parts to do. The estimate needs to be realistic, but can be hard given that you don’t know what you don’t know.

Once the work has been estimated, it may need to be approved by the project sponsors, to basically say “yes, we are happy with this and wish to proceed”.

From there, you would start the actual development.

Because you’re in a team, you have less control over what you can do with it. You’ll need to stick to the requirements that are provided, but any changes or suggestions you have would need to be confirmed with other people.

If something takes more time than you thought, you may need to put in overtime, or the project team may make a decision to not add that functionality in.

So, basically, it’s not all up to you to do the development, as you’re part of a team, and there are other people paying for the project who specify the requirements.

 

7 – Keep a To-Do List

I started in the IT industry in an application development and support role. It started pretty smoothly, but as I got more experienced, I found I had more work to do and more things to look after. I tried keeping track of things I needed to do, with limited success.

Now, one of the most important things I do at work is maintain a to-do list. It’s also one of the first things I set up when I go to a new client site.

The realisation for this was when I read “How To Get Things Done” by David Allen. He teaches a principle called “Getting Things Done”, or GTD for short. Basically, it involves keeping a written list of everything you need to do, instead of keeping it in your head.

This book and the GTD concept has probably been the most important concept I’ve learnt throughout my career. It’s helped me be more productive in my work and in my life overall.

So, when you get started at a new job, keep a list of things you need to do.

You can do this by:

  • Pen and notebook
  • Evernote list
  • Specific to-do app on your phone
  • Some other method

It doesn’t matter how you keep a to-do list, the important thing is that you actually keep one. It will improve the way you work, and impress your new team with how organised you are.

 

8 – Don’t Take Too Long On Your Breaks

As part of working full time, you’ll probably get an allocated time to take a lunch break. The actual time depends on the company, but I’ve usually been able to take a lunch break of up to one hour, at any time between 12PM and 2PM.

If you’re new to the IT industry, it can be hard to stick to this time, especially if you came from college. College is a bit more relaxed, where you may have skipped a few classes, or had a three hour break for lunch between classes.

With the workplace, it’s a bit different. You’re part of a team that depends on you working and getting things done. It’s also not setting a good impression if you take a lunch break longer than the recommended time.

My lunch breaks are between 30 and 45 minutes, depending on if I need to make phone calls or run errands for the day.

 

9 – Be Careful What You Say and Talk About

Working full time in the IT industry is different to working part-time or studying at college in many respects.

One area where it’s different is what you can say and what you talk about.

You might have felt comfortable talking about anything with your friends in college, or co-workers at your part time job. You could have talked about how drunk you got on the weekend, the crazy things you did, or other aspects of your life.

When you start working full time, there are some topics that are not appropriate to talk about at work.

It’s not usually a good idea to talk about getting drunk or your massive parties on the weekend. It’s also not a good idea to talk about people of the opposite sex in an offensive or discriminatory way. You should also respect other people’s race, religion, and culture.

Some things that you might have said around your friends or other co-workers are just not appropriate in the workplace.

You might already know this, but it’s good to be safe.

 

10 – You Won’t Get Paid Overtime

A part time job in college usually meant that you have a set number of hours you work, and you get paid an hourly rate. Any extra time after that and you’d get overtime.

This is generally how it works, but it depends on the job you have.

In the IT industry, you don’t get paid overtime. You are expected to work the minimum hours, of course, but when the need arises, you’re also expected to put in extra time.

This is all covered under your salary, so you don’t get paid extra for the additional hours you do.

This might seem unfair. Why would you put in extra hours if you don’t get paid for it?

Well, there are a few reasons:

  • A project deadline is approaching
  • There’s an issue in a live system that needs fixing
  • You’ve found something takes longer than expected and you’re already behind

So, if you’re expecting to get paid for extra hours, then you probably won’t be. The only exception is if you’re in some kind of on-call support role, as they are often paid for overtime and weekends.

 

11 – You Need To Be Able to Budget

Another important lesson is that you’ll need to learn how to budget your money.

Going from college, where you might have had a part-time job, to full time work, usually results in a big increase in your pay.

You’ll be tempted to spend the money you get, buying new gadgets and going out for dinner.

However, you’ll find that you don;t have enough money for what you want to do. If you need to pay rent, this is something you must pay, and you don’t want to be short one month for rent!

It took me a few years to realise that budgeting is important.

Budgeting might sounds boring, but it’s just the process of working out how much you get paid and how much you need to spend in different areas of your life.

The best way to improve something is to actually track it.

So, to start, write down how much you get paid each period (weekly or monthly, for example)

Write down all of your expenses for that period.

The number you have left over is what you can spend.

Now, this isn’t a personal finance site, so while it’s a topic I’m really interested in, I won’t go into details here.

Two websites that I follow regularly and who offer great financial information are Financial Samurai, and I Will Teach You To Be Rich (by Ramit Sethi).

Both of those websites have a lot of great information. They are both based in the US, but I’ve found the information and concepts valuable even living in Australia.

 

12 – The Environment May Not Always Be Suitable

When you were working on college assignments, you may have done them at home, or gone to the library. You had the option of moving around to find a place that’s suitable for you.

However, when you go to work full time, the environment you work in is fixed. It might not be suitable for the way you work.

The main thing to be aware of is distractions. Because there are so many people in an office, there can be a lot happening.

Some examples of things that can distract you are:

  • Other people getting phone calls
  • Your phone ringing
  • Other people talking to each other nearby
  • People walking around and making noise (closing doors, etc)
  • Some people playing music at their desk
  • Group activities in the office (foosball table, TV)

Working in an environment like this takes a lot to get used to.

Fortunately, over time I’ve been able to block out everything around me and focus on my work, most of the time. Sometimes, though, I don’t even notice when people are talking to me, which can seem a bit rude!

So, it’s just another thing to be aware of. Having distractions in the office can often mean that your work environment isn’t as suitable as you like.

Many offices these days also adopt the open-plan structure, which means they have no partitions between desks and people are sitting close to each other, instead of the high walled cubicles that you see on TV and in movies. This means that noise travels further and it’s easier to get distracted – not good if you’re a developer and need to focus on solving a problem in your code.

 

13 – Managers Love Having Meetings

You might think that managers are responsible for giving you work and managing projects you’re on.

This is true, but there’s also another thing they do with their day.

They have meetings.

So many meetings.

I’ve worked for quite a few clients in my time, and a common theme is that all of the managers are always in meetings for most of the day.

It’s like it’s a requirement of that position, and that it’s the only way to get things done.

I don’t think they actually love the meetings, it’s just an obligation or a way to discuss what needs to happen.

However, you’ll notice that your manager, and probably other managers, will be off in meetings for a long time. It might come as a surprise, but this is just a part of working life.

 

14 – You Can’t Always Install What You Want

Companies like to lock down their employee’s computers for security reasons. The restrictions depend on the company, so some companies are more relaxed than others, but overall, there is usually some kind of restriction on the computer you use at work.

As someone who works in the IT industry, you’re probably pretty familiar with how computers work. You know your way around the operating system and are comfortable with many different programs.

To get things done easier, you might want to install different programs on your computer. Evernote, 7Zip, Sublime, and Dropbox are some examples that I’ve seen.

However, the IT department might have prevented you from installing these. You won’t be allowed to install some programs on your laptop.

This is mainly for security reasons. They set up a company-wide policy that meets their security requirements, and it will either block you from installing this software, or automatically remove it every so often.

This might seem alarming to you, and even quite annoying. What do they know? You’re not going to do anything suspicious! It helps you get your work done?

There are two things you can do. You can suggest to your manager that these tools will help you do your work and see if you can get an exception to the policy.

Or, you can use the tools that are available on your computer.

Most of the time, I’ve just stuck with the tools available on my computer. They are not ideal (I’d rather use Notepad++ than Notepad), but it still lets me get the job done.

 

15 – Keep Your Personal Work To A Minimum

Working full time means that you’ll be occupied during normal business hours – from 9AM to 5PM. This is the time that most other businesses open as well.

As you start working full time and getting more responsibility in life, there are probably more things you need to get done during the day outside of your work.

Some of these are:

  • Booking your car in to the mechanic
  • Buying tickets to events
  • Calling your phone company
  • Shopping for clothes
  • Buying things for your house
  • Keeping track of your finances

Some of the tasks I’ve listed here can be done online while at home. Some other tasks can only be done during business hours. Your phone company may only accept calls between 9 and 5. This means you’ll need to take time out of your day to do this.

When you start working full time, I suggest that you keep this kind of work to a minimum. Don’t spend hours each day going to the shops, making calls, and browsing other sites to get your personal work done.

Sure, you’ll need to do a bit here and there. I recently moved house and there were a lot of calls to make and a lot of places to update my details online. However, I kept it to a certain time each day.

The reason for this is so you set a good impression. You don’t want people to think all you do is your personal to-do list.

The best time to do this is during your lunch break. However, a lot of other people have the same idea, so it’s often busy. If you can’t do it during lunch, choose another time, perhaps in the afternoon, or a time when you don’t have an immediate task to work on.

 

16 – Getting to Work May Take Longer And Have Delays

Aah, the joys of commuting to work.

If you had a part-time job while you were studying, it may have been pretty close to where you live. It could have been the local supermarket, restaurant, or some other kind of retail store.

When I was studying, I worked in a Mexican restaurant which was about a 10 minute drive from home. This was great for getting to and from work.

A lot of full-time jobs are based in a central business district (CBD). This, of course, depends on where you live, but it’s quite common. And, you may not live in the CBD. Which means it will take you longer than what you’re used to getting to work.

You can either drive to work (if you have a car), or get public transport. It depends on where you live, of course. In Melbourne, we have a few choices. I used to drive to work, then I started getting the train.

The time it takes to get to work will be longer than what you’re used to. Don’t be surprised if you find you have to leave home at 7:30 to get to work by 9.

Also, because it’s the time when everyone is going to work, it will be busy. The same drive at night time will be a lot faster than in the morning peak-hour traffic.

It can also mean delays. Car accidents can cause delays for a long time. Delays with public transport may be rare, or quite regular, depending on your city. In Melbourne, they happen almost every day!

So, just be aware that getting to work will take longer than you expect.

 

17 – You’re Not Stuck in One Role

The good news about working in IT is that you’re not stuck to a particular role. In many other industries, you’re often working in a role for a long time, and you get promotions to more senior roles. The roles may be quite similar, just with more responsibility.

However, in IT, you have a lot of flexibility to move around.

Are you a .NET Developer? Great.

Want to move into something focused more on SQL Server? Great, you can do this.

Want to be involved in testing? Sure.

Want to move into project management, or team leading, or business analysis? Sure, you can do that as well.

To move around roles you need some training and some experience. You can use experience in one role to move to the next, so after a couple of years in one role (for example) you can look to move towards a different role, if you want.

Training is the other big factor. You’ll need to know how to do the job that you want, so it’s a good idea to look into some training and learn how the new role works. This will make it easier for you and the company.

Many vendors and companies offer all kinds of training, so do a Google search for some related training courses.

 

18 – This Won’t Be Your Last Employer

The company you start working for in your first job in IT won’t be the last employer. It’s rare for people these days to stay in a job for their entire lives, like our parents or grandparents might have.

Don’t be afraid that you’re taking the wrong job, or that you’ll be stuck at a company. Sure, it’s important to start working at a good job and one that will improve your skills and career, but don’t feel like you need to pick one and commit to it for life.

It’s common for people to move around employers, and it’s a great way to improve your salary (which I teach in my IT Salary Success course).

If you start working somewhere and get some good experience after a few years, you are allowed to leave. Firstly, you should look at your current employer to see if there is room for growth, but if not, you can consider moving employers.

 

19 – Going Out for Drinks the Night Before a Work Day is Not a Good Idea

Young people like to drink. We like to go out with friends for dinner, which leads to drinks. Or we just like to go out and start drinking.

Most of the time, this happens on a Friday or Saturday night.

Sometimes, it happens during the week. Especially when you’re at uni or college. When I was at uni, a lot of bars had “Uni Nights” which were on Tuesdays and Thursdays, where uni students went out and drank.

Going out for drinks is fun. What’s not fun, is going to work the next day after going out drinking.

You might be tempted to have a few drinks on a week night, which leads into a few more drinks, and all of a sudden you’re getting home at midnight and are quite drunk.

You’ve got to get up for work the next day and put in a full day’s performance.

This is one of the hardest things to do in life – working while hungover.

I did it once, and won’t be doing it again.

It’s just not worth it.

So, it probably requires a change in lifestyle if you’re the kind of person who likes to go out and drink during the week.

 

20 – The Quality of Your Work is Important

One of the most important things to know is that the quality of the work that you do is important.

In uni and college, the quality was important as well. You write an assignment, or develop some code for your assignment. Once it’s submitted, it’s marked, you get a result, and that’s it. The assignment is never used again.

A better quality assignment meant a better grade. However, it didn’t last long. The only purpose of the assignment quality was to get a good grade.

In the IT industry, the quality of your work lasts a long time.

You code is deployed to a live, production system, and stays there for years.

Your documentation is used by the team for the entire project, and may even be used by the support team.

Your spreadsheets for your analysis may be used by other people for a while to help them do their job.

So, it’s important to produce good quality work. It helps your team, it helps your team manager, and also helps others who are affected by it.

One of the most important books I’ve read recently is “Clean Code“. It explains the importance of writing good quality, clean code. If you haven’t read it, I suggest you do.

The quality of your work is important as it can also help you get promoted and move into other roles. It’s a reflection of you and how you work, so make sure it’s good!

 

Summary
So, in summary, here are the 20 things that every computer science graduate should know before starting a job:
  1. The days can be long
  2. Don’t be afraid to ask questions
  3. Take lots of notes
  4. Dress for the job
  5. If you have nothing to do, ask for more
  6. Programming in the real world is not like college
  7. Keep a to-do list
  8. Don’t take too long on your breaks
  9. Be careful what you say and talk about
  10. You won’t get paid overtime
  11. You need to be able to budget
  12. The environment may not always be suitable
  13. Managers love having meetings
  14. You can’t always install what you want
  15. Keep your personal work to a minimum
  16. Getting to work may take longer and have delays
  17. You’re not stuck in one role
  18. This won’t be your last employer
  19. Going out for drinks the night before a work day is not a good idea
  20. The quality of your work is important

I hope you found these tips useful. Share this article with your friends and colleagues to spread the word!

Lastly, if you enjoy the information and career advice I’ve been providing, sign up to my newsletter below to stay up-to-date on my articles. You’ll also receive a fantastic bonus. Thanks!

Image courtesy of t0zz / FreeDigitalPhotos.net

Categories: Development

Ancestor Worship

Greg Pavlik - Sat, 2015-08-08 08:25
Some profound lessons in how to be human that we can learn from our Confucian friends


Pages

Subscribe to Oracle FAQ aggregator - Development