1,135 Topics
| |
HI : I WANT THIS BOOK Oracle Privacy Security Auditing: Includes Federal Law Compliance with HIPAA | |
plz... some give me the answer for this . this was asked in an interview. | |
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')) ); … | |
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? | |
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 … | |
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. … | |
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 … | |
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 … | |
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 … | |
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, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to … |
The End.