Home DBA Create user in Oracle 12 C

Create user in Oracle 12 C

DBA By Ashish Sahay · February 24, 2020 · 0 Comment

Create user 12C:

connect system/manager as sysdba

alter session set "_ORACLE_SCRIPT"=true;
/

create user lime identified by limeoracle;
/

grant dba to lime;
/

connect lime/limeoracle
/

create table test(lime number);

Working with JSON_MERGEPATCH

APEX By Ashish Sahay · December 15, 2022 · 0 Comment

JSON_MERGEPATCH function is very useful to update JSON nodes in JSON documents. We can simply pass the JSON required JSON patch to merge with the existing JSON document using the JSON_MERGEPATCH function, it can add or update the JSON node... Read more

How to find ORACLE locked Objects?

ORACLE By Ashish Sahay · September 21, 2021 · 0 Comment

PLSQL Collection

ORACLE By Ashish Sahay · August 7, 2021 · 0 Comment

PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE OF NUMBER INDEX BY VARCHAR2(10); l_tab l_tab_type; Variable-size array or... Read more

10 ways get Distinct/Unique record without using DISTINCT Oracle

ORACLE By Vikas Pandey · June 9, 2021 · 0 Comment

How to get Distinct/Unique record without using DISTINCT SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : Solution 4 : Solution 5 : Solution 6 : Solution 7 : Solution 8 : Solution 9 : Solution 10 : Read more

Table Blob to Oracle Directory

ORACLE By Ashish Sahay · June 20, 2020 · 0 Comment

How to save table images to oracle directory? Files from table to Oracle directory How to Send all files in ZIP? You might Like: Read more

Oracle NULLIF() Function

ORACLE By Vikas Pandey · June 9, 2020 · 3 Comments

Oracle NULLIF() Function: The Oracle NULLIF() function accepts only two arguments. If the both arguments are equal it returns a null value. In case the arguments are not equal, the NULLIF() function returns the first argument and if any arguments... Read more

3 Ways to Delete Duplicate Record From table in Oracle

ORACLE By Vikas Pandey · June 9, 2020 · 0 Comment

How to delete duplicate record From table using SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : You might also like Read more

3 Ways to Check Duplicate Record in table Oracle SQL

ORACLE By Vikas Pandey · June 5, 2020 · 1 Comment

How to check duplicate record in table SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : You might also like Read more

Oracle NVL2 Function

ORACLE By Vikas Pandey · June 4, 2020 · 3 Comments

Oracle NVL2 Function: NVL2() function is an extend version of the NVL() function with different options based on whether a NULL value exists. Oracle NVL2() function allow three parameters. If the first parameter is not null, then it returns the... Read more

Oracle NULL-Related Functions

ORACLE By Vikas Pandey · June 3, 2020 · 0 Comment

Oracle NULL-Related Functions. There are different type of null related function in oracle. Read more

Create user 12C:

Related Posts

Leave a Reply Cancel reply