Advertisement
Guest User

Untitled

a guest
Dec 10th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.57 KB | None | 0 0
  1. CREATE OR REPLACE PROCEDURE example_insert (sTABLE IN VARCHAR2) IS
  2. BEGIN
  3.  
  4.   INSERT INTO STUDENTS
  5.   VALUES (seq_id.NEXTVAL, 'пример1', 2, 'пример1', 'пример1');
  6.  
  7. END example_insert;
  8.  
  9.  
  10. CREATE OR REPLACE PROCEDURE P_EXAMPLE_INSERT IS
  11.   nSYNC NUMBER(17);
  12. BEGIN
  13.  
  14.   p_students_insert(nSYNC_ID  => nSYNC,
  15.                     sNAME_    => 'example',
  16.                     nGROUP_   => 2,
  17.                     sNEW_COL  => 'example',
  18.                     sEXAMPLE_ => 'example',
  19.                     sEXAMPLE2_ => 'example');
  20.  
  21. END P_EXAMPLE_INSERT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement