Blog

Learn PL/SQL : Create Oracle SQL Functions

Learn PL/SQL : Create Oracle SQL Functions

Do you know in Oracle PL/SQL How to Create Oracle SQL Functions and where you can use them. In this article of Oracle PL/SQL  , I  will tell you how to create function & uses . How to Create Oracle SQL Functions Lets first understand Oracle SQL function. What is a function ? Functions are built into Oracle Database and functions […]

credssp encryption oracle remediation on RDP

credssp encryption oracle remediation on RDP

Now days many  people are facing  credssp encryption oracle remediation  problem when you take remote desktop connection , credssp  stands for Credential Security Support Provider Protocol , It is an authentication provider that processes authentication requests for other application. Now lets talk about the problem. credssp encryption oracle remediation When we try to establish an insecure remote desktop connection, and the insecure […]

Learn Oracle PL/SQL : Create & Use View

Learn Oracle PL/SQL : Create & Use View

Do you know the type of views ,how to create them and their uses.  In this blog I will tell you about views , how you can use them practically. Before that I want to tell you that this is my third blog on Learn Oracle pl/sql if you have not read earlier blog on Variables & Tables kindly read […]

Learn Oracle PL/SQL : Create & Use Tables

Learn Oracle PL/SQL : Create & Use Tables

Hello  friends , I hope you understood my last blog Learn Oracle PL/SQL with Live Project Part-1  In that blog I teach you that variable type which we usually use in Oracle pl/sql. Now in this blog i will tell you about tables , where and how to use them. Learn Oracle PL/SQL :Create & Use Tables   First lets […]

Learn Oracle PL/SQL : Variables

Learn Oracle PL/SQL : Variables

Learn Oracle PL/SQL Here i will make you learn Oracle PL/SQL in very simplified way . I will teach you in my way like I  learned.  I hope you know what is PL/SQL & what is database, because i am not here to teach you theory if you need definitions you can go to other websites. What you will learn […]

Top 10 ORACLE PL/SQL Interview Questions

Top 10 ORACLE PL/SQL Interview Questions

Here are the list of most frequently asked ORACLE PL/SQL Interview Questions in technical interviews ORACLE PL/SQL Interview Questions 1.Difference between Varchar and Char ? Varchar doesn’t sets aside memory location during declaration of a variable. It stores the value only after a variable is defined or assigned a value. Its storage capacity is 32767 Bytes. Char however preserves the […]

How to login with Putty & Execute Stored Procedure

How to login with Putty & Execute Stored Procedure

Have you ever execute stored procedure other than Toad or SQL Developer Software . If not then i will tell you how to execute stored procedure using Putty Software. If you don’t know  about Toad& SQL Developer . They are database management tool set that database developers, database administrators, and data analysts use to manage both relational and non-relational databases using SQL. How to […]