Oracle Database

79K

Solutions

26K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Share tech news, updates, or what's on your mind.

Sign up to Post

Below is my code, but

declare

  l_max_unitboundaryid    number;

  procedure p_add_data
  (
      p_unitcode          LOAD_UNITS_DATA.unitboundary.unitcode%type
    , p_dlsornts          LOAD_UNITS_DATA.unitboundary.dlsornts%type
    , p_lowdesc           LOAD_UNITS_DATA.unitboundary.lowdesc%type
    , p_dls_meridian      LOAD_UNITS_DATA.unitboundary.dls_meridian%type
    , p_dls_range         LOAD_UNITS_DATA.unitboundary.dls_range%type
    , p_dls_township      LOAD_UNITS_DATA.unitboundary.dls_township%type
    , p_dls_section       LOAD_UNITS_DATA.unitboundary.dls_section%type
  )
  is
  begin
    l_max_unitboundaryid  :=  l_max_unitboundaryid + 1;

    insert into LOAD_UNITS_DATA.unitboundary
    (
        unitboundaryid
      , unitcode
      , dlsornts
      , lowdesc
      , dls_meridian
      , dls_range
      , dls_township
      , dls_section
    )
    values
    (
        l_max_unitboundaryid
      , p_unitcode
      , p_dlsornts
      , p_lowdesc
      , p_dls_meridian
      , p_dls_range
      , p_dls_township
      , p_dls_section
    );

  end p_add_data;

begin
  --keep a copy of existing table before changes applied
  execute immediate 'create table LOAD_UNITS_DATA.unitboundary_bkup_' || to_char(sysdate, 'ddmonyyyy') || ' as select * from LOAD_UNITS_DATA.unitboundary';

  select
    nvl(max(unitboundaryid), 0)
  into
    l_max_unitboundaryid
  from
    LOAD_UNITS_DATA.unitboundary;
*******I want to add …
0
Should you be charging more for IT Services?
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Hi Team,

I need info on how the below analytical functions work or calculate values .
Cume_DIST-- calculates the value for each row in a table , what formula it uses to derive the percent rank
PERCENT_RANK -- calculates the value for each row in a table , what formula it uses to derive the percent rank
NTILE  - how ntile calculates the number of rows for each bucket
0
Hi,
Where can I get recent sample questions and answers for Oracle exam: 1Z0-071 - Oracle Database SQL.

I don't mind having it from a pay site so long as I can be assured they can help to pass it.


Thanks
0
I'm using the following Oracle SQL and receive ORA-00921: unexpected end of SQL commandORA-00921: unexpected end of SQL command - on WL.C_CREATED_DATE = (select max(WL.C_CREATED_DATE)
I'm trying to select the latest Create dates. Thanks

Select Distinct

A.C_ALJ_APPEAL_NUM as "OMHA Appeal No."
,FO.C_FIELD_OFFICE_NAME as "Field Office Name"
,p.Last_name || ', ' || p.First_name as "ALJ"

,TO_CHAR(coalesce(WL.C_CREATED_DATE,WL.C_CREATED_DATE ), 'MM/DD/YYYY') as "Assign Date"

,WL.C_ACTION as "Action"
,WL.C_TO_STATUS as "To Status"
,Case
When WL.C_TO_STATUS = 148 Then 'ALJ Assigned' Else 'NA' End Status

From
T_APL A


Left outer JOIN T_APL_WORKFLOW_LOG WL ON A.ID = WL.ID_BASE

Left outer join T_RF_STATE WF on A.C_WORKFLOW_STATE = WF.ID

Left outer join T_ALJ T on T.id = a.C_ALJ_TEAM
Left outer join T_ADJUDICATION_TEAM_TYPE TT on T.c_Team_type = tt.id
Left outer join ETK_USER U on U.USER_ID = T.C_TEAM_SUPERVISOR
Left outer join ETK_Person P on p.PERSON_ID= u.PERSON_ID
Left outer Join T_FIELD_OFFICE FO On A.C_FIELD_OFFICE = FO.C_FIELD_OFFICE

Where
 a.C_ALJ_TEAM is not null
