Oracle Delete trigger create view export table structure

1. delete a trigger

 

Drop trigger tib_operationondata (name of the trigger );

 

2. Create a view

 

Create view olap_sqandnyerpdeployson
(Statdate, expiration, outwarehouseid, inwarehouseid, briefid, professionalid, specifyid, cashbudgetid, price, amount, isworn, jine, sqspecifyid, sqamount, sqprice, sqjine)
As
Select
To_char (P. createdate, 'yyyymmdd') as statdate,
P. guikou1_mentid as guikoudepid,
P. outwarehouseid,
P. inwarehouseid,
P. briefid
P. professionalid,
M. specifyid,
S. ID as cashbudgetid,
M. Price,
Sum (M. Amount) as amount,
M. isworn,
Sum (M. Price * M. Amount) as jine,
FM. specifyid as sqspecifyid,
Sum (FM. Amount) as sqamount,
FM. Price as sqprice,
Sum (FM. Price * FM. Amount) as sqjine
From
(Materialofnyerpdeploysonpaper m
Inner join
(Nyerpdeploysonpaper P
Inner join
(Budgetdetails B
Inner join cashbudget s
On B. cashbudgetid = S. ID
)
On P. budgetdetailsid = B. ID
)
On M. nyerpdeploysonpaperid = P. ID
Inner join materialofnyerpdeploypaper FM
On M. materialofnyerpdeployid = FM. ID
)
Where
(P. auditingtag = '4' or P. auditingtag = '2 ')
And S. islafe = 1
Group (
To_char (P. createdate, 'yyyymmdd '),
P. guikou1_mentid,
P. outwarehouseid,
P. inwarehouseid,
P. briefid,
P. professionalid,
M. specifyid,
M. materialofnyerpdeployid,
S. ID,
M. Price,
M. isworn,
FM. Price,
FM. specifyid)

 

3. Export the table structure

 

Exp test/123456 @ myoracle file = D:/test. dmp rows = N