Remove Special Character using REGEXP_REPLACE : ORACLE

Example  :

REGEXP_REPLACE(style_ref_no, '[]~!@#$%^&*()_+=\{}[:”;’<,>./?]+', '')

MSSQL: RESTORE DB USING master User

Alter Database <YOUR DB>
  SET SINGLE_USER With ROLLBACK IMMEDIATE
 
 
RESTORE DATABASE <YOUR DB>
  FROM DISK = 'D:\BACKUP_DB\FR_17.04.2019 morning'

Oracle : ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]

      SQL> startup mount
      SQL> alter database recover; //recover database;
      SQL> alter database open;

Comma separated value to ROWS in ORACLE SQL

SELECT t.id,
       v.COLUMN_VALUE AS value,
       ROW_NUMBER() OVER ( PARTITION BY id ORDER BY ROWNUM ) AS lvl
    FROM   prod_resource_mst t,
       TABLE(
         CAST(
           MULTISET(
             SELECT TRIM( REGEXP_SUBSTR( t.line_number, '[^,]+', 1, LEVEL ) )
             FROM   DUAL
             CONNECT BY LEVEL <= REGEXP_COUNT( t.line_number, '[^,]+' )
           )
           AS SYS.ODCIVARCHAR2LIST
         )
       ) v  where id=51

SQLSERVER: 'Concat' in SQL SERVER 2008

Example

Select a.* 
from testa a
Where (cast( a.column1 as varchar) +cast(a.column2 as varchar))    in (select  cast( b.column1 as varchar) +cast(b.column2 as varchar)  from testb b)

Oracle Rows Generate from Column Value

Example

 Select COLUMN1,COLUMN2,
               From (
               select COLUMN1,COLUMN2,
                   regexp_substr(STRING_COLUMN,'[^,]+',1,column_value) as STR
                  from SAMPLE_TABLE
                        TABLE(cast(multiset(select level
                       from dual
                        connect by level <= length(DAYS) -
                                length(replace(DAYS,','))+1)
                               as sys.odcinumberlist))               
               )  Where ,COLUMN2=P_COLUMN2 and STR Is Not Null Order By 1,3

Oracle: Make Oracle Password Unlimited

Change the profile limit to unlimited.

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;