lesphomework

this is a crazy site for crazy people

Tuesday

section 1 lesson 1

1.select concat(concat( 'Oracle',' Internet'),' Academy')
from dual


2.select substr ('Oracle Internet Academy',13,3) as "The Net"
from dual

3.SELECT LENGTH ('Oracle Internet Academy')
from DUAL

4.SELECT INSTR('Oracle Internet Academy', 'I')
from DUAL

5.SELECT lpad('Oracl',9,'*')rpad('e',5,'*')rpad('Internet',12,'*')rpad('Academy',12,'*')
from DUAl

6.SELECT 'Oracle'Lpad('Internet',11,'$')Lpad('Academy',10,'$')
from DUAl

7.select replace('Oracle Internet Academy','Internet','2004-2005')as "The best Class"
from dual

8.SELECT order_date,LPAD(order_total,7,'$') AS"TOTAL"
FROM F_ORDERS

9.SELECT CONCAT(FIRST_NAME, LAST_NAME)'_'ADDRESS ' 'CITY' 'STATE' 'ZIP
FROM F_CUSTOMERS
WHERE ID=456

0 Comments:

Post a Comment

<< Home