Oracle Interview Question

Small questions in programming and queries. Write a program to parse XML string. Write an sql query, some reg ex questions.