Not getting head or tails [message #602984] |
Tue, 10 December 2013 11:49 |
|
megamind
Messages: 11 Registered: November 2013
|
Junior Member |
|
|
Hey everyone,
I am new to this forum and perhaps new to programming world.
I work in an organisatin where we use Oracle R12.
I need to extract certain data by queries.
The problem is my department is "Cash Management" and the info I want was never ever wanted or perhaps someone never came across the idea of getting that info from Oracle using Pl/SQL.
The IT personnel are long gone after setting up the Oracle.
The question is how do I create my own queries?
Do I need to learn SQL or PL/SQL for that purpose?
I so, how do I practice before messing with my organizational dastabase(oracle)?
How do I question(query) my oracle database when I dont know the source code used when oracle was configured?
The thing is I want some of my data fetching routines done quickly but got no clue where to go or whom to approach.?
|
|
|
|
Re: Not getting head or tails [message #602999 is a reply to message #602984] |
Tue, 10 December 2013 14:36 |
martijn
Messages: 286 Registered: December 2006 Location: Netherlands
|
Senior Member |
|
|
Yup, the language you use to interact with a database is sql.
retrieving (selecting). inserting, deleting and updating is all done by sql.
So I suppose the first thing you should do is learn some sql. You don;t have to be a "master-guru" to retrieve the basics.
Maybe the first ideas can be learned online. I gues
However, if you are in charge of the database now (I sure hope not for your own sake), you also have to learn the basics of database (Oracle) administration. This I would not pursue online.
Anyway...to directly answer some of your questions:
Quote:The question is how do I create my own queries?
You really should learn sql. Then you have the tool for creating queries in your head.
Quote:Do I need to learn SQL or PL/SQL for that purpose?
Yes.
Quote:I so, how do I practice before messing with my organizational dastabase(oracle)?
You can install oracle on a test system (at home) and create a database. Then you can play around with this database.
(If the goal is learning SQL, you might be faster by installing mysql, and learn the basic sql from there.)
Quote:How do I question(query) my oracle database when I dont know the source code used when oracle was configured?
The data and possible code is separated whitin a Oracle database. You have to be somewhat familiar with the datamodel to be more efficient with retrieving data.
Quote:The thing is I want some of my data fetching routines done quickly but got no clue where to go or whom to approach.?
First things first.
If you don't know how to write SQL you can not expect from yourself to tune or improve SQL.
|
|
|
|
|
|
querying Oracle Financials [message #603377 is a reply to message #603371] |
Sat, 14 December 2013 10:41 |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
megamind wrote on Sat, 14 December 2013 15:10thanks alot folks for your help but how do I know the basic structure of the OF used in my organisation.You can only query a database when you know how its built,I mean table and form structure.How do I get aruound that problem because almost every organisation has OF customized to its particulars.The question is how to understand that tailored structure of OF.
Much obliged, The table stuctures in an EBS R12 database are fully documented in your Electronic Technical Reference Manual. Browse to this URL,
http://etrm.orcle.com
and logon on. Then search for whatever objects you need, and you will see all the table structures with their foreign and primary keys. You mentioned Cash Management: all the Cash Management objects are prefixed with CE. So search for CE% and you will see them all.
On a different matter, you say that the people who did your installation have gone. It is astonishig that your organization has spent vast amounts of money on an EBS implementation, and is now left without support. You have to correct this situation and get a support contract in place with people who understand R12 (my boss would be happy to give you a quote )
--
update: gave this a more meaningful title
[Updated on: Sat, 14 December 2013 10:44] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Querying Cash Management objects [message #603543 is a reply to message #603536] |
Tue, 17 December 2013 04:41 |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
megamind wrote on Tue, 17 December 2013 10:33I want to extract all the records in a table.The table name is "CE_STATEMENT_LINES_V".
How do I accomplish this using PL/SQL Developer.
thanks in anticipation. You have not looked at the Electronic Technical Reference Manual to which I directed you, have you? When you look up this object, you will find the exact SELECT statement that you need. It is there, in black on white. You will also find this:
"Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases."
--update: I'm getting fed up with the stupid title all these posts have. What was "heads and tails" meant to mean?
[Updated on: Tue, 17 December 2013 04:43] Report message to a moderator
|
|
|