Welcome to the Vertica Forum

Tips from the Team

Archives for October 2018

Re-Compute a Table Column’s Default Value

Jim_Knicely 398 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Derive a Table Column’s Default Value from another Column

Jim_Knicely 365 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Default a Column’s Value

Jim_Knicely 662 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Display View Column Data Types

Jim_Knicely 652 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Insert Text Into Text

Jim_Knicely 359 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Reset Your Session

Jim_Knicely 364 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Conveniently Display Key Projection Info

Jim_Knicely 357 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Checking the Validity of a Table Audit

Jim_Knicely 468 views 10 comments 1 point Most recent by Sankarmn May 1Tips from the Team
Generate an Auto-Incrementing Alphabetical Series Using SQL

Jim_Knicely 366 views 0 comments 1 point Started by Jim_Knicely October 2018 Tips from the Team
Viewing Previously Generated Explain Plans

Jim_Knicely 386 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Display Null Query Result With an Alternate Text

Jim_Knicely 381 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Special Date/Time Formatting

Jim_Knicely 377 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Change the VSQL Result Set Border

Jim_Knicely 370 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Find Which System Tables Have a Particular Column Name

Jim_Knicely 417 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Find Which Tables Have a Particular Column Name

Jim_Knicely 414 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Database Storage - Raw and Compressed Size

Jim_Knicely 515 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Display Last SQL Run Time

Jim_Knicely 432 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Displaying the Administration Tools Process ID

Jim_Knicely 371 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Rotating Column Data Using SQL Analytics

Jim_Knicely 373 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Return Zero Instead of NULL

Jim_Knicely 440 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team