Contact US

Keep in touch

Saudi Arabia

Support@mostafaelmasry.com
(+966) 543 990 968

don t hesitate to contact us we will answer you in 24 hours

sqlnet.ora file in Oracle June 17, 2021

I will explain sqlnet.ora file in Oracle in this post. sqlnet.ora file in Oracle The sqlnet.ora file is very important file for database server and client machines, because it includes the profile configuration file ( tracing options, encryption, route of connections, external naming parameters etc). Database server can be configured with access control pa […]

Mehmet Salih Deveci

Pgbackrest restore time target June 17, 2021

Hello friends today Pgbackrest restore time target cat /etc/pgbackrest.conf pgbackrest info pgbackrest archive-get –stanza=test After doing the pre-run checks, we should get the –stanza name from pgbackrest.conf. In addition, before the backup-restore we made, the existing DB can be backed up as dumpall. pg_dump test -f backup_.sql pg_dumpall -f backup_all.s […]

tayfun inam

NEXTVAL and CURRVAL function in Oracle June 17, 2021

I will explain NEXTVAL and CURRVAL function in Oracle in this post. NEXTVAL and CURRVAL function in Oracle You need the unique sequential values in the database for the SQL and PL/SQL Codes. The sequence is created for this purpose in the database. Oracle Sequence object has 2 important function like … The post NEXTVAL and CURRVAL function in Oracle […]

Mehmet Salih Deveci

SQL*Plus Set Commands in Oracle June 17, 2021

I will explain SQL*Plus Set Commands in Oracle in this post. SQL*Plus Set Commands When you use the SQL*Plus tool, you need to use SET Commands to suppress the output from the script. SET Commands are used to put into shape in terms of line size, page size and etc.. When you use the … The post SQL*Plus Set Commands in Oracle appeared first on IT Tutorial. […]

Mehmet Salih Deveci

UTL_FILE FOPEN in PL/SQL June 16, 2021

I will explain UTL_FILE FOPEN in PL/SQL in this post. UTL_FILE in Oracle UTL_FILE package is used to restricted version of operating system stream file I/O in PL/SQL Programs that can read and write operating system text files FOPEN function of UTL_FILE You can open the operating system file in the … The post UTL_FILE FOPEN in PL/SQL appeared first […]

Mehmet Salih Deveci

Share this:

Like this: