Business in A.P and Telangana

Ease of Doing Business: A.P., Telangana top in 2016 all-India ranking: http://www.thehindu.com/business/ease-of-doing-business-andhra-pradesh-telangana-tops-2016-allindia-ranking/article9288074.ece

Thought of the day

How can I achieve Peaceful mind?

      Yes, you are aware of all stereotypical methods to get peaceful mind, but here is available some non-conventional methods. That is "Ignore", if you simply ignore what other people think about you, you can have 99℅ chances to achieve peace.

       Also do not try to impress everybody since it's very tough job to satisfy and win everyone, for that you need to waste time,money or both in some cases. If you no more required to impress others you are saving that time. Do some useful work with that time.

       Make yourself busy with something to avoid some talkative people and non sense debates on politics and movies and especially on third person.

Thought of the Day

It's better to follow your own path imperfectly, than following others path perfectly. - Bagavad Gita.

How to find table wise list of column in Teradata

There may be requirement that you need to find list of the columns of a table or tables. To find this you need to query DBC.COLUMNS data dictionary view.

Example:-

SELECT  * FROM DBC.COLUMNS;

Above query will show all the tables and their columns.

If you know the table or view name then you can specify that in the where condition.

Example:-

SEKECT  * FROM SBC.COLUMNS
WHERE TABLENAME = 'TABLE_NAME';

Grant privileges to user in Teradata

While accessing or modifying any table in Teradata we have to have appropriate privileges to do that. For example if you want to SELECT data from a table in Teradata you have to have SELECT privileges. Let's see how we can provide the privileges.

To give privileges you should have administrator rights.

Syntax:-

GRANT SELECT ON TABLE_NAME TO USER-NAME;

Example:-

Let's say your table name is EMPLOYEE and user name is DBUSER.

GRANT SELECT ON EMPLOYEE TO DBUSER;

How to know Oracle Client / Server is install on your machine

If you are new to Oracle and want to know whether Oracle client is install on your computer then type SQLPLUS in command prompt if Oracle client is install on your computer then command prompt will prompt you for user id else it will say command is not recognized as internal or external command.

 

How to know whether Teradata Utilities are install on your compauter

If you are new to Teradata and don't know if Teradata is install on your computer then you can execute Teradata utilities commands. Below is the sample BTEQ command. Go to the command prompt and type BTEQ, MLOAD and FLOAD etc.

Sample BTEQ is:-