Profile

Cover photo
Liran Zelkha
Works at Tona Consulting
Attended Academic College of Tel Aviv
Lives in Kiryat Ono
484 followers|118,921 views
AboutPostsPhotosYouTube

Stream

Liran Zelkha

Shared publicly  - 
 
#Oracle ListAgg can't work with distinct. Here's my solution - http://tonaconsulting.com/using-oracles-listagg-with-distinct/
Oracle's 11g ListAgg function is a great way to concat multiple rows into a single column. However, it has a major limitation (in addition to the light documentation) – you can't use distinct in ListAgg, a serious limitation. Online solutions suggest subqueries or regular expressions.
1
Add a comment...

Liran Zelkha

Shared publicly  - 
 
Wow wow wow. What an amazing XBoxOne launch. Halo TV series? Cool.
1
Liran Zelkha's profile photoTesfahun Zaro's profile photo
3 comments
 
Yep , i have the Xbox 360 slem
Add a comment...

Liran Zelkha

Shared publicly  - 
 
These are the images shown in Google Images when searching for Liran Zelkha (and I'm bored right now. I know).
3
mike kartoon's profile photo
 
U r . totally
Add a comment...

Liran Zelkha

Shared publicly  - 
 
Integrating CAS and LifeRay without an LDAP server. New Blog Post (and my longest so far) http://tonaconsulting.com/improving-liferay-6-cas-integration/
1
Add a comment...

Liran Zelkha

Shared publicly  - 
 
Configuring Liferay 6 CE with Oracle Access Manager 11g http://tonaconsulting.com/using-liferay-sso-with-oracle-access-manager-11g/ #liferay   #oam  
Well, I was given a challenging task – using Oracle Access Manager 11g as an SSO provider for Liferay 6.0 (the community edition…). Now, as you might know – there is no built-in OAM support for Lifera...
1
Add a comment...

Liran Zelkha

Shared publicly  - 
 
Need to import users into Liferay Portal? Here's how http://tonaconsulting.com/import-users-into-liferay/ #liferay
If you're using Liferay, and not using LDAP, you will probably face into the same problem I did – how to import a large amount of users without manually adding them to the system. So, loving automatio...
1
Add a comment...

Liran Zelkha

Shared publicly  - 
 
Doing JDBC batch updates with JPA http://tonaconsulting.com/batch-update-with-jpa/ #jpa #java
1
Add a comment...
In his circles
419 people
Have him in circles
484 people
Unreality project's profile photo
hila harari's profile photo
Ran Silberman's profile photo
‫יחידת חילוץ גולן‬‎'s profile photo
Yaron Biton's profile photo
‫אריה בנימין‬‎'s profile photo
Amit Cherniak's profile photo
Guy Zilbi's profile photo
Yaniv Illouz's profile photo

Liran Zelkha

Shared publicly  - 
1
Amnon Sadeh's profile photo
 
If an Arab terrorist (he may call himself a 'soldier', 'freedom fighter' or whatever, but if he's targeting his Qassam rockets against civilians, then he's a terrorist) is killed by the Israel Defense Forces, then the world cares.
The world doesn't care when Arabs kill each other, even by the thousands.
Add a comment...

Liran Zelkha

Shared publicly  - 
1
Add a comment...

Liran Zelkha

Shared publicly  - 
 
So now an Android powered camera? Sorry all, but Apple is so dead... http://mashable.com/2012/08/28/samsung-galaxy-camera/
(BTW I'm still getting the new MacBook ;-) )
1
Add a comment...

Liran Zelkha

Shared publicly  - 
 
How to tune Oracle SQL statements with the JDBC thin driver and tkprof - http://tonaconsulting.com/using-oracle-tkprof-with-jdbc-thin-client-application/
1
Add a comment...
People
In his circles
419 people
Have him in circles
484 people
Unreality project's profile photo
hila harari's profile photo
Ran Silberman's profile photo
‫יחידת חילוץ גולן‬‎'s profile photo
Yaron Biton's profile photo
‫אריה בנימין‬‎'s profile photo
Amit Cherniak's profile photo
Guy Zilbi's profile photo
Yaniv Illouz's profile photo
Work
Occupation
Owner at Tona Consulting
Employment
  • Tona Consulting
    Owner, present
  • ScaleBase
    VP Business Development, 2010 - 2012
  • Aluna
    Co CEO, 2005 - 2010
  • 2Train4
    CTO, 2001 - 2005
  • IDF
    1995 - 2001
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Kiryat Ono
Previously
Givatim - Tel Aviv - Omer
Story
Introduction
I am still a big nerd in a (not so) small body. A technology freak with years of experience on anything from PL1/mainframe to LAMP, I love to code and talk about coding, especially on state of the art technologies - but only those that make some sense.
I really love to take good technology and turn it into something that is valuable to people. This is what I've done in my previous roles, and what I am doing right now in ScaleBase.
Education
  • Academic College of Tel Aviv
    Computer Science, 2001 - 2004
Basic Information
Gender
Male