and WL.C_TO_STATUS = 148
AND WL.C_CREATED_DATE = (select max(WL.C_CREATED_DATE)

Order by
A.C_ALJ_APPEAL_NUM 

Open in new window

0
Can anyone share a sample full contents of recommended / hardened settings
of postgresql.conf ?

What's indicated in CIS benchmark for Postgresql 10 is unclear & in bits & pieces;
some of the extracts from the benchmarks are posted below:

- configuration file enumerates all tunable parameters and even though most of them are
commented out it is understood that they are in fact active and at those very same
documented values.

- shared_preload_libraries = 'pgaudit'
OR
shared_preload_libraries = 'pgaudit,somethingelse'

- $ vi ~postgres/10/data/postgresql.conf
# load set_user libs before anything else
shared_preload_libraries = 'set_user, other_libs'
0
Hello Experts,
I am facing an issue while exporting one schema which is taking huge time without any rows.

Command used:
exp username/password@instance file=user_name.dmp log=username_exp.log GRANTS=y CONSTRAINTS=y  ROWS=n statistics=none

Open in new window



Cannot use data pump as directory access to servers are restricted.
0
Hello,

I'm trying to make this Crystal Report like the Excel report.  I'm having trouble with making it like the Excel report.

I've attached both files...  Thanks for your help.

JoelEE.xlsx

LG.rpt
0
I have following Oracle Tables .
 TB_Instruments
    ID
    ModelAt1
    ModelAtt2
    ……..  More fields

TB_PipeControl
   ID
   ObjectID
   SpecDiameter
   PipingPort  
   ……..  Other fields

Sample Values
   TB_Instruments
     ID     ModelAt1     ModelAt2
     111         100                200
     214          123                243

TB_PipeControl
   ID   ObjectID     SpecDiameter   PipingPort    
    1     111                 4                           1
    3      214                3                           1
    4      214                2                           2
 

I need a query that brings, for a given id ,  all  TB_Instrument fields  and all the Specdiameters and PipingPort  for the given id - all in a single row (probably a pivot )
  But as you can see , for a given object ID , there could be  1 or more piping ports , so that need to be dynamically  

I am looking to get the query  which will give results as below  
ID   ModelAt1   ModelAt2  SpecDia1   SpecDia2
111   100               200            4
214   123               243             3                   2
0
Why is Oracle 12c db installation stuck at 91%?
I have added a screen capture of the installation information on UI.
Kind regards
Erreur-Oracle-Issue.PNG
0
hi,

I am reading:

https://www.oracle.com/technetwork/testcontent/jdbc-ch5-131209.pdf

https://docs.oracle.com/database/121/JJDBC/oraperf.htm#JJDBC28767

for Oracle prepared statement.

and I do not understand what it means as it says:

Starting from Oracle Database 12c Release 1 (12.1), Oracle update batching is deprecated. Oracle recommends that you use standard JDBC batching instead of Oracle update batching.

Open in new window


when I check standard JDBC batching it says:

The Oracle implementation of standard update batching does not implement true batching for generic statements and callable statements. Even though Oracle JDBC supports the use of standard batching for Statement and CallableStatement objects, you are[b][u] unlikely[/u][/b] to see performance improvement.

Open in new window


so in order to use a  REAL batch mode for PL/SQL prepare statement, what should I do ?

or it means must be handle in java library when calling:

...
Statement stmt = conn.createStatement();

stmt.addBatch("INSERT INTO emp VALUES(1000, 'Joe Jones')");
stmt.addBatch("INSERT INTO dept VALUES(260, 'Sales')");
stmt.addBatch("INSERT INTO emp_dept VALUES(1000, 260)");
...

Open in new window


?

then it still related to prepared statement ?
0
Announcing the Winners!
LVL 13
Announcing the Winners!

The results are in for the 15th Annual Expert Awards! Congratulations to the winners, and thank you to everyone who participated in the nominations. We are so grateful for the valuable contributions experts make on a daily basis. Click to read more about this year’s recipients!

is there a easy way of writing the below query
in the below query MAX (SIGN (act_qty) is creating an issue
0
hi,

I ask this :

https://www.experts-exchange.com/questions/29148979/MariaDB-coding-standard.html

and

https://www.experts-exchange.com/questions/29148737/MariaDB-SQL-standard.html

before on MariaDB. how about for oracle 12c or 19c, any good URL for me to reference ?
0
I have a oracle table in which a column has image stored in BLOB datatype. Image types stored are TIFF,JPG,GIFF etc . I want to move data from this table and insert into another table with a BLOB column but i want to convert all images to only JPEG format and i want to compress the image size to 20KB and store in new table.

Please advise how to achieve this using some Oracle plsq program
0
We are looking at a used Dell MD4310 Powervault to use as the storage array for a 2 node Oracle RAC setup. Will a Powervault work for setting up ASM and be accessible from both nodes? It looks like it only has SAS connectivity (2 cards). If thats the case I'm not sure how/if it would work.
0
I am working on creating a conceptual model based on the business requirement document. Plan to use sql server as a backend (agreed db has nothing to do with conceptual model).

Can you please suggest  some tools which can help me to build the model quickly.
0
empld  code     amount  effdt
 
21            123     21          jan-10-2011
21            123     10         jan-12-2018
21          231       10         feb 12-2019

I have sql as below

select sum(amount),
max(effdt)
from table aa
group by
emplid
code

result are
empld  code     amount effdt
 
21            123     31        jan-12-2018
21          231       10        jan-12-2019

I need to write functional spec i have put below words please let me know if that make sense for non technical person.

Return sum of amount associated with emplid and code
and
Return max of effective date associated with emplid and code
0
What is the difference between Oracle Data Guard & Oracle Active Data Guard ?
0
Help, I have a problem and I don't even know where to start:

Write a PL/SQL procedure, parse_name, which accepts a string representing names and returns the first name, the
last name, and the title. The first name and last name returned from the procedure should be in upper cases while the title
returned should presever the orginal case. The input name string is in one of the following two formats:
FIRST_NAME LAST_NAME TITLE
LAST_NAME, FIRST_NAME TITLE

The first format depicts that the name string starts with a person’s first name and last name with a space in between, followed by
a space, and then the title of the person. On the other hand, the second format states that the name string starts with a person’s
first name, followed by a comma and a space, and then the last name suffixed with the title with a space before it.

The following are examples of valid name strings conforming to the formats:
1) Jane Doe Ms.
2) Doe, Jane Ms.
Your procedure should return JANE for first name, DOE for last name, and Ms. for title for the above two input strings.

