code test - " from book_order;--Step 5-select...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
--Step 1 - SELECT customer#, firstname, lastname, referred, S NVL2(referred), as "NOT REFERRED" R from book_customer; --Step 2 - SELECT TO_CHAR(sysdate, 'Day HH:MI:SS') S as now from DUAL; --Step 3 - select substr(isbn, 0, 1) || '-' || s substr(isbn, 3, 5) || '-' || s substr(isbn, 9, 3) s from books; --Step 4 - select order#, shipstreet, shipcity, shipstate, shipzip, s to_char(orderdate, 'Mon/dd/yyyy') as "Date Ordered"
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: " from book_order;--Step 5-select order#, shipdate, orderdate, (shipdate-orderdate) as "month between" s from book_order;--Step 6-select name, initcap(Name) s from publisher; Read more: I need help in how to write these and 10 other q. .. - JustAnswer http://www.justanswer.com/questions/341fr-i-need-help-in-how-to-write-these-and-10-other-queries-1#ixzz0vQIaKvvz...
View Full Document

Ask a homework question - tutors are online