/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 vote120 views1 answer
Sql out file formate
SQL
1 vote104 views1 answer
Customer using hdfc bank sql query
SQL
0 vote120 views1 answer
Oracle date summer time
SQL
0 vote126 views1 answer
Load data infile mariadb slow
SQL
0 vote118 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote113 views1 answer
Mysqldump don't drop table
SQL
0 vote116 views1 answer
Firebird where
SQL
5 votes123 views1 answer
Oracle create table comment
SQL
0 vote103 views1 answer
How to use query in nosql
SQL
0 vote109 views1 answer
Drop-toys-table
SQL

Share