Many times we need to change password on the remote desktop. And you find that when you press Ctrl + Alt + Del while in RDP, this is still passed to the local computer from where you have setup the Remote desktop connection. I have too encountered this issue recently and I did lot of […]
How to change password on Remote desktop (RDP) Read More »
We often need to Alter Table in Oracle depending on Requirement changes and upgrade. Here are the some of the important points about Alter table statement You alter or modify a table using the ALTER TABLE statement. The table must be contained in your schema To alter a table, or you should either have ALTER object privilege
How to Alter Table in Oracle Read More »
-Oracle allows us create a temporary table. -The definition of a temporary table is visible to all sessions, but the data in a temporary table is visible only to the session that inserts the data into the table. -We have to use the CREATE GLOBAL TEMPORARY TABLE statement to create a temporary table. -The ON COMMIT clause indicates if
Creating a Global Temporary Table in Oracle Read More »
Oracle SQL is the widely used in various Products. Having a knowledge in Oracle SQL is plus point. This Oracle sql online test check the understanding on various topics like Oracle table, Oracle view ,constraints, type of index, sequences, subqueries , oracle joins ,materialized view, primary key constraints , single row function ,sql queries and
Oracle sql online test Read More »
What is PuTTY CONNECTION MANAGER (PuttyCM) PuttyCM displays multiple PuTTY sessions in Tabs. It is very useful for the administrator who is working on multiple server at a time. This enables the administrator to perform multiple function with ease. Moreover this is freeware. This can be used for Linux/AIX/solaris and other Operating system easily. Significant
PuTTY CONNECTION MANAGER (PuttyCM) Read More »
Sometimes you need to display data from multiple tables. In order to perform that you need to link one table to another table.There are various ways in which we can obtain data from Multiple tables.Here I would be focusing on Oracle Joins with examples.This is valid for in general any Sql Joins also. I would
What are Oracle Joins (Sql Joins)? Read More »
