Forum

Active Member
Joined: Jul 27, 2020
Last seen: Apr 12, 2022
Topics: 0 / Replies: 18
Reply
RE: Can you give some examples using SQL date format dd mm yyyy?

Let us consider the simple calendar table for this example SQL date format dd mm yyyy and date format YYYYMMDD examples. date format ddmmyyyy ...

2 years ago
Reply
RE: How to write a query to count the number of invoices?

Let us see how to write a query to count the number of invoices with practical examples. Invoice ID is a unique ID or a table column that exists...

2 years ago
Reply
RE: Can we join view with table in oracle?

A view is a virtual table in the database and it can be derived from two or more tables. Instead of writing complex queries every time we can store ...

2 years ago
Reply
RE: What is normalization in dbms?

Normalization is a processes of splitting larger set of tables into smaller tables to reduce redundancy in the database (duplicate data). It avoid ...

2 years ago
Reply
RE: What is Junk Dimension in Data Warehousing?

Generally in the junk dimension, we keep cartesian products of all the attributes possible values. creation of the junk dimension provides an easy w...

2 years ago
Reply
RE: What are the types of fact table in data warehousing?

A fact is an entity that provides quantitative information about the business. We store these numeric entities into a fact table. There are 3 types ...

2 years ago
Reply
RE: What is slowly changing dimensions in data warehousing?

The data present in the dimensional table changes from time to time. For example, the customer is staying in India for two years and then he moved to ...

2 years ago
Reply
RE: What is Star Schema and Snowflake Schema in Data Warehousing?

Sart schema and Snowflake schemas play an important role in Data Warehouse. Start Schema: One fact table in the middle and surrounded by many dim...

2 years ago
Reply
RE: What is the OLTP and OLAP in Data Warehousing?

Hello, I will explain to you the major difference between OLTP and OLAP. 1) OLTP: Online Transaction Processing System. All transactional da...

2 years ago
Reply
RE: How to find only non matching records from both tables?

You can try the below query. Just change the table names and column names as per your requirement. SELECT B.CountryIDFROM TableB AS B LEFT JOIN Tabl...

2 years ago
Reply
RE: How to get age from dob column?

SELECT TRUNC((SYSDATE - TO_DATE(DOB, 'YYYY-MM-DD'))/ 365.25) AS AGE_ASOFTODAY FROM DUAL; It is one of the easiest way to write a query to achieve th...

2 years ago
Reply
RE: Find the employee details who are earning more than their supervisor?

You can use below query to achieve this. SELECT employee.*FROM your_table_name AS employeeJOIN your_table_name AS manager ON manager.EMPNO = employe...

2 years ago
Topic
Replies: 2
Views: 280
Page 1 / 2