title: I have a JSON table, how can I create a sql table with this information in PLSQL?
body: <p>I'm working with PLSQL and I have this JSON table (first variable),
  How can I insert this data into a sql table, i have already try this, but i have SQL statement ignored error:</p>
  <pre><code>CREATE TABLE Prueba_ins_json (
          userId number(3),
          id number(3),
          title VARCHAR2(200),
          body VARCHAR2(800)
      );
  DECLARE
    json_prueba VARCHAR(5000) := '[
                                {
                                  &quot;userId&quot;: 1,
                                  &quot;id&quot;: 1,
                                  &quot;title&quot;: &quot;sunt aut facere repellat provident occaecati excepturi optio reprehenderit&quot;,
                                  &quot;body&quot;: &quot;quia et suscipit\nsuscipit recusandae consequuntur expedita et cum\nreprehenderit molestiae ut ut quas totam\nnostrum rerum est autem sunt rem eveniet architecto&quot;
                                },
                                {
                                  &quot;userId&quot;: 1,
                                  &quot;id&quot;: 2,
                                  &quot;title&quot;: &quot;qui est esse&quot;,
                                  &quot;body&quot;: &quot;est rerum tempore vitae\nsequi sint nihil reprehenderit dolor beatae ea dolores neque\nfugiat blanditiis voluptate porro vel nihil molestiae ut reiciendis\nqui aperiam non debitis possimus qui neque nisi nulla&quot;
                                },
                                {
                                  &quot;userId&quot;: 1,
                                  &quot;id&quot;: 3,
                                  &quot;title&quot;: &quot;ea molestias quasi exercitationem repellat qui ipsa sit aut&quot;,
                                  &quot;body&quot;: &quot;et iusto sed quo iure\nvoluptatem occaecati omnis eligendi aut ad\nvoluptatem doloribus vel accusantium quis pariatur\nmolestiae porro eius odio et labore et velit aut&quot;
                                },
                                {
                                  &quot;userId&quot;: 1,
                                  &quot;id&quot;: 4,
                                  &quot;title&quot;: &quot;eum et est occaecati&quot;,
                                  &quot;body&quot;: &quot;ullam et saepe reiciendis voluptatem adipisci\nsit amet autem assumenda provident rerum culpa\nquis hic commodi nesciunt rem tenetur doloremque ipsam iure\nquis sunt voluptatem rerum illo velit&quot;
                                }
                                ]';
  BEGIN
  INSERT INTO Prueba_ins_json
    SELECT * FROM JSON_TABLE( json_prueba, '$[*]'
                                columns(
                                  userId, id, title, body
                                )
                              );
  
  END; 
  </code></pre>