Oracle certificate on java adds value to your resume. But, do it only if you enough have money. I seriously doubt, companies will hire anyone if they have a certificate.Oracle java certification will only help you, if you have any experience with java. Oracle certification process asks you to build a small application in the end to earn your certificate. That will certainly help you gain some knowledge and experience. It will also boosts your confidence.
There are many certifications in Java. It is like a track one after another you have to do. The first one is OCAJP. This is the basic certification in Java even people who have no experience also will be able to prepare and pass the exam.