[Hint] DEFAULT in Inserts and Updates!

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Wed, 20 Oct 2004 8:46 am

Look at that interesting: the keyword DEFAULT can be used to designate the default value of the field in inserts and updates:
Code: Select all
INSERT INTO tabela VALUES (1, 'OWNER', DEFAULT, NULL);

UPDATE tabela SET coluna = DEFAULT;
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


Return to SQL

Who is online

Users browsing this forum: No registered users and 1 guest



cron