DanBrother的部落格

JSON_ELEMENT_T: the supertype for the JSON_OBJECT_T, JSON_ARRAY_T, JSON_SCALAR_T and JSON_KEY_LIST object types.
Each of them extends JSON_ELEMENT_T as a subtype.
An instance of type JSON_ELEMENT_T, which is an in-memory representation of the JSON data, can be constructed only by parsing JSON text.

CREATE TABLE json_test_tab (
  id    RAW(16) NOT NULL,
  data  CLOB,

Oracle Password Policy Checking PL/SQL Function Using REGEXP_COUNT

create or replace function pwd_policy_check_fnc(pwd varchar2)
return pls_integer

Reading Loaded Files from XML DB through Oracle Embedded PL/SQL Gateway
 

type myfilelist.bat

Building a simple webpage using Embedded PL/SQL Gateway

-- Create a demo user
create user demo_user identified by demo_user default tablespace users temporary tablespace temp;

Using Oracle REGEXP_SUBSTR function & CONNECT BY LEVEL clause to Decompose String

col String format a10

Change public synonyms to private synonyms in Oracle

The following anonymous PL/SQL block will change the public synonyms granted by SCOTT to private synonyms:

. oraenv

Pragma Serially_Reusable Practice:

According to Oracle® Database PL/SQL Language Reference 11g Release 1 (11.1),

Upload File using PL/SQL Web Toolkit

Use of Quote operator "q" in Oracle 11g

The following SQL statements will produce the same results.

Check If a "number" is an integer or a float (Oracle PL/SQL):

declare
v_is_int number(1);

-----------------------------------------------------------------------------------
-- Convert Rows into Columns using Oracle PIVOT
-----------------------------------------------------------------------------------

Handling PL/SQL Error Message with DBMS_UTILITY.FORMAT_ERROR_STACK and DBMS_UTILITY.FORMAT_ERROR_BACKTRACE

-- Old Way
set serveroutput on size 100000

One thing neat about SQL*Plus is that it can even generate HTML file in addition to text file.

Here's the example:

PL/SQL BULK COLLECT Using LIMIT Clause Practice:

The first example demonstrates a way to joining a PL/SQL table with a normal table using built-in data type.

create table student_table

Function to Get A Random Alphanumeric String:

create or replace function get_random_alphanumeric_string

Oracle RANK() and DENSE_RANK() FUNCTION PRACTICE

-- Create a table named "rank_practice" containing student point information
create table rank_practice

Oracle LISTAGG Analystic Function (11gR2)
Purpose: To aggregate data from a number of rows into a single row.

SQL> desc emp

The following example demonstrates three ways to display current session sid of the user - SCOTT :

conn / as sysdba
accept pwd hide