/SQL/Truncate function in sql oracle

Truncate function in sql oracle

Oracle sql truncate table

-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;

4

Truncate function in sql oracle

SELECT TRUNC(price) FROM product;

1

Truncate oracle

TRUNCATE TABLE tablename

0

Similar codes

0 vote280 views1 answer
Mysql shell set time_zone
SQL
0 vote283 views1 answer
Jdbc sql connection string
SQL
0 vote293 views2 answers
Psql commande \gset
SQL
0 vote284 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote293 views2 answers
Collation in sql
SQL
0 vote277 views1 answer
Optimize sql query
SQL
0 vote316 views1 answer
How to make sure two tables have same exact data in sql
SQL
16 votes294 views4 answers
Find duplicates mysql
SQL
1 vote297 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote289 views1 answer
Str_to_date sql server
SQL

Share