DBA Paradise

The place where DBAs grow

  • Home
  • Database
    • Oracle
    • SQL Server
    • Certification
  • My Courses
  • Personal Growth
  • About
  • Contact
SQLPLUS’ Forgotten Option: COLSEP

SQLPLUS’ Forgotten Option: COLSEP

Database Oracle Oracle
By dianarobete January 19, 2023 Off

Today’s blog post came to my mind, as I am re-writing some scripts, written by others, with tones of concatenations… Continue Reading

What Is the Become User Privilege

What Is the Become User Privilege

Database Oracle Oracle
By dianarobete October 12, 2022 Off

You might be learning something new today, as I did when I ran the DBSAT Oracle utility! In the generated… Continue Reading

Do You Know How To TRIM or PAD Character Strings?

Do You Know How To TRIM or PAD Character Strings?

Database Oracle Oracle
By dianarobete September 12, 2022 Off

Continuing on the blog post series of Single-Row Character Functions, we are going to discuss and learn about the following… Continue Reading

How To Use Character Functions That Manipulate The Case

How To Use Character Functions That Manipulate The Case

Database Oracle Oracle
By dianarobete September 1, 2022 Off

In the single-row functions series, we are going to talk about Character Functions, the ones that manipulate the case. Because… Continue Reading

Useful Examples For DBAs of Single Row Numeric Functions

Useful Examples For DBAs of Single Row Numeric Functions

Database Oracle
By dianarobete August 26, 2022 Off

In the previous post, we started talking about Single Row Functions, which return a single value (row) for each row… Continue Reading

What Are Single Row Functions

What Are Single Row Functions

Database Oracle Oracle
By dianarobete June 20, 2022 Off

Do you remember what the two main categories of built-in functions are in Oracle? These categories are created based on… Continue Reading

READ vs SELECT Privilege

READ vs SELECT Privilege

Database Oracle Oracle
By dianarobete April 14, 2022 Off

Are you aware of the READ object privilege in Oracle? If yes, what was your first thought of it when… Continue Reading

What Is Deferred Segment Creation?

What Is Deferred Segment Creation?

Database Oracle Oracle
By dianarobete April 11, 2022 Off

Did you know that deferred segment creation was introduced in 11.2? Some DBAs might not be familiar with this concept… Continue Reading

What Is The Difference Between Oracle Table And Oracle Segment?

What Is The Difference Between Oracle Table And Oracle Segment?

Database Oracle Oracle
By dianarobete March 17, 2022 Off

DBAs use these two concepts interchangeably: table and segment, more precisely table segment. Why is that? When we think of… Continue Reading

How To Get Historical Row Count In a Table?

How To Get Historical Row Count In a Table?

Database Oracle Oracle
By dianarobete March 12, 2022 Off

Have you been in a situation where you had to prove the row count in a table has changed or… Continue Reading

Posts navigation

1 2 … 21 Next

Proudly powered by WordPress | Theme: Balanced Blog