Skip to main content

PL/SQL Working with Columns


Drop & Modify Constraints

alter table table_name drop constraint PK_XXX_XXX_ID;
alter table table_name modify constraint FK_XXX_XXX_XXX_ID enable;
alter table table_name modify constraint FK_XXX_XXX_YYY_ID enable;
alter table table_name modify constraint FK_XXX_XXX_ZZZ_ID enable;
--validation disabled
alter table table_name modify constraint CHK_XXX_XXX_TTT_NAME enable novalidate;

Add Constraints

ALTER TABLE table_name
add CONSTRAINT FK_XXX_XXX_XXX_ID
   FOREIGN KEY (column_name)
   REFERENCES reference_table (ID);

Rename Table

alter table table_name
rename to new_table_name;


Rename Columns

alter table table_name rename column column_name_x to new_column_name_x;
alter table table_name rename column column_name_y to new_column_name_y;
alter table table_name rename column column_name_z to new_column_name_z;

Add Columns

alter table
   table_name
add
   (
    USER_ID NUMBER(18,0) DEFAULT 1 NOT NULL ENABLE,
    ENTRY_DATE DATE DEFAULT sysdate NOT NULL ENABLE,
    UPDATE_USER_ID NUMBER(18,0),
    UPDATE_DATE DATE
   );

Drop Columns

alter table table_name drop column column_name;

Modify Columns

alter table table_name modify
(
   PHONE     VARCHAR2(20 BYTE),
   MOBILE_PHONE  VARCHAR2(20 BYTE),
   E_MAIL      VARCHAR2(40 BYTE),
   CITY VARCHAR2(30 BYTE),
   START_DATE DATE NULL
);

Modify Columns to Not Null

alter table  table_name
modify
(
   column_name               VARCHAR2(25 BYTE) default null null
);

Add Comment to Columns
comment on column table_name.column_name is '1-One, 2-Two, 3-Three, 4-Four';


Create Table with standart Columns
CREATE TABLE XYZ_KULLANIM_TURLERI
(
    ID                 NUMBER(18,0) NOT NULL ENABLE,
    ADI                VARCHAR2(50 BYTE) NOT NULL ENABLE,
    CTV_ID             NUMBER(18,0),
    KAYIT_KULLANICI_ID NUMBER(18,0) NOT NULL ENABLE,
    KAYIT_TARIHI DATE DEFAULT sysdate NOT NULL ENABLE,
    GUNCELLEME_KULLANICI_ID NUMBER(18,0),
    GUNCELLEME_TARIHI DATE,
    CONSTRAINT PK_XYZ_KULLANIM_TURLERI_ID PRIMARY KEY (ID),
    CONSTRAINT FK_XYZ_KULL_TUR_GNC_KULL_ID FOREIGN KEY (GUNCELLEME_KULLANICI_ID) REFERENCES XYZ_KULLANICI_BILGILERI (ID) ENABLE,
    CONSTRAINT FK_XYZ_KULL_TUR_KYT_KULL_ID FOREIGN KEY (KAYIT_KULLANICI_ID) REFERENCES XYZ_KULLANICI_BILGILERI (ID) ENABLE
);




Comments

Popular posts from this blog

How to fix Umbraco v9 "Boot Failed : Umbraco failed to boot, if you are the owner of the website please see the log file for more details." error

If you have started working with Umbraco v9 and done your first Azure deployment to one of your testing environments, there is a possibility that you might see the following "Boot Failed" error. Error: Checking the logs In order to understand the problem, you should check the Umbarco log file.  The default location for this file is umbraco/Logs and this file contains the Machine name, along with the date information. You can reach this file via Azure's Kudu Service  or alternatively, you can get download your Azure App Service's publish profile and connect your App Service via an FTP application, i.e. FileZilla. See the FileZilla screen below; Once you get your log file, you can download it to your local machine and open it with a text editor, i.e. Notepad++. When you open it, you will see all logs, including the error message. Please be aware, as most things with Umbraco, logging is also customizable, so you can either use the default Umbraco logging which is Micros

How to use JQuery Ajax Methods for Async ASP.NET MVC Action Methods

Making repeatedly calls to async methods can be a nightmare. In this case, it makes sense to use 2 ajax methods, instead of one. Here is a simple solution to overcome this problem. See that  ajaxcalls   is emptied after the success response for the first ajax call and then the second ajax method is used to make one single call to the async action method. Hope it helps. View: @section Scripts{     < script type ="text/javascript">         var smartDebitObject = new Object();         smartDebitObject.MembershipNumber = $( "#MembershipNumber" ).val();         smartDebitObject.ProfileId = $( "#ProfileId" ).val();         smartDebitObject.FirstName = $( "#FirstName" ).val();         smartDebitObject.LastName = $( "#LastName" ).val();         smartDebitObject.AddressLine1 = $( "#AddressLine1" ).val();         smartDebitObject.Postcode = $( "#Postcode" ).val();         smartDebitObject

How to fix Umbraco CMS Build Error NU1104: Unable to find project '..\Umbraco-CMS\tools\Umbraco.Core\Umbraco.Core.csproj'.

Yesterday during an online meeting , I was talking about how to contribute to Umbraco CMS . As part of this talk, in order to set up my local Umbraco CMS project ,  I cloned the latest Umbraco.CMS code to my local machine, but when I built it I saw the following error: Error NU1104 Unable to find project ' D : \git \repos \Umbraco -CMS \tools \Umbraco .Core \Umbraco .Core .csproj ' . Check that the project reference is valid and that the project file exists . Umbraco .JsonSchema D : \git \repos \Umbraco -CMS \tools \Umbraco .JsonSchema \Umbraco .JsonSchema .csproj I was surprised to see this error as I did the exact same thing a couple of days ago and saw no problems.  After trying a few things, I checked the Umbraco.JsonSchema project's project references and realised that Umbraco.Core project reference was broken.  After removing Umbraco.Core from the Umbraco.JsonSchema and adding it again fixed the problem and I could then do my local database setup as normal.