Posts

Showing posts from May, 2018

Read notification from outlook

Image
-           General information,  we are having an read indication in “Whatsapp” application to get a confirmation ( double tick blue color ) like that particular message was read by the particular user (or) not.  -           Do we have the same kind of option in outlook. Yes,  please find below details. -           Once that particular message was read by the user then we used to get a below mentioned notification. Thanks, Karthik P

What is the difference between FastLoad and MultiLoad in Teradata?

What is the difference between FastLoad and MultiLoad in Teradata?   Fast Load Multi Load Target table should be empty Target table need not be empty Using a single script only one table can be loaded Can load / update up to 5 tables Support only create/ insert statement Supports up to 20 DML statements in single script Doesn’t support tables with RI, SI and triggers Supports tables with NUSI  

How to get the user list using by group in UNIX

getent group groupname

How to take first Friday of the month in Oracle.

How to take first Friday of the month in Oracle. select next_day(last_day(add_months(sysdate,-1)),'Friday') qc from dual;

How to copy all the files from Source Location to Target location in unix

 How to copy all the files from Source Location to Target location in unix cp -r /Source_Server_Path/Log /Target_Server_Path/Log

How to insert same records for multiple times in Oracle.

How to insert same records for multiple times in Oracle. BEGIN   FOR i IN 1..10 LOOP              INSERT INTO Product                (                   Product_ID,Product_Name                )               SELECT max(Product_ID)+1, Product_Name               FROM Product where Product_ID in (select max(Product_ID) from Product)               GROUP BY Product_ID,Product_Name   END LOOP; END;