The Best oracle tutorial and blogs for Beginners and Experts at Moment For Technology

Oracle products are available in multiple versions, each offering different functions. Standard edition 1: The most basic version, including basic database capabilities, licensed only on...

The back-end

Teach you how to build Oracle ADG by DBCA

December 17, 2023

by Joanne Goodwin

No Comments

Oracle Data Guard is a member of the Oracle MAA(Maximum Availability Architecture). STANDBY DATABA is launched from Oracle 7i

The back-end

ORA-12514:TNS:listener does not currently know of service resquested in ……

December 17, 2023

by Karen Roman

No Comments

The orA12514 listener is currently unable to recognize service 2 requested in the connection descriptor. Confirm the IP address and service name when connecting to...

The back-end

Install the Oracle database on Linux

December 17, 2023

by Dr. Nathan Davis

No Comments

I believe you first contact Oracle, mostly in Windows installation, more convenient and quick, basically has been the next step can be installed successfully. However,...

The back-end

Database Interview Questions (developer must See)

December 16, 2023

by Penelope McManaway

No Comments

Stored procedures encapsulate our code (PLSQL, T-SQL) just like functions in our programming language. It was written in a way that we certainly could not...

The back-end

【2021 latest upgrade secret 】 hand in hand teach you how to quickly and safely upgrade Oracle database, package learn package will!

December 16, 2023

by Tiffany Blake

No Comments

Oracle 19C has reached maturity, and Oracle 11GR2 has been discontinued for 20 years, meaning bug patches are no longer being updated. Therefore, upgrading 19C...

The back-end

I wrote more than 4000 lines of Shell script and finally realized the one-click installation of Oracle RAC!!

December 15, 2023

by Arhaan Chowdhury

No Comments

As an IT person, I believe that most of you have used Oracle database, but few of you have ever installed Oracle database, because this...

The back-end

The character set of client server is inconsistent with that of Oracle database

December 15, 2023

by 李懿

No Comments

Problem description: Oracle database character set is a headache, especially some customers use the English character set database, but the client displayed the Chinese character...

The back-end

Oracle Database installation package: Oracle Database installation package: Oracle Database installation package: Oracle Database installation package

December 15, 2023

by Rebecca Davies-Grant

No Comments

With the upgrade of Oracle version, the previous version is no longer supported, which means that the official website no longer provides a way to...

security

Interpretation products | agile version of the database “One-stop” work style to quickly build enterprise whole scene database management platform

December 15, 2023

by 彭雅芳

No Comments

Summary: Gartner's report shows that 75% of the database is expected to use cloud database by 2022. At the same time, IDC estimates that the...

sql

Oracle automatic task

December 15, 2023

by Ryan Chaudhary

No Comments

{code... }

sql

Oracle looks at blocking (lock) information

December 15, 2023

by 沈怡安

No Comments

1, output only the blocked and the blocked, and the blocking time >; = 60 s part; 2, CHR (10) newline output, sqlplus command line...

linux

(Oracle) HugPage Size calculation script

December 14, 2023

by Linda Benson

No Comments

The HugePage calculation requires SGA to take effect, and the memory {code... }

sql

Oracle checks resource consumption in the last 60 seconds

December 14, 2023

by Stewart Pugh

No Comments

Specify the time range as: ash.sample_time >; = SYSDATE -60/24/60/60), set to / {code... }

The database

Modify the sequence cache in bulk

December 14, 2023

by Jose Armstrong

No Comments

{code... }

sql

Oracle statistics

December 14, 2023

by Spencer Pham

No Comments

{code... }

sql

(Oracle) 2PC_PENDING for SQL (distributed lock)

December 14, 2023

by Dr. Nathan Davis

No Comments

Focusing on immediate processing of the problem, only generate the processing command, COMMIT; Must perform a related cause search to find their own {code... }

sql

Forwarding – When an Oracle database problem occurs, these ten scripts help you quickly locate the cause

December 14, 2023

by 朱淑娟

No Comments

"Hello, Mr. Li!" "Xiao Zhang, look at the ERP database quickly, the application can't be opened again!" "Yes, right away." Xiao zhang took out the...

sql

Batch generation sequences reset SQL

December 14, 2023

by Tejas Chaudhry

No Comments

Product iterations, using the same library, or just cleaning up data after migration, resulting in a sequence of billions, may have some impact, so reset,...

The database

(Oracle 11g) Bulk generate move table and rebuild index statements

December 14, 2023

by Neelofar Loke

No Comments

In 12C, some parameters have been changed. The Move table supports Online, but no production attempts have been made. {code... } Write SQL, record for...

oracle

Install Oracle 12c under Linux

December 14, 2023

by Emily Harris-Stubbs

No Comments

Mount/MNT/centos-7-x86_64-dvd-1708. ISO: mount/MNT/centos-7-x86_64-dvd-1708 Mount -t ios9660-o loop/MNT/centos-7-x86_64-dvd-1708. Iso /oraclehome (L not 1) CD /etc/yum.repos.d/ Enter the file rm-f * to delete the header...

The database

Oracle —- window function (1)

December 14, 2023

by Leslie Allen

No Comments

Partition by is similar to group by. We usually call group by a group, while partition by is called a partition.

oracle

date format picture ends before converting entire input string

December 14, 2023

by 王志偉

No Comments

SQL > insert a record into an Oracle table; } insert failed SQL statement: {code... SQL > insert a date into a table; insert a...

The database

Oracle —- window function (2)

December 14, 2023

by Valerie Bishop

No Comments

Today, I'll show you how some of the RANK functions use window functions. {code... Select * from scott.emp where deptno = sal; select * from...

python

Based on Oracle Flask project (3) — generating reports

December 14, 2023

by Aarav Chaudhuri

No Comments

Once, because I was not familiar with SQLAlchemy, I stubbornly abandoned it and directly introduced the native CX_Oracle to generate reports, but after a lot...

mysql

Oracle12C In Memory is a good way to improve performance.

December 14, 2023

by Keith Lopez

No Comments

The In Memory option In Oracle 12c improves query performance by allocating separate In Memory areas In the SGA and using column compression for data...

security

Version 2.9.4.3 of Dataphin, an intelligent build management platform, was released

December 14, 2023

by 成雅慧

No Comments

Description: Dataphin has released V2.9.4.3, an updated version of the product. The product features and user experience have been optimized and improved to provide users...