title: Oracle APEX simple crud database app
body: <p>I am very new to oracle pl/sql and APEX and not familiar yet to it.</p>
  
  <p>I want to make a simple <strong>CRUD</strong> project using the Oracle's <strong>Application Express</strong> : <a href="https://apex.oracle.com/en/" rel="nofollow noreferrer">https://apex.oracle.com/en/</a> , but unfortunately I could not find any example or documentation. I got some courses but the versions of apex differ and a lot of things have been changed so I am not able to implement what I need.</p>
  
  <p>I have created a simple new table just for practice in the following way:
  Sql Workshop -> Object Browser -> Create Table</p>
  
  <p>And I have a very simple table: <code>New_Table</code> with fields: <code>id (INTEGER), name(VARCHAR2)</code></p>
  
  <p>Now I want to make a simple crud website for this table, but cannot understand how the forms work.</p>
  
  <p>I created a database project: <code>App Builder -&gt; Database Applications -&gt; Create</code> and got a simple web project with a blank page.</p>
  
  <p><strong>Questions:</strong></p>
  
  <ol>
  <li><p>How can I create the form and bind it to the table?</p></li>
  <li><p>If I understand correctly, for editing a record, I should pass the id to the next page, how can I do it? or how to implement the edit page?</p></li>
  <li><p>How can I get the data from form fields, validate it and execute an sql query using that data?</p></li>
  </ol>
  
  <p>Thank you very much!</p>