Oracle Sequence is the alternative of Identity in SQL Server. You need to create a sequence using below SQL Command
CREATE SEQUENCE student_seq
MINVALUE 1
MAXVALUE 999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 20;
and then you can easily use sequence in following way
INSERT INTO Students( StudentId,
,SelectedCourse
,UserID
,YogaBefore
,YourComment
)
VALUES(
student_seq.NEXTVAL,
,@SelectedCourse
,@UserID
,@YogaBefore
,@YourComment
UPDATE Students SET[SelectedCourse]=@SelectedCourse
,[UserID]=@UserID
,[YogaBefore]=@YogaBefore
,[YourComment]=@YourComment
where
[StudentID]=student_seq.CURRVAL
)