I have a career in mind, can majoring in nursing help me with this? -Working with kids with cancer?

Pediatric Oncology is the specialty for nursing. You would first need a BSN and work in a pediatric oncology unit for a few years before going back to get your Masters if you were considering being a Nurse Practitioner.