Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where do I begin when it comes to SQL and Oracle?

New2SQLWoahJan 15 2020 — edited Jan 17 2020

Forgive me for having the most basic question, however, I am brand new to using SQL.

I am curious how to find out which tables are available to query in my system for the HCM product. Is there a query I can enter in BI that will give me a list of all the tables that we are using currently?

From there, I would also be interested in knowing the names of all the columns within these tables so that I have that information readily availably for querying.

Lastly, when I am transacting within 'Person Management', is there a way to determine what the name of a field would be if I wanted to report on it? For instance, I enter gender on a new employee and know that in BI that field would be called 'Gender_Employee' (making that up).

This post has been answered by HolgerH on Jan 17 2020
Jump to Answer

Comments

So your primary desire is to copy and paste? Have you tried the "Copy Selected Rows" button? If so, how would you like it to behave?
Also, I assume you have tried saving the data as CSV? Then you can literally open it in Excel.

User_ZZQ0F

Yes, I would like to have a possibility of copy and pase but only selected part of result (ex. only one column)

1 - 2

Post Details

Added on Jan 15 2020
14 comments
379 views