DBMS

1. Create a table Stock with stockid number, stockdet xmltype. Insert values into the stock table as shown below. new zzzz 20.313 zacx corp ZCXM 28.875 zaffymat inc ZFFX 92.250 zysmergy inc ZYSZ 20.313 1. Display stock price whose value is greater than 50.50 using xpath. 2. Display only the attribute values of the Stock exchange. 3. Display the name of the stock whose name starts with z...". 4. Display the all the elements of the stock. 5. Display only the symbol and price values. 6. Change the price value of stock whose name is zysmergy