Also, the following are examples of valid name strings conforming to the formats:
1) Jane Doe MS.
2) Doe, Jane MS.
Your procedure should return JANE for first name, DOE for last name, and MS. for title for the above two input strings.

Your procedure should generate exceptions if any one of the three components of the input name string is missing. Further, a
message should be printed indicating that the …
0
How do I generate a QR code in APEX 5.0, I know very little about apex.
Thanks
0
Python 3 Fundamentals
LVL 13
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Hello,

To begin with, I am new entrant into Oracle SOA technology.

In the current SOA 12c production environment hosted on Windows server we have 2 node configured with High availability. Architecture looks like

Admin Server DHQAPP132
soa_server1 DHQAPP132  Listen Address DHQAPP132
soa_server2 DHQAPP129  Listen Address DHQAPP129

I could see there is Oracle SOA installation on both servers hosted on the D drive of app132 and app129

Requirement : Add one more soa server into the mix with high availability. i.e soa_server3.
We are planning to first test this in lower environment.

As I am new into this technology, can your advise the following
a) Configuration steps to extend another server

Regards
Thomas
0
how to schedule monitoring of invalid objects in oracle via oracle scheduler.
what i mean is fx. running (select objet_name, object_type, status from user_objetcs where status = 'INVALID')
then running this statement every 15 min 7 days 24 hours.
or if there is an more effective method to monitor all package with error log?
0
we use Payara on Centos 7 Java8 with Oracle. We have enabled the JDBC cache. Now we get the ORA-01438 error. If we turn off the cache we don't get the error anymore, the application is very slow. Does anyone have the experience for this constellation?
This the Parameter.
<protocol name="http-listener-1">
   <http max-connections="500" timeout-seconds="60" default-virtual-server="server">
        <file-cache enabled="true" max-age-seconds="3600"></file-cache>
   </http>  
</protocol>

Open in new window

0
Oracle Database  - Correct privileges.

Hi,

I was hoping someone could help with with some questions around privileges.

I have a program that creates views on the fly.  The names of the views change for a number of reasons.  I have a user that I want to be able to select on any view that has been created in that particular schema.

I've been granted create any view.  So I seem to be able to create them but not select from them.


thank you,
0
Hi expert.
I have Oracle 11g r2 version on Windows.
I want to open the enterprise manager.
What kind of settings do I have to make?
ı don't work the enterprise manager.
thanks
0
I install oracle 12C client and try to connect to oracle database in server.
from oracle-developer error:
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection

And tnsping from my local says:
TNS-12535: TNS:operation timed out
how to resolve this issue.
my tnsnames.ora entry is:
"name" =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL= TCP)(Host= ip_address )(Port= 1521))

    (CONNECT_DATA = (SID = "database_name"))

  )
0

Oracle Database

79K

Solutions

26K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.