1. Detyre kursi Oracle

CREATE TABLE documentation(
NAME varchar2(200),
VALUE varchar2(500),
QUERY varchar2(200),
INSERTDATE DATE
);


INSERT INTO DOCUMENTATION (NAME, VALUE, QUERY, INSERTDATE) 
VALUES('PLATFORM_NAME', (SELECT PLATFORM_NAME FROM V$DATABASE), 'SELECT PLATFORM_NAME FROM V$DATABASE', SYSDATE);

INSERT INTO DOCUMENTATION (NAME, VALUE, QUERY, INSERTDATE) 
VALUES('NAME', (SELECT NAME FROM V$CONTROLFILE), 'SELECT NAME FROM V$CONTROLFILE', SYSDATE);

INSERT INTO DOCUMENTATION (NAME, VALUE, QUERY, INSERTDATE) 
VALUES('TABLESPACE_NAME', (SELECT TABLESPACE_NAME FROM DBA_EXTENTS WHERE SEGMENT_NAME = 'DOCUMENTATION'), 'SELECT TABLESPACE_NAME FROM DBA_EXTENTS WHERE SEGMENT_NAME = DOCUMENTATION', SYSDATE);

INSERT INTO DOCUMENTATION (NAME, VALUE, QUERY, INSERTDATE) 
VALUES('INSTANCE_NUMBER', (SELECT INSTANCE_NUMBER FROM V$INSTANCE), 'SELECT INSTANCE_NUMBER FROM V$INSTANCE', SYSDATE);

INSERT INTO DOCUMENTATION (NAME, VALUE, QUERY, INSERTDATE) 
VALUES('NAME', (SELECT NAME FROM V$DATAFILE WHERE ROWNUM = 1), 'SELECT NAME FROM V$DATAFILE WHERE ROWNUM = 1', SYSDATE);

INSERT INTO DOCUMENTATION (NAME, VALUE, QUERY, INSERTDATE) 
VALUES('BACKGROUND', (SELECT COUNT(background) AS BACKGROUND_PROCESS_NR FROM V$PROCESS WHERE BACKGROUND = 1), 
       'SELECT COUNT(background) AS BACKGROUND_PROCESS_NR FROM V$PROCESS WHERE BACKGROUND = 1', SYSDATE);
       
INSERT INTO DOCUMENTATION (NAME, VALUE, QUERY, INSERTDATE) 
VALUES('MAX_SIZE', (SELECT SUM(MAX_SIZE)AS MAX_SIZE FROM V$SGA_DYNAMIC_COMPONENTS), 
       'SELECT SUM(MAX_SIZE)AS MAX_SIZE FROM V$SGA_DYNAMIC_COMPONENTS', SYSDATE);

COMMIT;