-- Create a table using Create AS
CREATE TABLE HR.EMPLOYEE_backup
AS SELECT * FROM HR.EMPLOYEE;
-- Add a column
ALTER TABLE HR.EMPLOYEE
ADD
(
givenName NVARCHAR2(50) ,
address NVARCHAR2(100) NOT NULL,
age number
);
-- Modify data type, add (NOT NULL or NULL)
ALTER TABLE HR.EMPLOYEE
MODIFY
(
givenName varchar2(100) NOT NULL,
address varchar2(20) NULL
);
-- Modify column name
ALTER TABLE HR.EMPLOYEE
rename column address to address2;
-- Drop a column
ALTER TABLE META.SYNCGRP
DROP
(
givenName
);
Brad Chen's Developer Blog Azure Database Data science Machine Learning Cloud
訂閱:
張貼留言 (Atom)
SQL Server Database Mirroring 資料庫鏡像
SQL Server Database Mirroring 資料庫鏡像
-
1.安裝了Oracle Client,就可以用Oracle Net Manager工具來設定TNS連線設定(Tnsnames.ora) Oracle Client 18.3 Installation 安裝Oracle Client 18.3 2.啟動Oracle Ne...
-
1.下載 Oracle Database 18c (18.3) https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-windows-180000-5066774.ht...
-
ASP.NET MVC Web App啟用SSL (Https連線) 1.在Web專案屬性 (1)將SSL已啟用改為True (2)複製或記下SSL URL路徑 2.Web專案屬性視窗,將專案URL改成上一個步驟複製的SSL URL路徑 3.在需要使用Https的Contro...
沒有留言:
張貼留言