Five additional queries that use single-row functions from each of the categories listed below. In addition to the query, explain what the query is meant to do as part of a SQL comment prior to the query:

1. Character Function.
2. Numeric Function.
3. DateTime Function.
4. Conversion Function.
5. NVL Function (you may need to remove data to make this work).--ques 1
   select custNo, custfirstname ||custlastname,custcity, custstate,custzip
   from customer
   order by custfirstname,custlastname;
   
   --ques 2
   select OrdNo,to_char(OrdDate, 'yyyy-mm-dd hh24:mi:ss') order_date , CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
        OrdState, OrdZip
     from ORDERS;
    
   --ques 3
   SELECT ProdNo, INITCAP(ProdName), ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice
   from product;
   --ques 4
   Select ordNo, CustNo,Orddate, OrdName
   from orders
   where EXTRACT(month FROM ORDDATE)=2;
   
   --ques 5
   Select ProdNo, ProdNo, ROUND(ProdPrice)
   from Product;
   --ques 6
   Select OrdNo, (qty*product.ProdPrice) as Total_Price
   from Order_Line, Product
   where Order_Line.PRODNO=Product.PRODNO;
   
   --ques 7
   Select * from
   customer
   where custfirstname like 'B%';
   
   --ques 8
   Select * from product
   where ProdPrice>10;
   
   

SophiaPretty

(5)

Status NEW Posted 24 Dec 2017 01:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer