Diksha IT Training Centre

  Benefits of  %TYPE and %ROWTYPE in Oracle PL/SQL Anonymous Block.   Hello Everyone, Today I will discuss about %TYPE and %ROWTYPE in Oracle. In my previous blog I already discussed about uses of cursors in Anonymous PL/SQL block. I suggest you to please go through below blog for your reference so that you can easily understand %TYPE and %ROWTYPE in PL/SQL anonymous block. https://dikshaoracletraining.blogspot.com/2020/10/cursor-and-types-of-cursor-in-oracle.html Let’s Start with   both attribute   %TYPE and %ROWTYPE then we will write some Anonymous PL/SQL block   by using %TYPE and % ROWTYPE and see its advantage.   %TYPE  : %TYPE  is mainly used to defined the data type of variable as the column name data type specified for a table. If table column has data type varchar2 (50) then %type variable automatically take the data type that is varchar2 (50) no need to define data type while writing PL/SQL block as ...

Importance of Synonym in Oracle Database.   Hello Everyone, Today I will discuss about Synonym in Oracle as Synonym play important role in database to hide information of object. Before Starting this blog please go through my previous blogs of SQL in my archive folder. Let’s Discuss about Synonym. Synonym in database is an object which is basically used as alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. We generally use synonyms for granting access to an object from another schema and you don't want the users from which Schema it’s own the object. In Another word we can say synonym is an alias for any table, view, snapshot, sequence, procedure, function, or package. Because a synonym is simply an alias, it requires no storage other than its definition in the data dictionary. Synonyms are basically used for security purpose and convenience. For example, Synonym can do the following: ·     ...

Performance Tuning in Oracle. Hello Everyone, Before Reading this blog please go through my previous blog for better understanding of this topic. Today I will discuss about performance tuning by using SQL for Data Analysis. Performance Tuning play important role in any application where data is heavy and on daily basis data is extracting from user. As everyone needs data / information on time and if get stuck somewhere it means we need to tune the query to improve the performance of the application. So in this blog, we will learn to identify when SQL queries needs to be improved, and how to improve them.   Let’s understand Performance tuning in Simple way. Performance tuning is the process of optimizing Database performance by streamlining the execution of SQL statements. In other words, performance tuning simplifies the process of accessing and altering information contained by the database with the intention of improving query response times and application operations. ...

Why Oracle Database is important in IT organization and job Demand in IT company.   Oracle database is a very popular secured database that is widely used across all multinational companies. Knowledge of SQL and PL/SQL is must because the demand for SQL and PL/SQL-expertise is high and it's give you advantage to get the job easily. Database is always wanted technology in IT. In fact its growing tremendously as data is keep on increasing in all sectors like cashless, e-commerce, SMAC etc. Oracle is no doubt a Dominant leader in DB industry. So PL/SQL is all time a good technology to learn in IT career. Oracle database server also prevents unauthorized access and provides efficient solutions for failure recovery. Oracle Database is the first database designed for enterprise grid computing and the most flexible and cost effective way to manage information and applications. Nowadays you will see in evry Domain Oracle database is used as Back-end to manage information and applic...

          Index and Types of Index in Oracle and it’s Advantages.   Hello Everyone, Today I will discuss about Index and types of index in Oracle and its advantages. I suggest you to please follow my previous blogs related to SQL topics for better understanding. Let’s start why index is used in SQL database and the types of index and benefits of using index for query performance. Index is an object which is associated with tables or table cluster that can used to speed data access and reducing disk I/O. By creating an index, you can retrieve related set of rows from table instead of all Rows. In database technologies (Oracle, SQL Server, Sybase, DB2, MySQL, etc.), the objects we create to access the data for fast retrieval is known as Index: The usage of Index is very common especially in the performance tuning of database. Index is one of the most important objects that are used for performance tuning of databases. When any data is queried from a t...