[oracle] Forum Topics

Hi all, I'm cerey and I'm excited to join the DaniWeb community! I'm here to learn, share, and connect with others who are passionate about tech. I'm particularly interested in Oracle,SAP but I'm always open to exploring new topics. Looking forward to contributing and learning from everyone here. Thanks for …

In the fast-paced world of startups, solid data pipelines are essential for success. They streamline data collection, enhance decision-making, and improve operational efficiency. By ensuring data consistency and scalability, robust pipelines support real-time analytics and provide a competitive edge. Startups can deliver better customer experiences, ensure compliance, and achieve cost …

I wonder if there is any solution to drop an oracle table trigger using c# windows application project

## Introduction ## When working on Java applications, it is very likely that you will run into JDBC at some point. While you are unlikely to have to work directly with JDBC when using frameworks, it is still important to know how the connection is established and how queries are …

In China, many manufacturers are 'replacing IOE' and are moving closer to open source databases.openGauss is an open source database developed by Huawei itself. Although there is policy support,but ，Oracle has always been ranked first in DB-Engines Ranking. So, do you think openGauss database can replace Oracle database?

The logical objects of databases are generally the same, but there are some differences. Compared to openGause and Oracle, the logical structure and physical structure are not strictly distinguished.So, what are the main logical objects of the openGauss database?

The web application will have a database that consists of millions (over 20mil ... maybe 100mil or more) of hosts (ipv4,ipv6 and domains) and additional data to each host like blacklist, uptime, history, geo data (country, region, city, isp). I could, of course, use other RMDBS system like MySQL, Oracle, …

