Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to start iSQL * Plus

 
Yingie Pitts
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My question might sound silly:
I just started reviewing OCA/OCP Introduction to Oracle 9i SQL Study Guide for exam 1Z0-007. I have had difficulties to start iSQL*Plus. I really have no idea of how to find the URL of my Oracle HTTP Server. I meant, when I was taking Oracle Database (SQL*Plus) classes in school, I was never told what the Oracle HTTP Server was and how to conncet to it. To use SQL*Plus, I just needed to start my Oracle Enterprise Manager Console first, and then log into the SQL*Plus. But it seems I have to use iSQL*Plus in order to take the Exam. Also, if my computer itself can be used as Oracle HTTP Server, why when I typed "http;//localhost:8080/isqlplus", I got error of 'can not find server'?
Anyone, please, help me.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"But it seems I have to use iSQL*Plus in order to take the Exam"
As someone who has already taking the exam, I can say you do not need to use iSQL*Plus in order to take the Exam.
There is only one question regarding iSQL and it is really easy. Actually it is an answer more than a question.
Mark
 
Yingie Pitts
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for your reply Mark. I knew you because of the discussion following your post of passing 007 exam in July. Here is a late congratulation from me.
So how long did it take you to prepare the exam? I hope I can clear it in two months, given that I can steal some of my working time
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well Yingie, I took the exam right when I completed the 007 Oracle class. It wasn't from Oracle Univeristy, but from UCI, University of California Irvine. It was a ten week class, 4 hours each time. I also have a lot of SQL querying experience from work. So I am not sure how much time it takes to study? Sorry I can't help there.
Good Luck
Mark
 
Praveen Zala
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My inputs are - if you are using queries day in and day out - then I guess it is a matter of only getting to know some of the specific Oracle 9i Syntax and functions to be used in conjunction with your queries. At any rate - you can do it under 2 months if you can concentrate hard on it for atleast an hour a day. ( Assuming you have SQL Experience ! )
Regards,
Praveen
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic