Notes on Oracle

BLOB data type is a data type with varying length binary string. It is used to store two gigabytes memory. For BLOB data type, the length needs to be specified in bytes. In Oracle, BLOB stands for Binary Large Object. It is a data type used to store binary data, such as images, audio, video, … Read more

Yes, you can store pictures in a database using Long Raw Data type. This data type is used to store binary data for 2 gigabytes of length. However, the table can have only one Long Raw data type. In Oracle, storing pictures or any binary data, such as images, in a database is typically done … Read more

Synonym can be used to hide the real name and owner of an object. It provides public access to an object. It also provides location transparency for tables, views or program units of a remote database. It simplifies the SQL statements for database users. In Oracle, synonyms are used for the following purposes: Simplifying Object … Read more

There are two types of synonyms or alias: Private: It can only accessed by the owner. Public: It can be accessed by any database user. In Oracle, there are two main types of synonyms: private synonyms and public synonyms. Private Synonyms: Private synonyms are owned by a specific user. They are only accessible to the … Read more

A synonym is also known as alias for a table, view, sequence or program unit. In the context of Oracle databases, a synonym is an alias or alternate name for a table, view, sequence, procedure, or other database object. Synonyms provide a way to simplify the way users and applications access database objects by providing … Read more