About 1,671,782 results (3,227 milliseconds)

Adding custom fields | Looker | Google Cloud

https://cloud.google.com/looker/docs/custom-fields
Looker automatically applies SQL conditions such as AND or OR logic when multiple conditions are created, based on the field types, conditions, and values that ...

Table chart options | Looker | Google Cloud

https://cloud.google.com/looker/docs/table-options
When you sort by multiple columns, subtotal columns are given precedence. If you change the order of your dimensions by dragging and dropping them in the ...

Procedural language | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/reference/standard-sql/procedural-language
You can use a multi-statement query to: Run multiple statements in a sequence, with shared state. Automate management tasks such as creating or dropping tables.

Delete data from Cloud Firestore | Firebase

https://firebase.google.com/docs/firestore/manage-data/delete-data
The following examples demonstrate how to delete documents, fields, and collections. ... Java is a registered trademark of Oracle and/or its affiliates. Last ...

Insert, update, and delete data using data manipulation language ...

https://cloud.google.com/spanner/docs/dml-tasks
Execute statements with the Google Cloud CLI. To execute DML statements, use the gcloud spanner databases execute-sql command. The following example adds a new ...

Query syntax | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax
... SQL! New name, same great SQL dialect. ... Scalar and array subqueries (see Subqueries) are normally not allowed to return multiple columns, but can return a ...

Secondary indexes | Cloud Spanner | Google Cloud

https://cloud.google.com/spanner/docs/secondary-indexes
SQL queries that use the index and select columns stored in the STORING or ... You can't use this statement to add columns to or drop columns from the index key.

Make schema updates | Cloud Spanner | Google Cloud

https://cloud.google.com/spanner/docs/schema-updates
Minutes, if background validation is not required. ALTER TABLE ... DROP COLUMN, Minutes. ANALYZE ... multiple schema versions, which depends on batching. For ...

FAQ | Datastream | Google Cloud

https://cloud.google.com/datastream/docs/faq
You must delete columns manually. This behaviour is intentional, because in ... Because of this, Oracle LogMiner splits the record into multiple rows. To ...

Introduction to partitioned tables | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/partitioned-tables
... SQL to query partitioned tables or to write query results to partitioned tables. BigQuery does not support partitioning by multiple columns. ... Oracle and/or its ...

Using "ALTER TABLE ADD..." to add multiple columns

https://groups.google.com/g/h2-database/c/Kg4dB64ySfg
Oracle allows adding two columns at once: ALTER TABLE customer ADD (foo INTEGER, foo2 INTEGER); So does Microsft SQL Server's T-SQL: ... + stat.execute("drop ...

GoogleSQL data manipulation language | Cloud Spanner | Google ...

https://cloud.google.com/spanner/docs/reference/standard-sql/dml-syntax
To include multiple columns, you include multiple subqueries: INSERT INTO ... Java is a registered trademark of Oracle and/or its affiliates. Last updated ...

Migrating Oracle® Database users and schemas to Cloud SQL for ...

https://cloud.google.com/solutions/migrating-oracle-database-to-cloud-sql-for-postgresql
A separate CREATE INDEX statement on the referencing columns is needed if an index is required. PostgreSQL does not support Oracle's ON DELETE SET NULL clause.

Data definition language (DDL) statements in GoogleSQL ...

https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language
To modify which columns are indexed, DROP the current index and create a new one. ... Multiple RENAME COLUMN statements in one ALTER TABLE statement are supported ...

Specify nested and repeated columns in table schemas | BigQuery ...

https://cloud.google.com/bigquery/docs/nested-repeated
The multiple fields within each address are the nested data. {"id":"1 ... Java is a registered trademark of Oracle and/or its affiliates. Last updated 2023 ...

How To Quickly Add/Remove Column Statistics (Histograms) For A ...

https://sites.google.com/a/dbaref.com/www/home/database-monitoring-and-troubleshooting/howtoquicklyaddremovecolumnstatisticshistogramsforacolumn?overridemobile=true
Sep 13, 2010 ... gathering statistics for multiple columns with different bucket sizes : SQL> exec dbms_stats.gather_table_stats(null, '<table_name>', cascade=> ...

Data manipulation language (DML) statements in GoogleSQL ...

https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax
When there are multiple qualified clauses, only the first when_clause is executed for a row. matched_clause. The matched_clause defines how to update or delete ...

GoogleSQL data definition language | Cloud Spanner | Google Cloud

https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language
You can't drop a column a generated column references. ... When granting column-level privileges on multiple tables, each table must contain the named columns.

Modifying table schemas | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/managing-table-schemas
To change a column's data type into a castable type, use a SQL ... To learn more about the impact on storage when you drop a column on storage, see ALTER TABLE ...

Query multiple tables using a wildcard table | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/querying-wildcard-tables
Wildcard tables enable you to query multiple tables using concise SQL statements. ... This is the case when the columns of the matched tables have different data ...