Oracel Database: Delete all user objects (Tables, Views, Procedures, Functions, Sequences, Types, Packages)

Hi friends,

I have come across a situation, where I need to delete all the user objects i.e. Tables, Views, Procedures, Functions, Sequences, Types, Packages.

Please find the link below for the SQL script, which does the job for you.

It's my public GitHubGist URL, where anyone can share the code snippets.

https://gist.github.com/psrdotcom/b61f8b401d4992428ecd8fb8225436c4

Advantage:
You can delete the user after deleting all user objects by logging into SYSTEM user.

Please send your review and feedback to psrdotcom@gmail.com

Add (append or prepend) text along with excel functions/formula in a single cell

Hi friends,

Today I have come across a situation where i want to have the cell to descriptive and to have summation of some cells. I have got information on how to do it. Please find below

Input Data:

3

4

2

I want a cell to be on top those with description and summation value

Expected output data:

Sum = 9

3

4

2

To get the output, I have written the following function

Syntax:
="Text"& function

Example:
="Sum = "& SUM(A2:A4)

We can append and prepend the text to excel function to combine text and numbers as well.

Please send your comments and feedback to psrdotcom@gmail.com

Finding IP address to MAC and vice versa on same network (subnet) or different subnet which is reachable by ping

Hi all,

After long time I got a chance to write the blog.

 

This time it is related to networking.

 

Finding out which all the system up on the network

Syntax

cmd> nmap –sP < regex IP >

Example

cmd> nmap –sP 192.168.1.*

 

Finding MAC address of a device which is connected in same network

Syntax

cmd> ping <broadcast address>

cmd> arp –a [ <IP address> ]

 

Example

cmd> ping 192.168.1.255

cmd> arp –a –> Gives all the IP address and MAC address in the same subnet network

cmd> arp –a 192.168.1.25 –> Give the MAC of the specified IP address

 

arp –a : Lists all the IP addresses which are recently got into network with its MAC addresses

 

Finding MAC address of a device which is connected in same network but different subnet

Syntax

nbtstat –A <IP address>

Example

nbtstat –A 192.168.2.45

 

Please send your comments and feedback to psrdotcom@gmail.com