Session 01

View All Public Scripts Login to Run Script

Script Name Session 01
Visibility Unlisted - anyone with the share link can access
Description order by clause first year by , based on first year remaning year data should follow
Contributor Siva
Created Thursday August 18, 2022

Statement 1

create table test1 
(report_id integer,entity_id varchar(10),tmc integer,fy integer)

Table created.

Statement 2

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES (458,'9106166',7522,2025)

1 row(s) inserted.

Statement 3

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES (458,'9106166',7303,2024)

1 row(s) inserted.

Statement 4

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES (458,'9106166',7125,2023)

1 row(s) inserted.

Statement 5

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'9106166',6951,2022)

1 row(s) inserted.

Statement 6

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'9106166',6951,2021)

1 row(s) inserted.

Statement 7

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'8764180',6813,2025)

1 row(s) inserted.

Statement 8

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'8764180',6573,2024)

1 row(s) inserted.

Statement 9

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'8764180',6386,2023)

1 row(s) inserted.

Statement 10

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'8764180',5910,2022)

1 row(s) inserted.

Statement 11

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'8764180',5684,2021)

1 row(s) inserted.

Statement 12

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'0594502',7257,2025)

1 row(s) inserted.

Statement 13

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'0594502',7041,2024)

1 row(s) inserted.

Statement 14

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'0594502',6832,2023)

1 row(s) inserted.

Statement 15

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'0594502',6800,2022)

1 row(s) inserted.

Statement 16

INSERT INTO test1 (report_id,entity_id,tmc,fy) VALUES	 (458,'0594502',6769,2021)

1 row(s) inserted.

Statement 17

select * from test1


REPORT_ID ENTITY_ID TMC FY
458 9106166 7522 2025
458 9106166 7303 2024
458 9106166 7125 2023
458 9106166 6951 2022
458 9106166 6951 2021
458 8764180 6813 2025
458 8764180 6573 2024
458 8764180 6386 2023
458 8764180 5910 2022
458 8764180 5684 2021
458 0594502 7257 2025
458 0594502 7041 2024
458 0594502 6832 2023
458 0594502 6800 2022
458 0594502 6769 2021

15 rows selected.

REPORT_ID	ENTITY_ID	TMC	FY
458	9106166	7522	2025
458	9106166	7303	2024
458	9106166	7125	2023
458	9106166	6951	2022
458	9106166	6951	2021
458	8764180	6813	2025
458	8764180	6573	2024
458	8764180	6386	2023
458	8764180	5910	2022
458	8764180	5684	2021
458	0594502	7257	2025
458	0594502	7041	2024
458	0594502	6832	2023
458	0594502	6800	2022
458	0594502	6769	2021

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database