Cara Membuat Table Di ORACLE SQL DEVELOPER

Published: 28 July 2022
on channel: Han's Entertainment

920

Hai..Selamat datang di youtube channel han's entertaiment..pada video ini kita akan belajar cara membuat table pada oracle sql developer

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE MAHASISWA (
NIM NUMBER(2) NOT NULL,
NAMA VARCHAR(20) NOT NULL,
CONSTRAINT MAHASISWA_PK PRIMARY KEY (NIM) ENABLE
);
-----------------------------------------------------------------------------------------------------------------------
ALTER TABLE MAHASISWA ADD (
ALAMAT VARCHAR(45) NOT NULL,
BERAT NUMBER(2) NOT NULL
);
-----------------------------------------------------------------------------------------------------------------------
DESC MAHASISWA;
-----------------------------------------------------------------------------------------------------------------------
ALTER TABLE MAHASISWA MODIFY BERAT VARCHAR(2);
-----------------------------------------------------------------------------------------------------------------------
ALTER TABLE MAHASISWA RENAME COLUMN BERAT TO UMUR;
---------------------------------------------------------------------------------------------------------------------------
ALTER TABLE MAHASISWA DROP COLUMN UMUR;
---------------------------------------------------------------------------------------------------------------------------
ALTER TABLE MAHASISWA RENAME TO STUDENT;
---------------------------------------------------------------------------------------------------------------------------
DESC STUDENT;
---------------------------------------------------------------------------------------------------------------------------
DROP TABLE STUDENT;
---------------------------------------------------------------------------------------------------------------------------

#sql #mysql #oraclesql #tutorial #tutorialdatabase #oracle #hansentertaiment #henryhanna #belajar #programmer #programming #createtabel #AddColumn #AlterTable #ModifyColumn
#RenameTable #RenameColumn #DropColumn #DropTable

On this page of the site you can watch the video online Cara Membuat Table Di ORACLE SQL DEVELOPER with a duration of hours minute second in good quality, which was uploaded by the user Han's Entertainment 28 July 2022, share the link with friends and acquaintances, this video has already been watched 920 times on youtube and it was liked by 7 viewers. Enjoy your viewing!