Profile

Cover photo
Liran Zelkha
Works at Tona Consulting
Attended Academic College of Tel Aviv
Lives in Kiryat Ono
490 followers|120,535 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
490 people
Michael Mitrani's profile photo
Daniel da Silva Samo's profile photo
Uri Lehavi's profile photo
Noam Rotem's profile photo
Tomer Yalon's profile photo
John Treadway's profile photo
Ori Dar's profile photo
Rolan Shkolnik's profile photo
Elad Mallel'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
490 people
Michael Mitrani's profile photo
Daniel da Silva Samo's profile photo
Uri Lehavi's profile photo
Noam Rotem's profile photo
Tomer Yalon's profile photo
John Treadway's profile photo
Ori Dar's profile photo
Rolan Shkolnik's profile photo
Elad Mallel'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