package sadbinproject; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JOptionPane; /** * * @author Notebook */ public final class admission_panel extends javax.swing.JFrame { /** * Creates new form admission_panel */ public admission_panel() { initComponents(); Connect(); } Connection con; PreparedStatement pst; public void Connect() { …

Hi Sir, I'm trying to use oracle Stored Produce with my login form as below :- package cms is -- 1 => OK, 0 => ERROR function validateUser( username in cms_user.cu_username%TYPE, passwd in varchar2, errmsg out varchar2 ) return number; END; For info , my password is encrypted , so …

Hi Please help I'm getting this error on a perl script DBI->connect using 'old-style' syntax is deprecated and will be an error in future versions at /home/dbadmin/perl/adm_audit_mhs line 43 $dbh = DBI->connect('xe', 'ops$dbadmin', 'm00nwalk', 'Oracle') or die $DBI::errstr; (this is line 43) Thank you in advance

Hello all I am having problem with functions. Always getting Error(7,11): PLS-00323: subprogram or cursor 'EMPLOYEE_EMAIL' is declared in a package specification and must be defined in the package body. My package body. 

Dear sir, i got a TFT device attendance 3.5 inch and iam using SDK 6.2.4.11 iam using windows 10 LTSC Enterprize 64 bit when running , i created a windows service on it when i try to run it, it does not work and cause an error 1053 :Error 1053: …

I am new to Python development with Selenium. I need some clarification regarding Exceptions. In Oracle PL/SQL I was able to create a package, where I used to place all the procedures and functions related to error handling in my app. So, once a error occurs he is propagated from …

I'm studying SQL with Oracle 11gR2 and I'm trying to write sql query to solve this problem. Q. Assuming that campaign's budget is divided by the number of ADs included in the campaign, show the campaign that contains the AD that consumes the largest amount of budget and the campaign …

Dear All, Good Morning! I am facing this issue i tried a lot but not able to find the issue with this function when i call this function i get error Argument not specified for parameter 'LVL' of 'Public Function UL(LVL As String) As String' The code is listed below, …

HI : I WANT THIS BOOK Oracle Privacy Security Auditing: Includes Federal Law Compliance with HIPAA

I have to get an instance of Oracle XE running on my laptop. This is so I can test a plsql package I have been working on at my house. Currently out of the job. I seem to remember when I did this the last time I had to configure …

I need a simple external table definition for preforming loads from FIXED WIDTH files. I don't remember how to do External tables in oracle. This would be a Fixed width, not CSV. I am creating a generator and I need the external table definition.

when i am trying to insert date into the datefield of the oracle then date value are stored in to database but each date value are same like DOB 01-JAN-70 01-JAN-70 01-JAN-70 public class practicdate { JDateChooser dateChooser,dateChooser1; practicdate(){ dateChooser = new JDateChooser(); dateChooser.setBounds(200, 200, 150, 20); getContentPane().add(dateChooser); public void …

CREATE TABLE Peaje ( id_no_pk CHAR(2) NOT NULL, nombre VARCHAR(30) NOT NULL, localizacion VARCHAR(30) NOT NULL, dirrecion VARCHAR(50) NOT NULL, tipo CHAR(1) NOT NULL, municipio_fk CHAR(2), CONSTRAINT Peaje_id_no_pk PRIMARY KEY(id_no_pk) CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)); CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)) * ERROR at line 9: ORA-00907: …

I am currently creating a product lookup system for a project of mine, however from reading around it has come to my attention that an OLEDB connection will not handle the SQL query below as it will not handle more than a simple "SELECT, FROM". Table: tbl_ProductInformation Field: Product_Name CurrentEntry …

iam using oracle11g and jsp ,i have one task there i want use isActive how to use that. i dont know atlease what is isActive please explain.

hai all, i want to know the system user name and password when iam running the web page in jsp to oracle thanks.

Hi all, How to store data in two different tables when we click the button. Suppose I have a 2 tables named as team1 and team2. In table team1 have 2 fields teamid,teamname In table team2 have 3 fields team2id,team2name,teamid here teamid is foreign key. So when i click on …

Hi all, How to store data in two different tables when we click the button. Suppose I have a 2 tables named as team1 and team2. In table team1 have 2 fields teamid,teamname In table team2 have 3 fields team2id,team2name,teamid here teamid is foreign key. So when i click on …

Please, why I got this error(SQL Error: ORA-00907: missing right parenthesis ) whats wrong in my code? CREATE TABLE DomeniuAB(ID_DOMAB NUMBER(10) constraint ID_DOMAB_PK PRIMARY KEY , DENUMIRE VARCHAR2(20) NOT NULL, DETALII VARCHAR2(20) NOT NULL, ISBNAB_CarteAB VARCHAR2(15), CONSTRAINT ISBNAB_FK FOREIGN KEY (ISBNAB_CarteAB) REFERENCES CarteAB(ISBNAB), CNPAB_AutorAB NUMBER(10), CONSTRAINT CNPAB_FK FOREING KEY (CNPAB_AutorAB) …

I'm writing stored procedure with dynamic sql having dynamic table name as, CREATE OR replace PROCEDURE Pr_get_result (p_table_name IN VARCHAR2, p_object_Id IN VARCHAR2) IS p_prop_code VARCHAR2(50) := 'pH'; BEGIN EXECUTE IMMEDIATE 'DECLARE ' || ' TYPE ObjCurTyp IS REF CURSOR; ' || ' v_obj_cursor ObjCurTyp; ' || ' v_stmt_str VARCHAR2(32000); …

plz... some give me the answer for this . this was asked in an interview.

hi all, I am new to Codeigniter, start learning because of one of our customer want the conversion of their some Oracle Forms to web app and I found it is much easier to use CI framework of PHP but one thing I can't connect / work with their Oracle …

Hi, I have installed Oracle 11g (latest version 11.2.0.1.0) on my system. During the installation it didnt ask me to set username or any password. I'm unable to start sql plus because i dont have the username and password. Can anyone tell me what is the default username and password …

The API docs are now found at [ Java Development Kit Version 11 API Specification](https://docs.oracle.com/en/java/javase/11/docs/api/)

Hi Every Body i have a server and a numbers of clients and i when i want to open a page on the clients machine it is open in the server insted of the specified client machine. i am using host to open the required page and i am trying …

Hello Everyone I want to take a backup of the oracle database using c# am using the code below but give this error: System.InvalidOperationException: 'The Process object must have the UseShellExecute property set to false in order to redirect IO streams. any help please????????? System.Diagnostics.Process p = new System.Diagnostics.Process(); string …

Dear Friends, Good Day, I am facing an issue in one of the functions the code is given below if someone can help on this actually this function is supposed to check the work ordewr number if it's nulll then it is suppose to take default value as 4999 and …

Getting an empty drop-down list by the following code. Trying to fetch names from the department table. Using an oracle Database... <label for="department">Department</label> <select class="form-control" name="deptname" id="deptname"> <option selected disabled></option> <?php $dbUser = "..."; $dbPass = "..."; $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=...)(PORT=1521))(CONNECT_DATA=(SID=...)))"; $conn = oci_connect($dbUser, $dbPass, $dbConn); $sql …

