SQL translation for use with Oracle

Question

I have 2 Oracle questions

• How to translate this SQL Server statement to work with Oracle?

   Create table MyCount(Line int identity(1,1))
  

• What is the equivalent SQL Server image type for storing images in an Orace database?

Answer 1

You do not need to use triggers for this if you control inserts:

CREATE SEQUENCE seq;

CREATE TABLE mycount
(
   line NUMBER(10,0)
);

Then, to insert the value:

INSERT INTO mycount(line) VALUES (seq.nextval);

For images, you can use a BLOB to store any binary data, or a BFILE to manage more or less like a BLOB, but the data is stored in a file system, such as a file jpg.

Literature:

• Create link Sequence .
• .
• Oracle® - .

Answer 2

1:

 CREATE SEQUENCE MyCountIdSeq;
 CREATE TABLE MyCount (
     Line INTEGER NOT NULL,
     ...
 );
 CREATE TRIGGER MyCountInsTrg BEFORE INSERT ON MyCount FOR EACH ROW AS
 BEGIN
     SELECT MyCountIdSeq.NEXTVAL INTO :new.Line
 END;
 /

2: BLOB.

Answer 3

. Oracle SQL Developer.

- Create Table - 12/18c Identity.

DDL

CREATE TABLE MYCOUNT 
(
  LINE INT GENERATED ALWAYS AS IDENTITY NOT NULL 
);

, - SQL Server Oracle. , .

Scratchpad. "", "".

-, Oracle.

Definitely use the authentication feature in 12 / 18c if you are using this version of Oracle. Fewer db objects to maintain.