Hi , In this article I will tell you some operators . Comparison operators When we want to compare data, for example, there are statements that make it easier for …
Read More »Tag Archives: SQL
Oracle SQL Tutorial -14 Regular Expressions
Hi , In this article I will tell you regular expressions .Regular expressions are used to extract the needed data from the intense data and make the data suitable for …
Read More »Oracle SQL Tutorial -13 Data Processing With Sub-Questions
Hi , In this article I will tell you about multi-column subqueries and related subqueries .Subqueries are used to join data , and the value obtained with the subquery can …
Read More »Oracle SQL Tutorial -12 Data In Different Time Slices
Hi , In this article I will tell you the differences between time expressions and how they are used . TIMEZONE PARAMETER How TIME_ZONE is updated : By giving the …
Read More »Oracle SQL Tutorial -11 Big Data Sets
Hi , In this article , I will tell you how to use the default value , how to copy data from another table . USING DEFAULT VALUE The default …
Read More »Oracle SQL Tutorial -10 Data Dictionary
Hi , In this article I will tell you how to use data dictionary views , what is a data dictionary . DATA DICTIONARY Database information is information about all …
Read More »Oracle SQL Tutorial -9 Managing User Access
Hi , in this article , I will tell you about user creation and user access . USER ACCESS Each user is logged into the system with their user name …
Read More »Oracle SQL Tutorial -7 Creating Other Schema Objects
Hi , In this article I will tell you what is view , how to create . View is the collection of data from multiple tables into a single table and the …
Read More »Oracle SQL Tutorial -6 Update Data In The Oracle Database
Hi , In this article , I will explain topics such as updating data , deleting data from table and adding records to table . ADDING RECORD TO TABLE The …
Read More »Oracle SQL Tutorial -5 Getting Data From More Than One Tables
Hi , in this article I will tell you about the joins . We use Join to join two tables .The JOIN-related column values must be in two tables . …
Read More »