Blogs about: Truncate
Featured Blog
How to truncate time in date field?
In Oracle: SQL> ALTER SESSION SET nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’; Session altered. SQL> SELECT TRUNC(sysdate) FROM DUAL; TRUNC(SYSDATE) ————… more →
Oracle Spin
Truncating strings with bash
joehalliwell wrote 4 weeks ago: This is particularly handy if you’re building up a comma separated list through concatenation … more →
Much faster performance with ASM - a real world example
— 1 comment
John Hallas wrote 1 month ago: We have a Peoplesoft database that manages HR for ~80,000 staff. Oracle 10.2.03. Peoplesoft Tool … more →
Difference between Truncate and Delete
— 1 comment
viralsarvaiya wrote 1 month ago: Truncate and Delete both are used to delete data from the table. Both these commands will only delet … more →
ORA-02064: Distributed Operation not Supported
— 2 comments
akdora wrote 2 months ago: After a short investigation, I did not see this comment: We can not run a PL/SQL block contains a DD … more →
SQL DELETE, TRUNCATE, DROP Statements
— 1 comment
Ankur Bhatia wrote 3 months ago: SQL Delete Statement The DELETE Statement is used to delete rows from a table. The Syntax of a SQL D … more →
Difference between Delete and Truncate
Lakshmi Sravanthi Chowdam wrote 3 months ago: • Delete table is a logged operation, so the deletion of each row gets logged in the transaction log … more →
Avoiding split words when truncating text
dreamsincode wrote 3 months ago: In today’s world of widgets, dashboards and snippets, as programmers we often find ourselves t … more →
Using FLASHBACK to rollback a TRUNCATE
— 1 comment
Gavin Soorma wrote 3 months ago: This scenario will show how we can use a combination of FLASHBACK database and also recovery to take … more →
truncate in db2
prateekurmaliya wrote 4 months ago: in db2 there is delete but there is nothing like truncate which is available in sybase and oracle.so … more →
Exploits and Exploiters: Volume 3
— 5 comments
blorgo wrote 4 months ago: This is the last volume, and possibly the best interview Ive done… This exploiter is not just … more →
SQL: Truncating a SQL Database Log
ablogontech wrote 5 months ago: Thanks to John McBride for helping me with this. 1. In SQL Management Studio, make sure you are conn … more →
A long time ago, in a framework far far away
nickjosevski wrote 6 months ago: I have been really busy lately, haven’t had much of a chance to work on some of the WCF post i … more →
Linux Truncate (Log)File
Varun wrote 6 months ago: Commands to empty logfile i) :>logfile – If logfile does not exist, this will create an emp … more →
How to truncate time in date field?
Amin Jaffer wrote 6 months ago: In Oracle: SQL> ALTER SESSION SET nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’; Session … more →
DELETE vs TRUNCATE
veeolina wrote 7 months ago: DELETE sama TRUNCATE apa bedanya sih? Perasaan fungsinya sama, hapus-hapus juga.. Eits..tunggu dulu. … more →
ORA-01031: insufficient privileges
Amin Jaffer wrote 8 months ago: Here are some of the scenarios when one gets ORA-01031: 1) Insufficient privileges error is when … more →
Truncating SQL logs when Load Testing!
chekkin wrote 1 year ago: So a little while back, I was using VSTS to conduct some load testing and I set up a simple test Web … more →
How do I shrink/truncate the transaction log?
— 2 comments
dba4life wrote 1 year ago: Every DBA’s nightmare… Your boss is running around the office with his hands waving in t … more →
Columns
rick130 wrote 1 year ago: How do I copy a DataWindow value to a variable? li_seq = dw_1.GetItemNumber(li_row, “SEQ_NO … more →
