[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

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

Hi Guys,

I'm having good fun doing my first web services and learning java, but I need your help ( again ).

Just to recap what I've done so far
1. using eclipse java ee I created Dynamic Web Project
2. I imported  a wsdl file to the project and generated web services (Top down Java bean ones)
3. I can take parameters from received requests and loaded them to Oracle database, which connection details are stored in config.properties file ( this pretty much works :) )

I've just been asked if it would be possible to grab a SOAP body and load it to an oracle table.

This is my class where web services requests are being consumed

/**
 * BasicHttpBinding_MS_aaa_WMS_ServicesImpl.java
 *
 * This file was auto-generated from WSDL
 * by the Apache Axis 1.4 Apr 22, 2006 (06:55:48 PDT) WSDL2Java emitter.
 */

package com.bbb.WebServices;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

import org.datacontract.schemas._2004._07.Dft_aaa_WebService.WMS_RequestData;
import org.datacontract.schemas._2004._07.Dft_aaa_WebService.WMS_RequestInfo;

public class BasicHttpBinding_MS_aaa_WMS_ServicesImpl implements com.bbb.WebServices.MS_aaa_WMS_Services{
    public com.bbb.WebServices.SendPing_WMSResponse sendPing_WMS(com.bbb.WebServices.SendPing_WMS parameters) throws java.rmi.RemoteException {
try {
			
			Connection con = null;
			

Open in new window

0
Starting with Angular 5
LVL 12
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Hi,

We will undergo a migration from Oracle to MariaDB and as now I found out that there will be column type different in both DB, so comparing column type is not making sense at all, usually AFTER migration from Oracle 10gR2/12c to MariaDB 10.3.x, what is the best way to compare and make sure that the migration is ok?
0
I am using Contains function for text search in a table in a ORACLE database. see example below.

I'm passing text_param as a ORACLE parameter. I have a input text field in my web page, for users to input any text they want to search.
the query works, except when I enter characters like $ or * , in the text field and pass it to the parameter. I get the exception below.

how do i make sure I cover such use case. do I restrict user to input search characters but how do i know which characters to look for?

SELECT title, issue_date from details WHERE CONTAINS(text_data, text_param, 1) > 0

exception ------------------------------------------------------

Oracle.DataAccess.Client.OracleException : 'ORA-29902: error in executing ODCIIndexSTART() routine
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 2
0
I have dynamic SQL that I am executing in a PL/SQL block. The problem I am facing is when I get a NO_DATA_FOUND error in the first one, it hits the EXCEPTION block directly. When I get the first NO_DATA_FOUND, I want to continue to the second dynamic SQL and so on.

Idea1: I can go to the EXCEPTION block, catch the NO_DATA_FOUND error and code there but it seems convoluted to me. I can create a label and use GO TO the label from the EXCEPTION block but how do I distinguish between the NO_DATA_FOUND errors in the first and second statement.

Idea2: I can put each dynamic SQL within a block and put a EXCEPTION in the block something like this:

begin
          execute immediate dynamiSQL;

exception
         when no_data_found then
                  null;
end;

I would like to hear some better ideas.

------------------------------------------------------------------------------------------------------------------------------------------------------
declare
vOne varchar2(1) :='';
vCriteria := 'A';

begin
         execute immediate 'select Col1 from Tbl1 where Criteria1= ' || vCriteria  into vOne;

         if trim(vOne) is null then
               execute immediate 'select Col2 from Tbl1 where Criteria2= ' || vCriteria  into vOne;
         end if;

         if trim(vOne) is null then
               execute immediate 'select Col3 from Tbl1 where Criteria3= ' || vCriteria  into vOne;
         end if;

         if trim(vOne) is null then
    …
0
How to fully allocate RAM without ever experiencing RAM paging?
I was looking at - http://www.dba-oracle.com/art_dbazine_ram.htm

The database continuously receiving below error - flndb46p2.
ORA-04031: unable to allocate  bytes of shared memory ("","","","")

These are the current memory setting on the server and DB side.

SQL>  select instance_name,status,to_char(startup_time,'DD-MON-YYYY HH24:MI') startup_time from v$instance;

INSTANCE_NAME    STATUS       STARTUP_TIME
---------------- ------------ --------------------------
flndb46p2        OPEN         05-MAY-2018 21:16

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 3G
sga_target                           big integer 3G

flndb46p2@ltdi31cdz:/odb/ods01/orabin/diag/rdbms/flndb46p/flndb46p2/trace>free -g
             total       used       free     shared    buffers     cached
Mem:            47         45          1         26          1         29
-/+ buffers/cache:         14         32
Swap:           35          6         29
flndb46p2@ltdi31cdz:/odb/ods01/orabin/diag/rdbms/flndb46p/flndb46p2/trace>cat /etc/sysctl.conf |grep huge
vm.nr_hugepages=17283

flndb46p2@ltdi31cdz:/odb/ods01/orabin/diag/rdbms/flndb46p/flndb46p2/trace>grep Huge /proc/meminfo
AnonHugePages:         0 kB
HugePages_Total:    2054
HugePages_Free:        0
0
I need to get Microsoft SQL Server Mgmt Studio to connect to an Oracle database. I am having issues w/ getting the Oracle data access component -    OraOLEDB.Oracle available and showing on the SQL client under Linked Servers and Providers. Ticket-Details.docx
0
Hi,
I have partition database like below  i am running query like below to get latest
partition year can i make it dynamic so that i just pick latest partition every time instead
of hard code value TEST_Y2018


select  *
  from  test PARTITION (TEST_Y2018)


PARTITION TEST_Y2017 VALUES LESS THAN (TO_DATE(' 2018-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    LOGGING
    NOCOMPRESS
    TABLESPACE TEST_Y2017_DATA
    PCTFREE    10
    INITRANS   1
    MAXTRANS   255
    STORAGE    (
                INITIAL          1M
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
               ),  
  PARTITION TEST_Y2018 VALUES LESS THAN (TO_DATE(' 2019-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    LOGGING
    NOCOMPRESS
    TABLESPACE TEST_Y2018_DATA
    PCTFREE    10
    INITRANS   1
    MAXTRANS   255
    STORAGE    (
                INITIAL          1M
                NEXT             1M
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
               ),  
  PARTITION TEST_Y2019 VALUES LESS THAN (TO_DATE(' 2020-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    LOGGING
0
Hi Expert,

Could anybody please guide here how to user Oracle AQ functionality using Oracle provided pkg,  I don't know exactly which package has this functionality.

You suggestion is really appreciate.

Thanks,
Mihir
0
Hi All Experts,

I want an oracle pl/sql scripts/procedure/package anything compatible to oracle 12c, which can help me to send the result of a query over my email.

For example: Select * from employee;

1. If this query returns any rows, the count will be emailed to a@b.com
2. The result of this query will stored in excel and the excel file will mailed to a@b.com
0
extra space replacing value when using             text_io am having vdate value replace by space
V_DCN := 	'ZD'||V_MOE_CODE||rpad(nvl(V_DATE,' '),5,' ')||'18'||V_DCN_SERIAL_NO;

Open in new window

i have attch the full code and file
INT.REQ-5605-18340.TXT
sapace12.jpg
0
HTML5 and CSS3 Fundamentals
LVL 12
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Hi Experts

I'm in a mixed group of SQL Server DBA's and developers and Oracle DBA's and developers from different business units that have only rarely interacted with each other in the past.   Our upper management has given us a fuzzy directive to cross-train ourselves between Oracle and SQL Server, and for the most part everyone in the group is doing a twelve-way blank stare on what the expectations are.

Question:  Does anyone have any references to existing Oracle and SQL Server cross-training?  Videos, published articles, blog posts..

This question is not..
A request for info on which is the better database.
An invitation for anyone to do a Google search and post the first thing that's returned, and then can't speak to it.

Things I've stumbled across so far..
PluralSight - Advanced SQL Queries in Oracle and SQL Server
MVA - SQL Server 2016 Essentials for the Database Administrator
Udemy - Data Migration: Database Migration from MS SQL to Oracle DB

Thanks in advance.
Jim
0
Hi Expert,

I have a package which was perform sometimes great/poor, attached file is the package .

Sorry for attachment of large set of code.

If possible please guide me with quick bad written line!

Thanks,
Mihir
pkg_to_tune.sql
0
SELECT  department, COUNT (Professor_Name ) from SALARIES  GROUP BY Department

how to write above query without using GROUP BY

please advise
0
SELECT  Professor_Name , Department , Salary FROM SALARIES GROUP BY (Department ) ORDER BY MAX (Salary ) DESC  LIMIT 1
how to modify above query to return either top 3 or bottom 3 earners only ?
please advise
0
SELECT  Professor_Name , Department , Salary FROM SALARIES GROUP BY (Department ) ORDER BY MAX (Salary ) DESC  LIMIT 1

how above different from below
SELECT  Professor_Name , Department , Max(Salary) FROM SALARIES GROUP BY (Department )

i above query returning only one department instead i need highest salaries of each department. how to fix it
please advise
1
SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY SUM(Salary) DESC LIMIT 1;

SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY AVG(Salary) DESC LIMIT 1;

SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY Salary DESC LIMIT 1;

how above three queries are different? please advise
0
SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY SUM(Salary) DESC LIMIT 1;

i am not clear on above query.

when we use ORDER By

please advise
1
https://www.youtube.com/watch?v=IVMfDpCGwK4

as given above video when to use Distinct and when to use group by seems bit does same job
please advise
any good links resources appreciated
0
SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY SUM(Salary) DESC LIMIT 1;

does sum always goes with group by?
what is meaning of above query
any other such rules in sql?
where i can find all the rules?

how sql different from different databases?
any tool that converts from one database to other database?
0
PMI ACP® Project Management
LVL 12
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

SELECT DISTINCT(COALESCE(First_Name, '') || ' ' || COALESCE(Last_Name, '')) AS Name FROM CHECKED_OUT;

what is the meaning off caoalesce as above when we use it?
please advise
any good links, resources appreciated
1
SELECT DISTINCT (First_Name ), distinct (last_name) FROM  CHECKED_OUT WHERE  Book_ID  not null


why above query not working
can i put one distinct for both first name and last name
are these queries case sensitive like unix?

please advise on any good links and resources, videos around this to master
0
SELECT  First_Name , Last_Name  from CHECKED_OUT INNER JOIN  BOOKS  WHERE CHECKED_OUT .Book_ID=BOOKS.Book_ID AND  First_Name ="Justin " and Last_Name ="Lee"

SELECT  First_Name , Last_Name  from BOOKS INNER JOIN  CHECKED_OUT WHERE CHECKED_OUT .Book_ID=BOOKS.Book_ID AND  First_Name ="Justin " and Last_Name ="Lee"


SELECT  First_Name , Last_Name  from BOOKS INNER JOIN  CHECKED_OUT WHERE BOOKS.Book_ID=CHECKED_OUT .Book_ID AND  First_Name ="Justin " and Last_Name ="Lee"


SELECT  First_Name , Last_Name  from  CHECKED_OUT INNER JOIN  BOOKS WHERE CHECKED_OUT .Book_ID=BOOKS.Book_ID AND  First_Name ="Justin " and Last_Name ="Lee"

all above 4 queries means same thing?


does it matter putting before after for the names and also for the conditions like equality also near INNER JOINs ?

not sure why i am not getting results


how below is different which gives correct results
SELECT Book_Name FROM CHECKED_OUT INNER JOIN BOOKS ON CHECKED_OUT.Book_ID = BOOKS.Book_ID WHERE First_Name = "Justin" AND Last_Name = "Lee";
please advise
0
SELECT  COUNT (*) from SALARIES  WHERE salary>(SELECT  MIN (Salary ) from SALARIES )


somet reason above i am getting wrong count
instead of 6 i am getting 15

please advise on how to optimize and make it better
0
SELECT Professor_Name, Salary FROM SALARIES WHERE Salary > (SELECT MIN(Salary) FROM SALARIES) * 4;
why above query not working
please advise
0
I have a PLSQL procedure that embed with HTML code. How can I use this procedure to print in JSP? Can provide sample code?
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.