혹시몰라서 저장해놓음 sql 작업 한것들

 select * 

from grocery;

create sequence shoppingbag_seq increment by 1 start with 1 ;

create sequence  gro_seq increment by 1 start with 1 ;

create sequence  order_seq increment by 1 start with 1 ;

create sequence order_seq increment by 1 start with 1 ;

create sequence seller_seq increment by 1 start with 1 ;

INSERT INTO grocery VALUES  ('g' || shoppingbag_seq.nextval  ,  '당근' , 3000 , 'a101');

select * 

from shoppingbag;

INSERT INTO shoppingbag VALUES( 's' || shoppingbag_seq.nextval , 'coral' , '3000' , '당근' , 'g2' );

DELETE shoppingbag WHERE grocery_cod = 'g2'

CASE WHEN P.point >= S.sum THEN '구매가능' WHEN P.point < S.sum THEN '잔액부족' ELSE '오류' "able"

SELECT CASE WHEN P.point >= S.sum THEN '구매가능' WHEN P.point < S.sum THEN '잔액부족' ELSE '오류' END 

FROM 

        (SELECT point  

        FROM member3 

        WHERE id = 'coral') P ,

        (SELECT sum(pr_price) sum 

        FROM shoppingbag

        WHERE id = 'coral') S 

        

        

        

UPDATE member3 SET point = member3.point  -  (SELECT sum(pr_price)                                                                                                 sum 

                                                               FROM shoppingbag

                                                          WHERE id = 'coral')  

                                                          WHERE id ='coral'

                                                          ;

                                                          

                                                          

                                                          

                                                          select * 

                                                          from member3;

                                                          

                                                          select * 

                                                          from shoppingbag;

        

        rollback;

select * 

from order3;

select * 

from shoppingbag ;

DELETE shoppingbag where id = 'coral';

select * 

from order3;

update order3 set order_status = 'd' where id = 'coral'

rollback;

commit;

select * 

from shoppingbag;

select * 

from grocery;

update order3 values (order_seq , )

SELECT shoppingbag.grocery_cod grocery_cod , grocery.g_name name , grocery.g_price  price 

FROM shoppingbag , grocery

WHERE shoppingbag.id = 'coral'

AND shoppingbag.grocery_cod = grocery.grocery_cod;

select * 

from shoppingbag;

select * 

FROM order3;

SELECT shoppingbag.grocery_cod pr_cod , grocery.g_name pr_name , grocery.g_price order_price  , shoppingbag.id id 

FROM shoppingbag , grocery

WHERE shoppingbag.id = 'coral'

AND shoppingbag.grocery_cod = grocery.grocery_cod;

insert into order3 values ( 'o' || order_seq.nextval , sysdate, 'n', 'coral' , 'g2' , '3000' , '당근' );