The SQL SELECT statement is used to fetch records from one or more SQL tables or views in your database. The records fetched are known as resultset which is shown in tabular format. SQL or Structured Query Language is used … Read more »
As the name suggests, Temporary Tables are temporary in nature but act as full features table until the connection is closed. The main difference between a permanent and a temporary table is that table definition and data stored is persistent … Read more »
The SQL ALTER TABLE statement is used to add, delete/drop, or modify columns in an existing SQL table. It is also used to add or drop constraints on an existing table. SQL ALTER TABLE – Add Column The ADD statement … Read more »
The SQL COPY TABLE statement is used to copy data from one table to another table within the same database server. If you want to copy a SQL table to another table in the MySQL database, it is possible by … Read more »
DBC.DBCINFO table in Teradata will have all the related information related to the Teradata release and version. You can check Teradata Database Release and Version using the following query. select * from dbc.dbcinfo; Here, dbc – Database computer. dbcinfo – … Read more »
The default width in Teradata BTEQ setting display maximum of 75 characters in a single line. If we need to display more than 75 characters in a single line, we can set the width of the screen in Teradata BTEQ. … Read more »
1. What is Master Index and Cylinder Index? Teradata uses logical address system, unlike other DBMS which are physical address system. This allows Teradata to locate the data easily if the data gets reallocated or de-fragmented. Master Index and Cylinder … Read more »
INSTR in Teradata is used to get the position of a search string in the source string. Syntax: select instr( source_string, search_string [,position[,occurrence]]) Example: SELECT INSTR(‘choose a chocolate chip cookie’,’ch’,2,2); The above query will return 20, indicating the position of … Read more »
OTRANSLATE in Teradata: Returns source_string with every occurrence of each character in from_string replaced with the corresponding character in to_string. OTRANSLATE is an embedded services system function. It can be activated by invoking embedded services functions Expressions passed to this … Read more »
Oreplace in Teradata is used to replace every occurrence of matching string with the new string in Teradata. Oreplace is mainly used to either to replace of remove portions of a string. Oreplace Syntax: SELECT oreplace(‘source_string’,’string_to_replace’,’new_string’) Oreplace Example: SELECT oreplace(‘TeradataPoint’,’Point’,’Tutorial’); … Read more »