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 … |
| | Hi, I am currently working on Oracle 11.2.0.3. Below is my requirement. 1.I would like to scan the database ( Eg. 1 entire schema) and need to find the DB object either Procedure/Funcation which is having DROP statement. ( some of the procedures having " DROP PROCEDURE <PROCEDURE_NAME> " statements. … |
 | Hey!! i am using php to delete data from database but its not deleting and no error is showing. Please help me. <?php include('connect.php'); $p_No = $_POST['p_No']; $sql2 = "DELETE FROM usersR WHERE p_No = '$p_No'"; $compiled1 = oci_parse($conn,$sql2); $ex = oci_execute($compiled1,OCI_DEFAULT); ?> |
| | CREATE TABLE BUILDING(bname VarChar2(30) PRIMARY KEY, address VarChar2(30), phone number Number(15)); i write this code in sql command of oracle application express. but there is a error ORA-00907: missing right parenthesis anyone help me please i am new in oracle world  |
| | |
 | I have been butting my head against this problem for the past 4 hours, and I have to tap out. I know I can't be too far from correct I am just not sure what the missing ingredients are. Here is the problem question: Student status: List of all students … |
 | hi guys, anyone can sauggest me which institutes are best to learn oracle in india . |
 | i have this code..,. i dont see what's wrong why its only working on the first record of LOOP of X set serveroutput on size 30000; DECLARE VTEMP NUMBER; VPARENT NUMBER; BEGIN FOR X IN ( SELECT TEMPLATE_ID, TYPE_ID, TYPE_KIND, RECORD_ID FROM RT_RECORDS WHERE TEMPLATE_ID = 106 )LOOP DBMS_OUTPUT.PUT_LINE('TYPE_ID X … |
| | Hi! I have here data: i don't have any idea on how to insert the details in TABLE2... as you can see, the parent_id is based on TABLE1, TABLE 1 TABLE 2 (INSERTED IN NEW TABLE) LEVEL TYPE_TABLE PARENT_NAME RECORD_ID OBJECT_TYPE RECORD_ID PARENT_ID (RECORD_ID FROM TABLE 1) 1 NODEB EQUIPMENT … |
| | i'm trying to find in all tables with data in all columns.. example EMPLOYEE table with ID = 123 COLUMNS DATA ID 1 NAME TEST ADDRESS TESTADDRESS PHONE EMAIL POSITION DEV The output will be ID, NAME, ADDRESS, and POSITION.. so basically all columns with data only.. by the way, … |
| | hi everyone how can I parsing string into token in pl sql? example this is my string "170823-14785" and the parsing I want like this 17 08 23 -1 47 85  |
| | hi everyone i am new programer in oracle,i have save the url of the folders in the SQL server and i want to open or select a folder using the saved url by oracle plsql. I have select the url from the database, but the problem i don't know how … |
 | i am a new bee to oracle and database world, i need your help, as i am a student i learnt some commands in class, how to retrieve the tables and its contents in 10g, my question is that, is there any builtin tables in oracle 11g as well if … |
 | My application is developed in visual basic 6 and oracle 11g express is its database. Now we need to make it available on our network for multiple users to use it simultaneously. How can I configure it for the same. What is the procedure to make my application a networked … |
| | I have a project where I have to send data from an Excel spreadsheet to an Oracle database. Here is the code I am using and I need some help. It stops at the second string statement. I am trying to use an Excel range name to Insert or Update … |
| | Im working with Forms Builder. Ive built my form, when Im testing, it shows: FRM-41045::cannot find item:invalid ID. See Help>Online help for details But, online help sucks - there are only unanswered questions (forum-like site) Any help? |
| | Hello, I rebooted my server and it won't startup due to the below error, now server is not getting up, its throwing the below error and keep trying to connect to Oracle, so I am unable to access the server to free some space if its the issue as per …  |
| | Need on the best way to going about programming this in c#. I'm trying to do an if record exists update statement else insert statement: OracleConnection con = new OracleConnection(strConnection); con.Open(); OracleCommand check_RID = new OracleCommand("SELECT COUNT(*) FROM CONTRACT_INFO WHERE (rid = @rid)", con); check_RID.Parameters.Add("@rid", labelRID.Text); OracleDataReader reader = check_RID.ExecuteReader(); … |
 | Hi Dw. Long time ago I think late last year my computer was infected and I had installed a VM from Oracle and had a number of OS(VMs) installed one of them was with Win7 but I don't know what happened one day, when I open the VM it was … |
 | /DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …  |
 | Hi all, I am new in oracle sql dbs and I would like to take some certifications from Oracle. I have just got the 1z0-061: SQL Fundamentals exam, could you please advise me who will be the next ? Is it better to give for PL/SQL or advanced SQL ? … |
The End.