Oracle SQL Developer problem – carriage return / backspace / delete button not working – quick fix

Yesterday, the backspace and delete button inside the SQL query editor, all of a sudden, stopped working!
I tried restarting the Oracle SQL Developer, even restarting the computer, but the problem persisted.

I didn’t want to uninstall/re-install the application, so I went on to search the Oracle official forums.
the solution was quite simple.

How to Trim the last character of a string in oracle

Simple way to trim the last characters of a string in oracle .

Example:

I have a list of email address where they are suffixed with ".full"

dash.josh@abcd.com.full
dash.roan@mice.com.full

SQL Query to Find Table Size, Number of Columns and Row Count in Oracle Database

Here is a simple query to find out the table size and number of columns and row count in an oracle database.

If you have access to the dba_* table then you can you them other wise change them to user_* to get the information we need.

How do you know the Database Name

To find out the database name  that you are connected to is very simple.

try executing the below statements : -

select ora_database_name from dual;

select * from global_name;

select sys_context('userenv','db_name') from dual;

Row count for all tables in an Oracle Schema

Two simple ways to get row counts for all the tables in a schema. This can be achived by single sql statement or you can write plsql block.

Fist method:-