8i, 9i - Internet10g, 11g - Grid12c - CloudSELECT * FROM NLS_DATABASE_PARAMETERS
SELECT COLUMN_ID, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='<TABLE_NAME>' ORDER BY COLUMN_ID
ISNULLSELECT COALESCE(NULL, NULL, 1) FROM DUAL -- 1
TO_NUMBERSELECT TO_NUMBER(REGEXP_REPLACE(X, '([0123456789\.]*).*', '\1')) FROM ( SELECT '123' X FROM DUAL UNION ALL -- 123 SELECT 'A23' X FROM DUAL UNION ALL -- NULL SELECT 'A23D' X FROM DUAL UNION ALL -- NULL SELECT '12C34' X FROM DUAL UNION ALL -- 12 SELECT '12.45D34' X FROM DUAL UNION ALL -- 12.45 SELECT '123DE6' X FROM DUAL UNION ALL -- 123 SELECT NULL X FROM DUAL -- NULL )
CREATE TABLE TEST_AUTOINCR ( "ID" INT GENERATED ALWAYS AS IDENTITY NOT NULL, "DATA" NVARCHAR2(100) NOT NULL, UNIQUE ("ID", "DATA") )
INSERT INTO TEST_AUTOINCR (DATA) VALUES ('a') INSERT INTO TEST_AUTOINCR (DATA) VALUES ('b') INSERT INTO TEST_AUTOINCR (DATA) VALUES ('c')
SELECT * FROM TEST_AUTOINCR
CREATE SEQUENCE AUTOINCR_SEQ START WITH 1 INCREMENT BY 1
create table AUTOINCR ( SEQ NUMBER not null primary key, DATA NVARCHAR2(512) not null )
INSERT INTO AUTOINCR (SEQ, DATA) VALUES (AUTOINCE_SEQ.NEXTVAL, 'a') INSERT INTO AUTOINCR (SEQ, DATA) VALUES (AUTOINCE_SEQ.NEXTVAL, 'b') INSERT INTO AUTOINCR (SEQ, DATA) VALUES (AUTOINCE_SEQ.NEXTVAL, 'c')
7.1. Backlinks7.2. Similar PagesSimilar pages by cosine similarity. Words after page name are term frequency.
|