CREATE TABLE CUSTOMER (
NAME VARCHAR2(20),
GENDER VARCHAR2(7),
ADDRESS VARCHAR2(100));
/
CREATE OR REPLACE PROCEDURE INSERTsong (
p_id mockdata.id%TYPE,
p_name mockdata.name%TYPE,
p_album mockdata.album%TYPE,
p_band mockdata.band%TYPE,
p_year mockdata.year%TYPE,
p_path mockdata.path%TYPE,
p_genre mockdata.genre%TYPE)
IS
BEGIN
INSERT INTO mockdata (id,name,album,band,YEAR,PATH,genre)
VALUES (p_id,p_name,p_album,p_band,p_year,p_path,p_genre);
COMMIT;
END;
/
CREATE OR REPLACE PROCEDURE DELETEsong (

p_name mockdata.name%TYPE)

IS
BEGIN
DELETE mockdata WHERE p_name = mockdata.name
COMMIT;
END;
/
CREATE OR REPLACE FUNCTION COUNT
RETURN NUMBER IS
   total NUMBER;
BEGIN
   SELECT COUNT(id) INTO total
   FROM mockdata;

   RETURN total;
END COUNT;
DROP FUNCTION COUNT;

/
exec INSERTsong(2000000,'nume2','nume3','nume3',1887,'gfd','nume3');

SELECT COUNT FROM dual;
SELECT * FROM mockdata WHERE id=0;
DELETE mockdata WHERE id=2000000;
SELECT * FROM mockdata WHERE name LIKE '%1%';
DELETE mockdata WHERE id=1167635;
/
CREATE OR REPLACE FUNCTION rec
RETURN NUMBER IS
   hourr VARCHAR(2);
BEGIN
   SELECT TO_CHAR(SYSDATE,'hH24') INTO hourr FROM DUAL;

   RETURN hourr;
END rec;

SELECT rec FROM dual;


/
CREATE OR REPLACE FUNCTION morning

RETURN VARCHAR2 IS
   stm VARCHAR2(1000);
   v NUMBER;
BEGIN
   SELECT TRUNC(DBMS_RANDOM.VALUE(1,10000))  INTO v FROM dual;
   SELECT CONCAT(CONCAT(name,' | '),genre) INTO stm FROM mockdata WHERE ROWNUM=1 AND (genre LIKE 'Techno' OR genre LIKE 'Pop' OR genre LIKE'Hard Rock');
   RETURN stm;
END morning;
/
DROP FUNCTION morning;
SELECT rec FROM dual;
SELECT morning FROM dual;

//
CREATE OR REPLACE FUNCTION evening

RETURN VARCHAR2 IS

   stm VARCHAR2(1000);
   v NUMBER;
BEGIN
   SELECT TRUNC(DBMS_RANDOM.VALUE(1,10000))  INTO v FROM dual;
   SELECT CONCAT(CONCAT(name,' | '),genre) INTO stm FROM mockdata WHERE ROWNUM= AND (genre LIKE 'Opera' OR genre LIKE 'Latin' OR genre LIKE'Jazz');
   RETURN stm;
END evening;

SELECT genre FROM mockdata;
SELECT morning FROM dual;
SELECT evening FROM mockdata;


//
SELECT morning FROM dual WHERE ROWNUM=1;

SELECT * FROM mockdata WHERE ROWNUM=1;
//
SELECT rec FROM dual;

SELECT genre FROM mockdata;
SELECT * FROM mockdata WHERE ROWNUM < 2;
///
CREATE INDEX namee
  ON  mockdata (UPPER(REVERSE(name)));



SELECT CONCAT(CONCAT(name,' | '),genre)  FROM mockdata WHERE rownum<10 AND (genre LIKE 'Techno' OR genre LIKE 'Pop' OR genre LIKE 'Hard Rock');