Get a String using “case” when my query is empty on oracle or just the list of element?
Good morning i have a simple question to do:
Get first possible number that is not used in a range
I have two tables defined
I have a table which has 3 diff status column like status1,status2 and status 3 and for each status I want a separate row
I have a table which has 1 ref no and 3 diff status column like status1,status2 and status 3 and for each status I want a separate row. Addition to that in output we shall have a sequence no column for each status if statuses are started, pended and closed then sequence no will be 1,2 and 3. Multiple rows will be created for each status.
SQL Query – Ignore row if data is null for multiple rows on single condition
I have a below table
group function not allowed here
I am trying to get the count of distinct c.deal_no and use this value in my further calculations, but I am facing error.
Oracle group in rows
I have a table that I would like to group by row. With “group by” the entire column is always grouped.
ORACLE SQL script does not create table nor develop the constraints
create table flight ( flight_Ref_No VARCHAR(11) NOT NULL, flightCrewList_ID NUMBER(10) NOT NULL, aircraft_Model_No VARCHAR(6) NOT NULL, flight_Date DATE NOT NULL, flight_Time TIME NOT NULL, Departure VARCHAR(50) NOT NULL, Arrival VARCHAR(50) NOT NULL, primary key(flight_Ref_No), foreign key(flightCrewList_ID) references crew_list(C_List_ID), foreign key(aircraft_Model_No) references aircraft(aircraft_Model_No), constraint chk_flight_Ref_No check (REGEXP_LIKE(flight_Ref_No, ‘^[A-Z]dddd-dddd$’)), constraint chk_CrewList_No check (REGEXP_LIKE(flightCrewList_ID, ‘^dddddddddd$’)), constraint chk_aircraft_Model_No check […]