hello i have oracle database 10g as my sql server. i didnt use it for over a year and now when i open it the page just closes without any warning or error after entering the username and password. i reinstalled it and the problem is still there. i can't …

Hi Please why I got this error(SQL Error: ORA-00907: missing right parenthesis) whats wrong in my code? CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(5) NOT NULL, path VARCHAR2(100) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ); …

I have two tables. MODELS and AUTOMOBILES. And procedure which export all models with name that user inputs and their price(stored in AUTOMOBILES). create or REPLACE procedure modelzz( VAR_MODEL IN MODELS.NAME_MODEL%TYPE, VAR_PRICE OUT AUTOMOBILES.A_PRICE%TYPE ) as begin SELECT a.A_PRICE INTO VAR_PRICE FROM AUTOMOBILES a join MODELS m on a.MODELS_ID_MODEL=m.ID_MODEL where …

Below program in completly executing but no data was inserted through sqlloader. Inline Code Example Here public class CSVDataLoad { public void runSqlldr () throws InterruptedException { String[] stringCommand = { "bash", "-c", "/usr/bin/sqlldr username/password@sid control=/path/to/sample.ctl"}; System.out.println("SQLLDR Started"); Runtime rt = Runtime.getRuntime(); Process proc = null; try { proc = …

hi i used this simple form which are these..but i want to protect password from oracle database if user enter wrong name and password then not login otherwise login <!DOCTYPE HTML> <html> <head><br> <style> .error {color: #FF0000;} </style> </head> <body style="font-family: verdana, sans-serif;";> <hr /> <div style="width: 77%; height: 300px; …

hi everyone hope you are all well... i am login with userid and password and i want to display there username after login from my oracle database how?

All information related upcoming ERP Cloud systems by Oracle

hi everyone i need help in my query while user login. <?php $username = $_POST["username"]; $password = $_POST["password"]; $con = oci_connect("user","pswrd","db"); if(! $con) { die('Connection Failed'.oci_error()); } $query = "SELECT username, password FROM users WHERE username=$username"; $stmt = oci_parse($conn, $query); $row = oci_fetch_array($stmt, OCI_NUM);; if($row["username"]==$username && $row["password"]==$password) echo"You are a …

hi everyone hope you all are in good. i have query while login form in php with oracle database..... i want to simple login with database html code: <p> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> Username:<br /><input type="text" name="username" size="10" /><br /> Password:<br /><input type="password" name="password" size="10" /><br /> <input …

My requirement is connect to Oracle database from PHP. XAMPP is already installed in my pc. PHP Version 5.5.11 My system configuration is Windows 7, 64-bit operating system. I downloaded 32-bit instantclient-basic-nt-11.2.0.4.0.zip file and then extracted and copied folder into C drive. I gave this folder path in Environment Variables. …

i want to show calendar in php show in image below connected to oracle database table. 

hi everyone i need help in my query which is that: 1.which country name i selected from my dropdown list 2.when i select any country_name its show more info in new page.php like (this selected name show more information about country_name e.g. its captical, and cities through database in new …

( https://i.stack.imgur.com/1LPVk.png ) i mention my link where output show when i press drop-down button then show empty fields but i have values in my sql table link ( https://i.stack.imgur.com/YEopy.png) but it does not execute my values in drop down list..i need help...when i show error it does not dispaly …

I am creating an application that uses NHibernate, an object relational mapper that is a port of the Java Object relational mapper hibernate. Currently I am trying to represent my entities via hibernate xml files. The application I have right now is throwing an error I am thinking may be …

Is it possible to make a web page that takes up responsibility for backing up a web applications tables(Oracle DB, and perhaps SQL server I am trying to be multi db supportive)? Essentially I want to create a database backup script that is kicked off by pressing a button on …