Advertisement
Arckios

Untitled

Dec 17th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.84 KB | None | 0 0
  1. --NON REPORTÉ
  2. INSERT INTO TRX--(IdTrx,FkIdReser,FkIdCli,FkCodTypTrx,FkNoCham,DateTrx,MontantTrx,Reporte,NoFact,DateFact,FKNOARRIVE)
  3. VALUES(SEQ_IdTrx_Trx.NEXTVAL,6,5,'02','0204',sysdate-1,50,0,SEQ_NoFact_Trx.NEXTVAL,NULL,8);
  4. INSERT INTO TRX--(IdTrx,FkIdReser,FkIdCli,FkCodTypTrx,FkNoCham,DateTrx,MontantTrx,Reporte,NoFact,DateFact,FKNOARRIVE)
  5. VALUES(SEQ_IdTrx_Trx.NEXTVAL,7,6,'06','0101',sysdate-1,25,0,SEQ_NoFact_Trx.NEXTVAL,NULL,9);
  6. INSERT INTO TRX--(IdTrx,FkIdReser,FkIdCli,FkCodTypTrx,FkNoCham,DateTrx,MontantTrx,Reporte,NoFact,DateFact,FKNOARRIVE)
  7. VALUES(SEQ_IdTrx_Trx.NEXTVAL,5,4,'07','0202',sysdate-1,15,0,SEQ_NoFact_Trx.NEXTVAL,NULL,6);
  8. INSERT INTO TRX--(IdTrx,FkIdReser,FkIdCli,FkCodTypTrx,FkNoCham,DateTrx,MontantTrx,Reporte,NoFact,DateFact,FKNOARRIVE)
  9. VALUES(SEQ_IdTrx_Trx.NEXTVAL,2,3,'03','0102',sysdate-1,5,0,SEQ_NoFact_Trx.NEXTVAL,NULL,2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement