ORACLE LISTAGG

USERS TABLE

ID	NAME
1	BURAK
2	ARIF

 

 

DEPARMENTS TABLE

ID	DEPARMENT_NAME	RF_ USER_ID
1	DELIVERY	1
2	FINANCE	2
3	IT	1

 

SELECT
U.NAME,
LISTAGG (D.DEPARMENT_NAME,',') WITHIN GROUP (ORDER BY U.NAME) AS DEPARTMENTS
FROM
USERS U
INNER JOIN DEPARMENTS D ON U.ID = D.RF_USER_ID group by u.name

 

 

RESULT TABLE

NAME	DEPARTMENTS
BURAK	DELIVERY,IT
ARIF	FINANCE

how to use array in oracle

if you wanna its not null array you must be write "not null"

DECLARE
TYPE myArrayType IS TABLE OF VARCHAR(50) NOT NULL INDEX BY BINARY_INTEGER;

v_array myArrayType;

BEGIN
v_array(0):='OLGUN';

v_array(1):='ARİF';

v_array(2):='BURAK';

FOR I IN 0 .. 2 LOOP
dbms_output.put_line(v_array(i));
END LOOP;
END;

express static in node js

in app.js

app.use(express.static('public'));

app.use (express.static('src/views'));

• /


• app.js


• public
  
  
  
  • css
    
    
    
    • bootsrap.min.css
    
    
    • styles.css
    
    
    
    
  
  
  • js
    
    
    
    • style.js
    
    
    
    
  
  
  
  


• src
  
  
  
  • views
    
    
    
    • index.html
    
    
    
    
  
  
  
  

global temp table in oracle

CREATE GLOBAL TEMPORARY TABLE globaltemp_1
(
NAME VARCHAR2(50)
)
ON COMMIT PRESERVE ROWS; -- session

CREATE GLOBAL TEMPORARY TABLE globaltemp_2
(
NAME VARCHAR2(50)
)
ON COMMIT DELETE ROWS; -- commit,truncate,alter,drop

BEGIN
INSERT INTO USERS VALUES(2,'BURAK');
INSERT INTO globaltemp_1 VALUES ('A');
INSERT INTO globaltemp_2 VALUES ('A');
END;

check constraint in oracle

ALTER TABLE USERS ADD
CONSTRAINT USERS_C01
CHECK (NAME IN('BURAK'))
ENABLE
VALIDATE;

Using a Deferred Constraint in Oracle

ALTER TABLE DEPARMENTS
ADD CONSTRAINT fk1
FOREIGN KEY (RF_USER_ID)
REFERENCES USERS (ID) DEFERRABLE;


set constraint FK1 deferred;

update users
set ID = 5
where ID = 2;

update deparments
set RF_USER_ID = 5
where ID = 1;

commit;

OR

 

SET CONSTRAINT FK1 IMMEDIATE;

linq practies one

var value = "2:00,2:00";
var x = value.Split(',').Select(t => "0:" + t).Select(t=> TimeSpan.Parse(t)).Select(t=>t.TotalSeconds).Sum();
Console.WriteLine(TimeSpan.FromSeconds(x));
Console.ReadLine();

 

result : 00:04:00