Tidal Enterprise Scheduler Tutorial
In this post, we will learn what is Tidal and its use to schedule the jobs in informatica. What is Tidal Enterprise Scheduler (TES)? Tidal is a scheduling tool with the help of which...
Author: Shekhar Sharma
Database connection in Java
In the previous post, we have learnt about Collection Framework. In this post, we will see how to connect to the database in java. There are following steps which we need to follow to...
SQL Interview Questions part 12
You can see part 11 here. 166)Display the department name along with total salary in each department. 167) Display itemname and total sales amount for each item. 168) Write a Query To Delete The...
SQL Interview Questions part 11
You can see part 10 here. 151) My boss has changed his mind. Now he doesn’t want to pay more than 10,000.so revoke that salary constraint. 152) Add column called as mgr to your emp...
SQL Interview Questions part 10
You can see part 9 here. 136) Display the 10th record of emp table without using group by and rowid? 137) Delete the 10th record of emp table; 138) Create a copy of emp table;...
SQL Interview Questions part 9
You can see part 8 here. 121) Display those employee whose deptno is available in salary? 122) Display those employee whose first 2 characters from hiredate -last 2 characters of salary? 123) Display those employee...
SQL Interview Questions part 8
You can see part 7 here. 106) Display name of those employee who are getting the highest salary? 107) Display those employee whose salary is equal to average of maximum and minimum? 108) Select count of...
SQL Interview Questions part 7
You can see part 6 here. 91) Display ename who are working in sales dept. 92) Display employee name,deptname,salary and comm for those sal in between 2000 to 5000 while location is Chicago. 93)Display those employees...
SQL Interview Questions part 6
You can see part 5 here. 76) Display the following output for each row from emp table. Scott has joined the company on Wednesday 13th August nineteen ninety. [hideshow type=”sql76″]SQL>select ENAME||’ HAS JOINED THE...
SQL Interview Questions part 5
You can read part 4 here. 61) Display the names of the employees from department number 10 with salary greater than that of all employee working in other departments. 62) Display the names of the...