Most voted "dml" questions

DML - Data Manipulation Language - Data Manipulation Language. It’s the commands that interact with the data within the tables. DML : INSERT, DELETE and UPDATE commands

• 2

  votes

  1

  answer

  2089

  views

  ALTER TABLE changing column name

  When using ALTER TABLE to modify the column name in a table, we need to define the data type again: ALTER TABLE tabela CHANGE COLUMN nome_antigo novo_nome tipo_dados; If the data type is not…

  sql dml

  asked 5 years, 5 months ago Sevila 129

• 0

  votes

  0

  answers

  31

  views

  Align populated values by columns using case when in mysql

  As I could align the values in this SQL query per column, are 2 possible questions for each question in a list of several users who answered the first and second question: question one? answer a…

  mysql sql dml

  asked 3 years ago Ivan Ferrer 12,096

• -1

  votes

  1

  answer

  46

  views

  Trigger to prevent repeated data on ORACLE

  Opa personal I am trying to create a Trigger to prevent the entry of repeated data in Oracle but am not succeeding. You cannot use Constraint Unique, because I will have repeated data, because it is…

  sql database oracle dml

  asked 2 years, 11 months ago EdgarHygino 7