Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
CREATE TABLE DEPT_WITH_KEY
AS
SELECT DEPTNO, DNAME,LOC,ROWNUM NEW_KEY
FROM DEPT;
DEPTNO,DNAME,LOC
10,ACCOUNTING,NEW YORK
20,RESEARCH,DALLAS
30,SALES,CHICAGO
40,OPERATIONS,BOSTON
DEPTNO,DNAME,LOC,NEW_KEY
10,ACCOUNTING,NEW YORK,1
20,RESEARCH,DALLAS,2
30,SALES,CHICAGO,3
40,OPERATIONS,BOSTON,4
UPDATE my_table
SET my_column = my_sequence.NEXTVAL