1,488 Topics
 | |
 | 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 |
| | 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? |
| | 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 … |
| | 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 … |
| | HI : I WANT THIS BOOK Oracle Privacy Security Auditing: Includes Federal Law Compliance with HIPAA |
| | 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 … |
| | 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. |
| | 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 … |
| | 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 …  |
| | 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 … |
 | 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 … |
 | 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; … |
| | i have a two menu bar option which are home and my account after login my user and pswd its show home page but when i change home to my account page its show message below and logout Notice: Undefined index: user in folder\myaccount.php Notice: Undefined index: pswd in folder\myaccount.php … |
| | 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 |
| | i want to display my image from a folder but its not work what i change in code to work <?php $dir_path = "/xampp/htdocs/image/"; $extensions_array = array('jpg','png','jpeg'); if(is_dir($dir_path)) { $files = scandir($dir_path); for($i = 0; $i < count($files); $i++) { if($files[$i] !='.' && $files[$i] !='..') { // get file name …  |
| | 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 … |
| | |
| | ( 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 …  |
| | Hi All, I am working on Oracle 11.2.0.3. and my requirement is, I have a table in Development(Dev) called " Dev_EMP". Have created Synosym for "Dev_EMP" as "SY_DEV_EMP" here is the structure [/code] create table Local_emp ( tran_id varchar2(10), acct_id varchar2(15) ); [/code] 2. Table which I am planning to … |
The End.