priya

A list of different types of database objects: Tables: This is a set of elements organized in vertical and horizontal fashion. Tablespaces: This is a logical storage unit in Oracle. Views: It is virtual table derived from one or more tables. Indexes: This is a performance tuning method to process the records. Synonyms: This is … Read more

Translate is used to substitute a character by character while Replace is used to substitute a single character with a word. In Oracle, both TRANSLATE and REPLACE functions are used to replace characters in a string, but they have some differences in terms of functionality. REPLACE Function: The REPLACE function in Oracle is used to … Read more

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