filename
your choice of file name for the private key:filename
and the public key has been saved as filename
.pub
. It also displays information about the key fingerprint and randomart image..ppk
(PuTTY private key)..ppk
file extension indicates that the private key is in PuTTY's proprietary format. You must use a key of this format when using PuTTY as your SSH client. It cannot be used with other SSH client tools. Refer to the PuTTY documentation to convert a private key in this format to a different format. .pub
extension to indicate that the file contains a public key.ssh
utility on Linux), export the private key:.ppk
format, using an extension such as .openssh
to indicate the file's content.JSON_OBJECTAGG
is an aggregate function. It takes as its input a property key-value pair. Typically, the property key, the property value, or both are columns of SQL expressions. This function constructs an object member for each key-value pair and returns a single JSON object that contains those object members. KEY
is optional and is provided for semantic clarity. string
to specify the property key name as a case-sensitive text literal. expr
to specify the property value. For expr
, you can specify any expression that evaluates to a SQL numeric literal, text literal, date, or timestamp. The date and timestamp data types are printed in the generated JSON object or array as JSON Strings following the ISO 8601 date format. If expr
evaluates to a numeric literal, then the resulting property value is a JSON number value; otherwise, the resulting property value is a case-sensitive JSON string value enclosed in double quotation marks. expr
evaluates to null. NULL
ON
NULL
- When NULL ON NULL is specified, then a JSON NULL value is used as a value for the given key. ABSENT
ON
NULL
- If you specify this clause, then the function omits the property key-value pair from the JSON object. VARCHAR2[(
size
[BYTE,CHAR])]
VARCHAR2
data type elsewhere in SQL, you are required to specify a size. However, in this clause you can omit the size. CLOB
to return a character large object containing single-byte or multi-byte characters. BLOB
to return a binary large object of the AL32UTF8
character set. VARCHAR2
but omit the size
value, then JSON_OBJECTAGG
returns a character string of type VARCHAR2(4000)
. STRICT
clause to verify that the output of the JSON generation function is correct JSON. If the check fails, a syntax error is raised. WITH UNIQUE KEYS
to guarantee that generated JSON objects have unique keys.