Lucy's thoughts ...

Search This Blog

ADG_REDIRECT_DML in Oracle Active Data Guard 19c

on October 27, 2022

0

Get link
Facebook
X
Pinterest
Email
Other Apps

Oracle Release Schedule

on October 18, 2017

Get link
Facebook
X
Pinterest
Email
Other Apps

Release Schedule of Current Database Releases (Doc ID 742060.1)

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Last Insert ID with PHP & Oracle

This article is continue of earlier article Using PHP with Oracle database . You can expand the part of dbUtil.php with following code: public function executeVariable($sql, $printSql = false) { if ($this->connection) { // Prepare the statement $stid = oci_parse($this->connection, $sql); if($printSql) { echo $sql; } if (!$stid) { $e = oci_error($this->connection); var_dump($e); } OCIBindByName($stid,":ID",$id); // Perform the logic of the query $r = oci_execute($stid); if (!$r) { $e = oci_error($stid); var_dump($e); } return array("result" => $r, "lastID" => $id); } } Now you can use new function executeVariable() as following: <?php error_reporting(E_ALL); require_once 'dbUtil.php'; $db = new DBUtil(); $sql = $db -> executeVariable("insert into dbtool_schema.test (id, name...

Oracle: Understanding the table user$

Table user$ : SQL> desc user$ Name Null? Type ----------------------------------------- -------- ---------------------------- USER# NOT NULL NUMBER NAME NOT NULL VARCHAR2(30) TYPE# NOT NULL NUMBER PASSWORD VARCHAR2(30) DATATS# NOT NULL NUMBER TEMPTS# NOT NULL NUMBER CTIME NOT NULL DATE PTIME DATE EXPTIME DATE LTIME DATE RESOURCE$ NOT NULL NUMBER AUDIT$ VARCHAR2(38) DEFROLE NOT NULL NUMBER DEFGRP# NUMBER DEFGRP_SEQ# NUMBER ASTATUS NOT NULL NUMBER LCOUNT NOT NULL NUMBER DEFSCHCLASS VARCHAR2(30) EXT_USERNAME VARCHAR2(4000) SPARE1 NUMBER SPARE2 NUMBER SPARE3 NUMBER SPARE4 VARCHAR2(1000) SPARE5 VARCHAR2(1000) SPARE6 DATE Explanation of some columns: CTIME is the date the user was created. LTIME is the date the user was last locked. (Note that it d...

Oracle: How to change datatype VARCHAR2 to CLOB

At the beginning of creation database structure you decided to use datatype VARCHAR2 and that time you thought 4000B should be enough. But later you want to insert more than 4000B, it's time to change this datatype to CLOB. If you don't have data in the table, it's ideal situation and the solution is very easy: SQL> create table test ( 2 id number, 3 name varchar2(50), 4 comments varchar2(4000) 5 ); Table created. SQL> desc test Name Null? Type ----------------------------------------- -------- ---------------------------- ID NUMBER NAME VARCHAR2(50) COMMENTS VARCHAR2(4000) Because there is not direct way, how to modify column from VARCHAR2 to CLOB, we need to modify column in two steps. Steps: - VARCHAR2 --> LONG - LONG --> CLOB SQL> alter table test modi...

Powered by Blogger

Lucia Hustatyova

ADG_REDIRECT_DML in Oracle Active Data Guard 19c

Oracle Release Schedule

Comments

Post a Comment