TERMIUM Plus®
The Government of Canada’s terminology and linguistic data bank.
SQL INTERMEDIAIRE [17 records]
Record 1 - internal organization data 2002-10-11
Record 1, English
Record 1, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 1, Main entry term, English
- table operations for union
1, record 1, English, table%20operations%20for%20union
correct
Record 1, Abbreviations, English
Record 1, Synonyms, English
Record 1, Textual support, English
Record number: 1, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 1, English, - table%20operations%20for%20union
Record 1, French
Record 1, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 1, Main entry term, French
- opération de tables d'union
1, record 1, French, op%C3%A9ration%20de%20tables%20d%27union
correct, feminine noun
Record 1, Abbreviations, French
Record 1, Synonyms, French
Record 1, Textual support, French
Record number: 1, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 1, French, - op%C3%A9ration%20de%20tables%20d%27union
Record number: 1, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 1, French, - op%C3%A9ration%20de%20tables%20d%27union
Record 1, Spanish
Record 1, Textual support, Spanish
Record 2 - internal organization data 2002-10-11
Record 2, English
Record 2, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 2, Main entry term, English
- row value expression
1, record 2, English, row%20value%20expression
correct
Record 2, Abbreviations, English
Record 2, Synonyms, English
Record 2, Textual support, English
Record number: 2, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 2, English, - row%20value%20expression
Record 2, French
Record 2, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 2, Main entry term, French
- expression de valeur de rangée
1, record 2, French, expression%20de%20valeur%20de%20rang%C3%A9e
correct, feminine noun
Record 2, Abbreviations, French
Record 2, Synonyms, French
Record 2, Textual support, French
Record number: 2, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 2, French, - expression%20de%20valeur%20de%20rang%C3%A9e
Record number: 2, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 2, French, - expression%20de%20valeur%20de%20rang%C3%A9e
Record 2, Spanish
Record 2, Textual support, Spanish
Record 3 - internal organization data 2002-10-11
Record 3, English
Record 3, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 3, Main entry term, English
- cascade delete
1, record 3, English, cascade%20delete
correct
Record 3, Abbreviations, English
Record 3, Synonyms, English
Record 3, Textual support, English
Record number: 3, Textual support number: 1 CONT
Intermediate SQL adds provisions for schema manipulation, dynamic SQL, diagnostics management, long identifiers, multiple module support, cascade delete for referential integrity, multiple schemas per authorization identifier, DATE and TIME data types, domains, variable length character strings, support for national character sets, and substantial enhancements for data manipulation. 1, record 3, English, - cascade%20delete
Record 3, French
Record 3, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 3, Main entry term, French
- suppression de cascade
1, record 3, French, suppression%20de%20cascade
correct, feminine noun
Record 3, Abbreviations, French
Record 3, Synonyms, French
Record 3, Textual support, French
Record number: 3, Textual support number: 1 CONT
Le SQL intermédiaire ajoute les éléments suivants : dispositions sur la manipulation de schéma, SQL dynamique, gestion de diagnostics, identificateurs longs, soutien de modules multiples, suppression de cascade de l'intégrité référentielle, schémas multiples d’identificateur d’autorisation, types de données DATE et TIME, domaines, chaînes de caractères de longueur variable, soutien de jeux de caractères nationaux et améliorations importantes de manipulation de données. 1, record 3, French, - suppression%20de%20cascade
Record number: 3, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 3, French, - suppression%20de%20cascade
Record 3, Spanish
Record 3, Textual support, Spanish
Record 4 - internal organization data 2002-10-11
Record 4, English
Record 4, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 4, Main entry term, English
- multiple module support
1, record 4, English, multiple%20module%20support
correct
Record 4, Abbreviations, English
Record 4, Synonyms, English
Record 4, Textual support, English
Record number: 4, Textual support number: 1 CONT
Intermediate SQL adds provisions for schema manipulation, dynamic SQL, diagnostics management, long identifiers, multiple module support, cascade delete for referential integrity, multiple schemas per authorization identifier, DATE and TIME data types, domains, variable length character strings, support for national character sets, and substantial enhancements for data manipulation. 1, record 4, English, - multiple%20module%20support
Record 4, French
Record 4, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 4, Main entry term, French
- soutien de modules multiples
1, record 4, French, soutien%20de%20modules%20multiples
correct, masculine noun
Record 4, Abbreviations, French
Record 4, Synonyms, French
Record 4, Textual support, French
Record number: 4, Textual support number: 1 CONT
Le SQL intermédiaire ajoute les éléments suivants : dispositions sur la manipulation de schéma, SQL dynamique, gestion de diagnostics, identificateurs longs, soutien de modules multiples, suppression de cascade de l'intégrité référentielle, schémas multiples d’identificateur d’autorisation, types de données DATE et TIME, domaines, chaînes de caractères de longueur variable, soutien de jeux de caractères nationaux et améliorations importantes de manipulation de données. 1, record 4, French, - soutien%20de%20modules%20multiples
Record number: 4, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 4, French, - soutien%20de%20modules%20multiples
Record 4, Spanish
Record 4, Textual support, Spanish
Record 5 - internal organization data 2002-10-11
Record 5, English
Record 5, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 5, Main entry term, English
- national character set
1, record 5, English, national%20character%20set
correct
Record 5, Abbreviations, English
Record 5, Synonyms, English
Record 5, Textual support, English
Record number: 5, Textual support number: 1 CONT
Intermediate SQL adds provisions for schema manipulation, dynamic SQL, diagnostics management, long identifiers, multiple module support, cascade delete for referential integrity, multiple schemas per authorization identifier, DATE and TIME data types, domains, variable length character strings, support for national character sets, and substantial enhancements for data manipulation. 1, record 5, English, - national%20character%20set
Record 5, French
Record 5, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 5, Main entry term, French
- jeu de caractères national
1, record 5, French, jeu%20de%20caract%C3%A8res%20national
correct, masculine noun
Record 5, Abbreviations, French
Record 5, Synonyms, French
Record 5, Textual support, French
Record number: 5, Textual support number: 1 CONT
Le SQL intermédiaire ajoute les éléments suivants : dispositions sur la manipulation de schéma, SQL dynamique, gestion de diagnostics, identificateurs longs, soutien de modules multiples, suppression de cascade de l'intégrité référentielle, schémas multiples d’identificateur d’autorisation, types de données DATE et TIME, domaines, chaînes de caractères de longueur variable, soutien de jeux de caractères nationaux et améliorations importantes de manipulation de données. 1, record 5, French, - jeu%20de%20caract%C3%A8res%20national
Record number: 5, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 5, French, - jeu%20de%20caract%C3%A8res%20national
Record 5, Spanish
Record 5, Textual support, Spanish
Record 6 - internal organization data 2002-10-11
Record 6, English
Record 6, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 6, Main entry term, English
- complement
1, record 6, English, complement
correct
Record 6, Abbreviations, English
Record 6, Synonyms, English
Record 6, Textual support, English
Record number: 6, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 6, English, - complement
Record 6, French
Record 6, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 6, Main entry term, French
- complément
1, record 6, French, compl%C3%A9ment
correct, masculine noun
Record 6, Abbreviations, French
Record 6, Synonyms, French
Record 6, Textual support, French
Record number: 6, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 6, French, - compl%C3%A9ment
Record number: 6, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 6, French, - compl%C3%A9ment
Record 6, Spanish
Record 6, Textual support, Spanish
Record 7 - internal organization data 2002-10-11
Record 7, English
Record 7, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 7, Main entry term, English
- dynamic SQL
1, record 7, English, dynamic%20SQL
correct
Record 7, Abbreviations, English
Record 7, Synonyms, English
Record 7, Textual support, English
Record number: 7, Textual support number: 1 CONT
Intermediate SQL adds provisions for schema manipulation, dynamic SQL, diagnostics management, long identifiers, multiple module support, cascade delete for referential integrity, multiple schemas per authorization identifier, DATE and TIME data types, domains, variable length character strings, support for national character sets, and substantial enhancements for data manipulation. 1, record 7, English, - dynamic%20SQL
Record 7, French
Record 7, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 7, Main entry term, French
- SQL dynamique
1, record 7, French, SQL%20dynamique
correct, masculine noun
Record 7, Abbreviations, French
Record 7, Synonyms, French
Record 7, Textual support, French
Record number: 7, Textual support number: 1 CONT
Le SQL intermédiaire ajoute les éléments suivants : dispositions sur la manipulation de schéma, SQL dynamique, gestion de diagnostics, identificateurs longs, soutien de modules multiples, suppression de cascade de l'intégrité référentielle, schémas multiples d’identificateur d’autorisation, types de données DATE et TIME, domaines, chaînes de caractères de longueur variable, soutien de jeux de caractères nationaux et améliorations importantes de manipulation de données. 1, record 7, French, - SQL%20dynamique
Record number: 7, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 7, French, - SQL%20dynamique
Record 7, Spanish
Record 7, Textual support, Spanish
Record 8 - internal organization data 2002-10-11
Record 8, English
Record 8, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 8, Main entry term, English
- long identifier
1, record 8, English, long%20identifier
correct
Record 8, Abbreviations, English
Record 8, Synonyms, English
Record 8, Textual support, English
Record number: 8, Textual support number: 1 CONT
Intermediate SQL adds provisions for schema manipulation, dynamic SQL, diagnostics management, long identifiers, multiple module support, cascade delete for referential integrity, multiple schemas per authorization identifier, DATE and TIME data types, domains, variable length character strings, support for national character sets, and substantial enhancements for data manipulation. 1, record 8, English, - long%20identifier
Record 8, French
Record 8, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 8, Main entry term, French
- identificateur long
1, record 8, French, identificateur%20long
correct, masculine noun
Record 8, Abbreviations, French
Record 8, Synonyms, French
Record 8, Textual support, French
Record number: 8, Textual support number: 1 CONT
Le SQL intermédiaire ajoute les éléments suivants : dispositions sur la manipulation de schéma, SQL dynamique, gestion de diagnostics, identificateurs longs, soutien de modules multiples, suppression de cascade de l'intégrité référentielle, schémas multiples d’identificateur d’autorisation, types de données DATE et TIME, domaines, chaînes de caractères de longueur variable, soutien de jeux de caractères nationaux et améliorations importantes de manipulation de données. 1, record 8, French, - identificateur%20long
Record number: 8, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 8, French, - identificateur%20long
Record 8, Spanish
Record 8, Textual support, Spanish
Record 9 - internal organization data 2002-10-11
Record 9, English
Record 9, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 9, Main entry term, English
- union join
1, record 9, English, union%20join
correct
Record 9, Abbreviations, English
Record 9, Synonyms, English
Record 9, Textual support, English
Record number: 9, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 9, English, - union%20join
Record 9, French
Record 9, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 9, Main entry term, French
- jointure d'union
1, record 9, French, jointure%20d%27union
correct, feminine noun
Record 9, Abbreviations, French
Record 9, Synonyms, French
Record 9, Textual support, French
Record number: 9, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 9, French, - jointure%20d%27union
Record number: 9, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 9, French, - jointure%20d%27union
Record 9, Spanish
Record 9, Textual support, Spanish
Record 10 - internal organization data 2002-10-11
Record 10, English
Record 10, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 10, Main entry term, English
- subquery in value expressions
1, record 10, English, subquery%20in%20value%20expressions
correct
Record 10, Abbreviations, English
Record 10, Synonyms, English
Record 10, Textual support, English
Record number: 10, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 10, English, - subquery%20in%20value%20expressions
Record 10, French
Record 10, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 10, Main entry term, French
- sous-interrogation dans des expressions de valeur
1, record 10, French, sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
correct, feminine noun
Record 10, Abbreviations, French
Record 10, Synonyms, French
Record 10, Textual support, French
Record number: 10, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 10, French, - sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
Record number: 10, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 10, French, - sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
Record 10, Spanish
Record 10, Textual support, Spanish
Record 11 - internal organization data 2002-10-11
Record 11, English
Record 11, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 11, Main entry term, English
- entry SQL
1, record 11, English, entry%20SQL
correct
Record 11, Abbreviations, English
Record 11, Synonyms, English
Record 11, Textual support, English
Record number: 11, Textual support number: 1 CONT
SQL92 is specified in three levels: Entry SQL, Intermediate SQL, and Full SQL. 1, record 11, English, - entry%20SQL
Record 11, French
Record 11, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 11, Main entry term, French
- SQL de base
1, record 11, French, SQL%20de%20base
correct, masculine noun
Record 11, Abbreviations, French
Record 11, Synonyms, French
Record 11, Textual support, French
Record number: 11, Textual support number: 1 CONT
La norme SQL92 inclut des spécifications de trois niveaux :SQL de base, SQL intermédiaire, et SQL intégral. 1, record 11, French, - SQL%20de%20base
Record number: 11, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 11, French, - SQL%20de%20base
Record 11, Spanish
Record 11, Textual support, Spanish
Record 12 - internal organization data 2002-10-11
Record 12, English
Record 12, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 12, Main entry term, English
- string operation
1, record 12, English, string%20operation
correct
Record 12, Abbreviations, English
Record 12, Synonyms, English
Record 12, Textual support, English
Record number: 12, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 12, English, - string%20operation
Record 12, French
Record 12, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 12, Main entry term, French
- opération de chaîne
1, record 12, French, op%C3%A9ration%20de%20cha%C3%AEne
correct, feminine noun
Record 12, Abbreviations, French
Record 12, Synonyms, French
Record 12, Textual support, French
Record number: 12, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 12, French, - op%C3%A9ration%20de%20cha%C3%AEne
Record number: 12, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 12, French, - op%C3%A9ration%20de%20cha%C3%AEne
Record 12, Spanish
Record 12, Textual support, Spanish
Record 13 - internal organization data 2002-10-11
Record 13, English
Record 13, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 13, Main entry term, English
- authorization identifier
1, record 13, English, authorization%20identifier
correct
Record 13, Abbreviations, English
Record 13, Synonyms, English
Record 13, Textual support, English
Record number: 13, Textual support number: 1 CONT
Intermediate SQL adds provisions for schema manipulation, dynamic SQL, diagnostics management, long identifiers, multiple module support, cascade delete for referential integrity, multiple schemas per authorization identifier, DATE and TIME data types, domains, variable length character strings, support for national character sets, and substantial enhancements for data manipulation. 1, record 13, English, - authorization%20identifier
Record 13, French
Record 13, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 13, Main entry term, French
- identificateur d'autorisation
1, record 13, French, identificateur%20d%27autorisation
correct, masculine noun
Record 13, Abbreviations, French
Record 13, Synonyms, French
Record 13, Textual support, French
Record number: 13, Textual support number: 1 CONT
Le SQL intermédiaire ajoute les éléments suivants : dispositions sur la manipulation de schéma, SQL dynamique, gestion de diagnostics, identificateurs longs, soutien de modules multiples, suppression de cascade de l'intégrité référentielle, schémas multiples d’identificateur d’autorisation, types de données DATE et TIME, domaines, chaînes de caractères de longueur variable, soutien de jeux de caractères nationaux et améliorations importantes de manipulation de données. 1, record 13, French, - identificateur%20d%27autorisation
Record number: 13, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 13, French, - identificateur%20d%27autorisation
Record 13, Spanish
Record 13, Textual support, Spanish
Record 14 - internal organization data 2002-10-11
Record 14, English
Record 14, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 14, Main entry term, English
- outer join
1, record 14, English, outer%20join
correct
Record 14, Abbreviations, English
Record 14, Synonyms, English
Record 14, Textual support, English
Record number: 14, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 14, English, - outer%20join
Record 14, French
Record 14, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 14, Main entry term, French
- jointure externe
1, record 14, French, jointure%20externe
correct, feminine noun
Record 14, Abbreviations, French
Record 14, Synonyms, French
Record 14, Textual support, French
Record number: 14, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 14, French, - jointure%20externe
Record number: 14, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 14, French, - jointure%20externe
Record 14, Spanish
Record 14, Textual support, Spanish
Record 15 - internal organization data 2002-10-11
Record 15, English
Record 15, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 15, Main entry term, English
- intermediate SQL
1, record 15, English, intermediate%20SQL
correct
Record 15, Abbreviations, English
Record 15, Synonyms, English
Record 15, Textual support, English
Record number: 15, Textual support number: 1 CONT
SQL92 is specified in three levels: Entry SQL, Intermediate SQL, and Full SQL. 1, record 15, English, - intermediate%20SQL
Record 15, French
Record 15, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 15, Main entry term, French
- SQL intermédiaire
1, record 15, French, SQL%20interm%C3%A9diaire
correct, masculine noun
Record 15, Abbreviations, French
Record 15, Synonyms, French
Record 15, Textual support, French
Record number: 15, Textual support number: 1 CONT
La norme SQL92 inclut des spécifications de trois niveaux :SQL de base, SQL intermédiaire, et SQL intégral. 1, record 15, French, - SQL%20interm%C3%A9diaire
Record number: 15, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 15, French, - SQL%20interm%C3%A9diaire
Record 15, Spanish
Record 15, Textual support, Spanish
Record 16 - internal organization data 2002-10-11
Record 16, English
Record 16, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 16, Main entry term, English
- variable length character string
1, record 16, English, variable%20length%20character%20string
correct
Record 16, Abbreviations, English
Record 16, Synonyms, English
Record 16, Textual support, English
Record number: 16, Textual support number: 1 CONT
Intermediate SQL adds provisions for schema manipulation, dynamic SQL, diagnostics management, long identifiers, multiple module support, cascade delete for referential integrity, multiple schemas per authorization identifier, DATE and TIME data types, domains, variable length character strings, support for national character sets, and substantial enhancements for data manipulation. 1, record 16, English, - variable%20length%20character%20string
Record 16, French
Record 16, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 16, Main entry term, French
- chaîne de caractères de longueur variable
1, record 16, French, cha%C3%AEne%20de%20caract%C3%A8res%20de%20longueur%20variable
correct, feminine noun
Record 16, Abbreviations, French
Record 16, Synonyms, French
Record 16, Textual support, French
Record number: 16, Textual support number: 1 CONT
Le SQL intermédiaire ajoute les éléments suivants : dispositions sur la manipulation de schéma, SQL dynamique, gestion de diagnostics, identificateurs longs, soutien de modules multiples, suppression de cascade de l'intégrité référentielle, schémas multiples d’identificateur d’autorisation, types de données DATE et TIME, domaines, chaînes de caractères de longueur variable, soutien de jeux de caractères nationaux et améliorations importantes de manipulation de données. 1, record 16, French, - cha%C3%AEne%20de%20caract%C3%A8res%20de%20longueur%20variable
Record number: 16, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 16, French, - cha%C3%AEne%20de%20caract%C3%A8res%20de%20longueur%20variable
Record 16, Spanish
Record 16, Textual support, Spanish
Record 17 - internal organization data 2002-10-11
Record 17, English
Record 17, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 17, Main entry term, English
- intersection
1, record 17, English, intersection
correct
Record 17, Abbreviations, English
Record 17, Synonyms, English
Record 17, Textual support, English
Record number: 17, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 17, English, - intersection
Record 17, French
Record 17, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 17, Main entry term, French
- intersection
1, record 17, French, intersection
correct, feminine noun
Record 17, Abbreviations, French
Record 17, Synonyms, French
Record 17, Textual support, French
Record number: 17, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 17, French, - intersection
Record number: 17, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 17, French, - intersection
Record 17, Spanish
Record 17, Textual support, Spanish
Copyright notice for the TERMIUM Plus® data bank
© Public Services and Procurement Canada, 2025
TERMIUM Plus®, the Government of Canada's terminology and linguistic data bank
A product of the Translation Bureau
Features
Language Portal of Canada
Access a collection of Canadian resources on all aspects of English and French, including quizzes.
Writing tools
The Language Portal’s writing tools have a new look! Easy to consult, they give you access to a wealth of information that will help you write better in English and French.
Glossaries and vocabularies
Access Translation Bureau glossaries and vocabularies.
- Date Modified: