Home » SQL & PL/SQL » SQL & PL/SQL » transpose and insert the data (oracle 11g)
transpose and insert the data [message #651924] Fri, 27 May 2016 12:42 Go to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Hi all,

I have a table with the data like this:

NAME ID SUBJECT
TEST 123 A
TEST 123 B
TEST 123 C
TEST 123 D
TEST 123 E
TEST 123 F

And i want to insert the above data into another table like this:

NAME ID SUBJECT1 SUBJECT3 SUBJECT4 SUBJECT5 SUBJECT6
TEST 123 A C D E F

Is there anyway to do this?
Re: transpose and insert the data [message #651925 is a reply to message #651924] Fri, 27 May 2016 12:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is there anyway to do this?

search this forum for "PIVOT"

Pivot
https://community.oracle.com/message/9362005#9362005

Re: transpose and insert the data [message #651926 is a reply to message #651925] Fri, 27 May 2016 13:04 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
The information in the forum can be used to apply if the number of columns need to be pivot or transpose are static.
But my requirement is to transpose the unknown number of columns and want to insert into another table at the same time
Re: transpose and insert the data [message #651927 is a reply to message #651926] Fri, 27 May 2016 13:08 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
If you click on the link that BlackSwan provided and scroll down, below the section on static pivoting, there is a section on dynamic pivoting, with links that you can click on below that to examples where there is an unknown number of columns.
Re: transpose and insert the data [message #651928 is a reply to message #651927] Fri, 27 May 2016 14:36 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Examples given there are mainly used to pivot the rows into columns, but my requirement is to transpose the data as said in my example and i want to create the column names also dynamically. I am unable to find the suitable example in the links/examples given.

MY DATA IS LIME THIS:

NAME ID ROW
TEST 123 A
TEST 123 B
TEST 123 C
TEST 123 D
TEST1 123 E
TEST1 123 F
TEST1 123 G


AND THE OUTPUT IM LOOKING FOR IS LIKE THIS:

NAME ID ROW1 ROW2 ROW3 ROW4
TEST 123 A B C D
TEST1 123 E F G

[Updated on: Fri, 27 May 2016 14:51]

Report message to a moderator

Re: transpose and insert the data [message #651931 is a reply to message #651928] Fri, 27 May 2016 15:02 Go to previous messageGo to next message
Michel Cadot
Messages: 67923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I am unable to find the suitable example in the links/examples given.


Read again, there is nothing special in your case.

Michel Cadot wrote on Wed, 25 May 2016 20:35
Michel Cadot wrote on Wed, 25 May 2016 18:16
BlackSwan wrote on Wed, 25 May 2016 05:22
Welcome to this forum

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
...


Michel Cadot wrote on Wed, 25 May 2016 07:08

...Read and apply How to use [code] tags and make your code easier to read.




With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Re: transpose and insert the data [message #651932 is a reply to message #651928] Fri, 27 May 2016 15:33 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
SCOTT@orcl_12.1.0.2.0> SELECT * FROM your_table
  2  /

NAME          ID S
----- ---------- -
TEST         123 A
TEST         123 B
TEST         123 C
TEST1        123 D
TEST1        123 E
TEST1        123 F
TEST1        123 G

7 rows selected.

SCOTT@orcl_12.1.0.2.0> VARIABLE g_ref REFCURSOR
SCOTT@orcl_12.1.0.2.0> DECLARE
  2    v_size  NUMBER;
  3    v_col   NUMBER := 0;
  4    v_sql   VARCHAR2(32767);
  5  BEGIN
  6    SELECT GREATEST (MAX (LENGTH (subject)), LENGTH (COUNT (DISTINCT subject)) + 7)
  7    INTO   v_size
  8    FROM your_table;
  9    v_sql := 'SELECT name,id';
 10    FOR r IN (SELECT DISTINCT subject FROM your_table ORDER BY subject) LOOP
 11  	 v_col := v_col + 1;
 12  	 v_sql := v_sql||',CAST(MAX(DECODE(subject,'''||r.subject||''',subject)) AS VARCHAR2('
 13  	       ||v_size||')) "SUBJECT'||v_col||'"';
 14    END LOOP;
 15    v_sql := v_sql || ' FROM your_table GROUP BY name, id ORDER BY 1, 2, 3';
 16    OPEN :g_ref FOR v_sql;
 17  END;
 18  /

PL/SQL procedure successfully completed.

SCOTT@orcl_12.1.0.2.0> PRINT g_ref

NAME          ID SUBJECT1 SUBJECT2 SUBJECT3 SUBJECT4 SUBJECT5 SUBJECT6 SUBJECT7
----- ---------- -------- -------- -------- -------- -------- -------- --------
TEST         123 A        B        C
TEST1        123                            D        E        F        G

2 rows selected.



[edit: corrected calculation of v_size]

[Updated on: Fri, 27 May 2016 15:50]

Report message to a moderator

Re: transpose and insert the data [message #651933 is a reply to message #651932] Fri, 27 May 2016 16:10 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
create table example1 
(
name varchar2(10),
grade varchar2(10)
);

INSERT ALL
   INTO example1 (name, grade) VALUES ('ABC', 'A')
   INTO example1 (name, grade) VALUES ('ABC', 'B')
   INTO example1 (name, grade) VALUES ('ABC', 'C')
   INTO example1 (name, grade) VALUES ('ABC', 'D')
   INTO example1 (name, grade) VALUES ('DEF', 'E')
   INTO example1 (name, grade) VALUES ('DEF', 'F')
   INTO example1 (name, grade) VALUES ('DEF', 'G')
SELECT 1 FROM DUAL;

select * from example1;

NAME       GRADE    
---------- ----------
ABC        A          
ABC        B          
ABC        C          
ABC        D          
DEF        E          
DEF        F          
DEF        G          

 7 rows selected 
 

create table example2
(
name varchar2(10),
grade1  varchar2(10),
grade2  varchar2(10),
grade3  varchar2(10),
grade4  varchar2(10),
grade5  varchar2(10),
grade6  varchar2(10),
grade7  varchar2(10)
);

And finally the result to be inserted into example2 table and the result should looks like:

select * from example2;

NAME   GRADE1    GRADE2   GRADE3    GRADE4    GRADE5    GRAD6    GRAD7    
---------- ---------------------------------------------------------------------
ABC    A          B       C         D         null      null      null    
DEF    E          F       G         null      null      null      null 



[mod-edit: code tags added by bb]

[Updated on: Fri, 27 May 2016 16:12] by Moderator

Report message to a moderator

Re: transpose and insert the data [message #651934 is a reply to message #651933] Fri, 27 May 2016 16:25 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
SCOTT@orcl_12.1.0.2.0> select * from example1
  2  /

NAME       GRADE
---------- ----------
ABC        A
ABC        B
ABC        C
ABC        D
DEF        E
DEF        F
DEF        G

7 rows selected.

SCOTT@orcl_12.1.0.2.0> select * from example2
  2  /

no rows selected

SCOTT@orcl_12.1.0.2.0> INSERT INTO example2 (name, grade1, grade2, grade3, grade4, grade5, grade6, grade7)
  2  SELECT name,
  3  	    MAX (DECODE (dr, 1, grade)),
  4  	    MAX (DECODE (dr, 2, grade)),
  5  	    MAX (DECODE (dr, 3, grade)),
  6  	    MAX (DECODE (dr, 4, grade)),
  7  	    MAX (DECODE (dr, 5, grade)),
  8  	    MAX (DECODE (dr, 6, grade)),
  9  	    MAX (DECODE (dr, 7, grade))
 10  FROM   (SELECT name, grade, DENSE_RANK () OVER (PARTITION BY name ORDER BY grade) dr
 11  	     FROM   example1)
 12  GROUP  BY name
 13  /

2 rows created.

SCOTT@orcl_12.1.0.2.0> set null null
SCOTT@orcl_12.1.0.2.0> select * from example2
  2  /

NAME       GRADE1     GRADE2     GRADE3     GRADE4     GRADE5     GRADE6     GRADE7
---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
ABC        A          B          C          D          null       null       null
DEF        E          F          G          null       null       null       null

2 rows selected.

Re: transpose and insert the data [message #651935 is a reply to message #651934] Fri, 27 May 2016 17:05 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Thank you for your response.
but this is the sample data i have. lets say if i want to perform the same for unknown number of columns, i need to do something dynamic.
I am looking for a something in that way.
Re: transpose and insert the data [message #651936 is a reply to message #651935] Fri, 27 May 2016 22:32 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
If your example2 table already exists, then the number of columns is known and you just insert into it as in the last example that I posted. If you are creating your example2 table dynamically, based on the data in example1, then you can use the code below.

SCOTT@orcl_12.1.0.2.0> select * from example1
  2  /

NAME       GRADE
---------- ----------
ABC        A
ABC        B
ABC        C
ABC        D
DEF        E
DEF        F
DEF        G

7 rows selected.

SCOTT@orcl_12.1.0.2.0> select * from example2
  2  /
select * from example2
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SCOTT@orcl_12.1.0.2.0> DECLARE
  2    v_grades  NUMBER;
  3    v_sql	 VARCHAR2(32767);
  4  BEGIN
  5    SELECT COUNT (DISTINCT grade) INTO v_grades FROM example1;
  6    v_sql := 'CREATE TABLE example2 AS SELECT name';
  7    FOR i IN 1..v_grades LOOP
  8  	 v_sql := v_sql || ',MAX(DECODE(dr,' || i || ',grade)) grade' || i;
  9    END LOOP;
 10    v_sql := v_sql || ' FROM (SELECT name,grade,DENSE_RANK()OVER (PARTITION BY name ORDER BY grade) dr
 11  		FROM example1) GROUP BY name';
 12    EXECUTE IMMEDIATE v_sql;
 13  END;
 14  /

PL/SQL procedure successfully completed.

SCOTT@orcl_12.1.0.2.0> set null null
SCOTT@orcl_12.1.0.2.0> select * from example2 order by 1
  2  /

NAME       GRADE1     GRADE2     GRADE3     GRADE4     GRADE5     GRADE6     GRADE7
---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
ABC        A          B          C          D          null       null       null
DEF        E          F          G          null       null       null       null

2 rows selected.

Re: transpose and insert the data [message #652063 is a reply to message #651936] Tue, 31 May 2016 14:18 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Hi barbara,

Thank you so much.
I just converted the code you had given like below:

VARIABLE g_ref REFCURSOR
DECLARE
    v_size  NUMBER;
    v_col   NUMBER := 0;
    v_sql   VARCHAR2(32767);
    v_sql1   VARCHAR2(32767);
  BEGIN
    SELECT LENGTH (COUNT (DISTINCT grade)) + 1000 INTO v_size FROM example1;
--    DBMS_OUTPUT.PUT_LINE ('v_size IS:'||v_size);
    v_sql := ' SELECT name';
    v_sql1 := 'INSERT INTO EXAMPLE2 (name';
--    FOR r IN (SELECT grade FROM example1 order by grade) LOOP
     FOR r IN (SELECT name, grade, ROW_NUMBER () OVER (PARTITION BY name ORDER BY name) dr FROM example1) LOOP 
  	 v_col := v_col + 1;
     
     v_sql := v_sql||',CAST(MAX(DECODE(dr,'||v_col||',grade)) AS VARCHAR2('
  	       ||v_size||')) "grade'||v_col||'"'; 
           
     v_sql1 := v_sql1||', grade'||v_col||''; 
           
--    DBMS_OUTPUT.PUT_LINE ('v_sql IS:'||v_sql);    
--    DBMS_OUTPUT.PUT_LINE ('v_sql1 IS:'||v_sql1);
   
    END LOOP;
    v_sql := v_sql || ' FROM (SELECT name, grade, ROW_NUMBER () OVER (PARTITION BY name ORDER BY name) dr FROM example1) GROUP BY name';
    v_sql1 := v_sql1 || ')' || v_sql ;
    --DBMS_OUTPUT.PUT_LINE ('v_sql IS:'||v_sql); 
    DBMS_OUTPUT.PUT_LINE ('v_sql1 IS:'||v_sql1); 
    OPEN :g_ref FOR v_sql;
--    OPEN :g_ref FOR v_sql1;
  END;
  /


And is working fine.
But if i have huge data in example1 table, lets say around 1000 records in example1 table, then if i execute the above procedure, it returns with the following errors:

Error report:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 15
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause:
*Action:

So, i changed the v_sql and v_sql1 datatypes as CLOB.
But, still im getting the error like:

Error report:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 17
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause:
*Action:

Can you please help me on this..


[mod-edit: code tags added by bb]

[Updated on: Tue, 31 May 2016 14:30] by Moderator

Report message to a moderator

Re: transpose and insert the data [message #652064 is a reply to message #652063] Tue, 31 May 2016 14:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
you can lead some folks to knowledge, but you can't make them think.


Typing SET SERVEROUTPUT ON in SQL*Plus has the effect of invoking

DBMS_OUTPUT.ENABLE (buffer_size => NULL);
with no limit on the output.
Re: transpose and insert the data [message #652066 is a reply to message #652063] Tue, 31 May 2016 15:14 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
The error message is due to insufficient size for the output buffer or not setting the size, resulting in the default size. You can set it using serveroutput or dbms_output.enable. I have used serveroutput below. This is necessary only if you want to use dbms_output to display a lengthy string, such as the value of a long SQL statement. In the rest of your code, you have mismatched pieces of examples that were for different situations, where some of it does not apply and some of your unnecessary modifications indicate that you do not understand what it is doing. Now that it is clear that your example2 table already exists, the code below is all that you need to insert the data into it and display the SQL insert statement that it uses to do so.

-- test environment:
SCOTT@orcl_12.1.0.2.0> DESC example1
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 NAME                                                           VARCHAR2(10)
 GRADE                                                          VARCHAR2(10)

SCOTT@orcl_12.1.0.2.0> SELECT * FROM example1
  2  /

NAME       GRADE
---------- ----------
ABC        A
ABC        B
ABC        C
ABC        D
DEF        E
DEF        F
DEF        G

7 rows selected.

SCOTT@orcl_12.1.0.2.0> DESC example2
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 NAME                                                           VARCHAR2(10)
 GRADE1                                                         VARCHAR2(10)
 GRADE2                                                         VARCHAR2(10)
 GRADE3                                                         VARCHAR2(10)
 GRADE4                                                         VARCHAR2(10)
 GRADE5                                                         VARCHAR2(10)
 GRADE6                                                         VARCHAR2(10)
 GRADE7                                                         VARCHAR2(10)

SCOTT@orcl_12.1.0.2.0> SELECT * FROM example2
  2  /

no rows selected


-- insertion of data and display of sql insert statement used to insert it:
SCOTT@orcl_12.1.0.2.0> SET SERVEROUTPUT ON SIZE 1000000
SCOTT@orcl_12.1.0.2.0> DECLARE
  2    v_grades  NUMBER;
  3    v_sql1	 VARCHAR2(32767);
  4    v_sql2	 VARCHAR2(32767);
  5  BEGIN
  6    SELECT COUNT (DISTINCT grade) INTO v_grades FROM example1;
  7    v_sql1 := 'INSERT INTO example2(name';
  8    v_sql2 := 'SELECT name';
  9    FOR i IN 1..v_grades LOOP
 10  	 v_sql1 := v_sql1 || ',grade' || i;
 11  	 v_sql2 := v_sql2 || ',MAX(DECODE(dr,' || i || ',grade))';
 12    END LOOP;
 13    v_sql1 := v_sql1 || ') ';
 14    v_sql2 := v_sql1 || v_sql2
 15    || ' FROM (SELECT name,grade,DENSE_RANK()OVER (PARTITION BY name ORDER BY grade) dr FROM example1) GROUP BY name';
 16    DBMS_OUTPUT.PUT_LINE (v_sql2);
 17    EXECUTE IMMEDIATE v_sql2;
 18  END;
 19  /
INSERT INTO example2(name,grade1,grade2,grade3,grade4,grade5,grade6,grade7) SELECT
name,MAX(DECODE(dr,1,grade)),MAX(DECODE(dr,2,grade)),MAX(DECODE(dr,3,grade)),MAX(DECODE(dr,4,grade))
,MAX(DECODE(dr,5,grade)),MAX(DECODE(dr,6,grade)),MAX(DECODE(dr,7,grade)) FROM (SELECT
name,grade,DENSE_RANK()OVER (PARTITION BY name ORDER BY grade) dr FROM example1) GROUP BY name

PL/SQL procedure successfully completed.


-- results after insert:
SCOTT@orcl_12.1.0.2.0> SELECT * FROM example2
  2  /

NAME       GRADE1     GRADE2     GRADE3     GRADE4     GRADE5     GRADE6     GRADE7
---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
ABC        A          B          C          D          null       null       null
DEF        E          F          G          null       null       null       null

2 rows selected.

Re: transpose and insert the data [message #652067 is a reply to message #652066] Tue, 31 May 2016 15:43 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Thank you barbara,

But the same code is not working if the example1 table contains more records.
If i try to insert the data:

Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','A');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','B');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','C');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('ABC','D');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','E');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','F');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');
Insert into EXAMPLE1 (NAME,GRADE) values ('DEF','G');

After that executing the same procedure (even after disabling the DBMS_OUTPUT line), results with the following error:

Error report:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 14
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause:
*Action:

This is what i mentioned even in my earlier reply as well.
Note: I used ROW_NUMBER in the place of DENSE_RANK to take the duplicate values also.
And i am not using the distinct while selecting the grade in the select statement, so that i can get all the duplicate data to be inserted into example2 table

[Updated on: Tue, 31 May 2016 15:49]

Report message to a moderator

Re: transpose and insert the data [message #652068 is a reply to message #652067] Tue, 31 May 2016 16:21 Go to previous messageGo to next message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Please ignore my previous post..

I just changed small modifications and the final code looks like below, which can handle the duplicate values as well and can load into final table.
Thanks a lot for your nice support..


SET SERVEROUTPUT ON SIZE 1000000
DECLARE
v_grades NUMBER;
v_sql1 VARCHAR2(32767);
v_sql2 VARCHAR2(32767);
BEGIN

-- SELECT COUNT (grade) INTO v_grades FROM example3 group by name;
SELECT MAX(grade_ct) INTO v_grades FROM
(SELECT COUNT (grade) as grade_ct, name FROM example3 group by name);
v_sql1 := 'INSERT INTO example2(name';
v_sql2 := 'SELECT name';
FOR i IN 1..v_grades LOOP
v_sql1 := v_sql1 || ',grade' || i;
v_sql2 := v_sql2 || ',MAX(DECODE(dr,' || i || ',grade))';
END LOOP;
v_sql1 := v_sql1 || ') ';
v_sql2 := v_sql1 || v_sql2
|| ' FROM (SELECT name,grade,ROW_NUMBER()OVER (PARTITION BY name ORDER BY grade) dr FROM example3) GROUP BY name';
-- DBMS_OUTPUT.PUT_LINE (v_sql2);
EXECUTE IMMEDIATE v_sql2;
END;
/
Re: transpose and insert the data [message #652069 is a reply to message #652068] Tue, 31 May 2016 17:58 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
Your original data and requirements did not indicate duplicates to be listed as additional columns. Given the data that you provided, there would be 591 grade columns and the length of the SQL insert statement would be 20615, so I would change the v_sql1 and v_sql2 from VARCHAR2(32767) to CLOB, as you said you tried at one point. Your example2 table must already have 591 grade columns in order to insert that data. I can't imagine what you would then do with such duplicate columns of data. I am curious. What do you do with the data in the example2 table?


Re: transpose and insert the data [message #652145 is a reply to message #652069] Thu, 02 June 2016 13:43 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
How could you ever use such a table for a report. no one would ever be able to read or comprehend it. What is your real goal? or is this just a though exercise?
Re: transpose and insert the data [message #652146 is a reply to message #652145] Thu, 02 June 2016 13:49 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
see the following article

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4471013000346257238
Re: transpose and insert the data [message #652150 is a reply to message #652069] Thu, 02 June 2016 15:56 Go to previous message
tolupuluri
Messages: 21
Registered: May 2016
Junior Member
Hi Barbara,

This is the test/sample table that i asked.
But in actual environment, we have the data like:
NAME=UTILITY_METER
GRADE= METER_READINGS
and we have few other fields as well.
METER_READINGS would be same, but for different TIME_INTERVALS in our environment.

As the source data (METER_READINGS), will be provided in vertical format for each UTILITY_METER, we have to convert that into horizontal format.

so, to get the solution for that, i just created some example table, and i thought of enhancing the solution according to my environment.

And finally, i had modified the code according to my environment and is working great.

Once again thanks a lot Barbara. Hope this will clarify.

Previous Topic: percentages of data population
Next Topic: FIFO Algorithm to calculate Avg weighted value
Goto Forum:
  


Current Time: Sun Aug 01 18:57:45 CDT 2021