Depends on what you want to do. If you are staying in Waikiki you can walk to the beach, walk to the shops, walk to the restaurants and bars. If you want to see more of Oahu than just Honolulu, you could either take a bus (they have tour buses) or rent a bike.