sql character index
-- EXAMPLE
select
'0004V0' as TESTER_STRING
, CHARINDEX('V','0004V0') -- OUTPUT: 5
, CHARINDEX('0','0004V0') -- OUTPUT: 1
, CHARINDEX('0','0004V0',4) -- OUTPUT: 6
from DUAL;
-- SYNTAX
CHARINDEX(/*substring*/, /*Main string*/, /*start index*/)sql indexes
CREATE INDEX
Creates an index named ‘idx_test’ on the first_name and surname columns of
the users table. In this instance, duplicate values are allowed.
CREATE INDEX idx_test
ON users (first_name, surname);
CREATE UNIQUE INDEX
Creates an index named ‘idx_test’ on the first_name and surname columns of
the users table. In this instance, duplicate values are allowed.
CREATE UNIQUE INDEX idx_test
ON users (first_name, surname);
DROP INDEX
Creates an index named ‘idx_test’ on the first_name and surname columns of
the users table. In this instance, duplicate values are allowed.
ALTER TABLE users
DROP INDEX idx_test;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
