1,488 Topics
 | |
 | Hi there, I've lost my password and username and am trying to log in using sysdba. It doesn't log me in and I would like to retrieve my username and password without re-installing the software. IS there a way of doing that?> |
| | Hi everyone, I had Oracle working perfectly fine and was able to connect to 127.0.0.1/apex . After a fresh re-install, I couldn't access the page. I can manage to log into oracle database by using SQL command line. I'm running Oracle 11g express edition. The message I get when I …  |
| | |
| | Hi everyone, I'm sure the update statement is well-written but for some reason Oracle sql command line is refusing to execute it. UPDATE myTable SET country = 'Aus' WHERE username = '"martin"'; // I know you can see single quote and double-quote as well. Well, names were inserted into the … |
| | CREATE OR REPLACE PROCEDURE transfer( crdtacno IN NUMBER, dbtacno IN NUMBER, amount NUMBER, transno NUMBER ) IS BEGIN INSERT INTO transaction VALUES(transno,amount,SYSDATE); UPDATE account SET accbal=accbal+amount WHERE accno=crdtacno; INSERT INTO entrylist VALUES(transno,crdtacno,'CR'); UPDATE account SET accbal=accbal-amount WHERE accno=dbtacno; INSERT INTO entrylist VALUES(transno,dbtacno,'DB'); END; / |
| | Hello everyone, I have a table called job.In the table two particular columns are empid and managerid.When I am creating the table I must ensure that the managerid should be an existing empid.How do I write the create table statement for this.I am using oracle 10g. Thank you |
| | hello iam using oracle 10g express edition actually iam not able to connect to sql plus if i enter the commands it shows an error mesaage as "not connected".so i tried another way of opening by connecting in oracle 10g go to database home page and entered my password and … |
 | I just finished installing ODTwithODAC112012 (Oracle Developer tool for Visual Studio ODT) on my system . Now I am trying to deploy dbmsclr.plb as SYSDBA from SQLPLUS But I am getting the error SP2-024 nothing to change. Here is the command window:- C:\>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Tue … |
| | Hi, I am new to Oracle. I have installed Oracle 11g R2 standard edition (server software, 2GB download from Oracle). I found that the 'Environment Variable PATH' has not been set. Which of these directory should I use for the PATH value:- 1. Oracle base, 2. Software location or 3. … |
| | Oracle : 11.2.0.1.0 Apache 2.0 Handler PHP Version 4.4.9 Windows XP I have problem to connect with Oracle 11g. Log apache : PHP Warning: Unknown(): Unable to load dynamic library 'C:\\Program Files\\Apache Group\\Apache2\\php\\extensions\\php_oracle.dll' - The specified module could not be found.\r\n in Unknown on li when I open phpinfo : …  |
 | hi guys i got some problem with this code error said that exact fetch row return more than expected rows CREATE OR REPLACE PROCEDURE "MAINTAIN_REQUESTSTATUS1" (emplevel IN NUMBER,eid IN NUMBER,depid IN NUMBER,teamid IN NUMBER) is lastreq number; seq number; stat NUMBER; tok varchar2(60); appr number; CURSOR c1 IS select empid … |
| | Hi! 1. Whats the difference between using these PL/SQL records? -Table Based -Cursor Based -Programmer Based 2. Whats the importance of using PL/SQL Table? 3. Whats the importance of using VARRAYS? 4. When to use these 3 RECORDS, TABLES, VARRAYS Thanks! |
| | Hey there I have two separate queries and I am trying to figure out how to combine them into one. I've verified separately each one works. They are: SELECT FACULTY_t.LastName||', '||FACULTY_T.FirstName AS "Committee", STUDENT_T.LastName||', '||STUDENT_T.FirstName AS "Student" FROM STUDENT_T, FACULTY_T Where STUDENT_T.CommitteeID = FACULTY_T.FacultyID and select decode(COMMITTEE_MEMBER_T.FacultyID,COMMITTEE_MEMBER_T.ChairPerson,'Y') chair from COMMITTEE_MEMBER_T … |
| | hi to all, i want to create user on student table IN ORACLE.... CREATE USER john IDENTIFIED BY out_standing DEFAULT TABLESPACE users QUOTA UNLIMITED ON users DEFAULT TABLESPACE temp QUOTA UNLIMITED ON system; but, oracle shows following error like...."insufficient priviveleges on password... please give some suggestion for creating user in … |
 | Hello DBAs, Any one familar with the ER diagram generation in TOAD. I am able to generate the diagram for one particular table. I need to generate for the whole schema. Can you please help me to find out a way? Always Thanks, BMantri |
| | hi, can we use sub query in order by clause?? and how? |
| | I have about 16 tables in a database schema that are empty and wish to populate them with junk row values of the same type which I have defined,is there a way to do it? |
| | //Hi, //I want to make an application that sends email; the email need to be taken from an oracle database, I had make the email code and it is working succseeful and also I made the coonection to the database in the next class which is also working successfully, but …  |
| | |
| | IN ORACLE 10G I CREATED A TABLE AND INSERTED 3 ROWS AND COLOUMNS.NOW MY DOUBT IS WHERE THE DATABASE FILE WILL BE STORED????THE REASON WHY IAM ASKING IS BCOZ IT MAY NEED FOR JAVA CONNECTIVITY |
| | ***My tnsNames.Ora File -*** XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Sonia-PC)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) … |
| | how to drop multiple columns at a time.. i tried with the following syntax "alter table <table_name> drop column <col_name1>, <col_name2>" but i am getting syntactical error. |
| | can we use double quotes to the column name while creating a table?? if yes, then how to insert the records into it??? |
| | i have a doubt.. once i created new user called user1 in oracle database with default tablespace say user1, if i import data from user tablespace, after that the data will occupy space user tablespace only. i want to know how to move data from user tablespace to user1 tablespace. … |
| | |
| | Hello friends, I am working with jsp and oracle database and The problem is after inserting 3 enteries(rows) through form filling into database next enteries are not going in databse.So please suggest me something.  |
| | hello dear members i need some help. i will try to explain the scenario. i am currently working in a office and they want to implement a software which is already designed by the vendor. this software will provide automation of current business needs. this software as per vendor description … |
| | Hi guys, Really need help I have this case i have a sms gateway and php with oracle database runnin my system is filling a leave now if i want to text leave<space>143 from mobile phone it will i can file leave directly from my database really appriciate your smart … |
| | guys am a newbee and starting to use oracle as a database for php i just want to ask on how to connect php to oracle then how to select a particular database is there an equivalent function for this in oci "mssql_select_db" |
| | It's my first time to use oracle and i'm kinda lost :S I'm using netbeans v6.8 and i want to make a connection between Oracle 10g DB and java to make my program insert and retrieve data from the db - i tried searching for oracle's libraries to include it … |
| | hi have a nice time, guys can you provide me a complete list of orcle queries (SQL / PLSQL) |
| | I installed Oracle9i on my PC which run Win XP. But I can not open "isqlplus" in my web browser. I have some more machines which connect to the server through LAN. And I want to run oracle isqlplus on those system by the IP address of server machine. I … |
 | HI there, I am doing my internship with accenture and i got my first assignment. Basically i first thing with this task is i need to find way to modify the query so that it will pull only the data that has existed/activated more than one hour. This is the … |
| | I have installed the Oracle 10g at the following location : - ***C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN*** But I was trying to ping Oracle Client from Command Prompt. See Below : - c:\Oracle>tnsping SONIA **ERROR IS COMING no listener** MINE tnsnames.ora File : - # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora # Generated by Oracle … |
| | I have 2 queries I have to create but they sound the same. Note: I am just learning the theory behind SQL and not actually working on a DB at this time Directions: 1. Show all the categories for each book with the book number, title, category number, and category … |
 | `select s.sname as stationname , sum(di.quantity) as quantity from demand_information di, demand d, company c , station s where s.sno = d.sno(+) and di.demandno = d.demandno and d.cno = c.cno and c.cname = $P{companyname} and to_char(d.demanddate,'MM-yyyy') = $P{gdate} and di.pno = (select pno from products where productname = $P{productname}) group … |
| | could you please tell me what is high water mark in oracle terminology? Please explain with example. |
| | here is my dilemma I have a database that consists of tables (duh!) for an award nomination project where I have a table for nominees and a table for each category of qualifications for example table 1 (nominees) name ID_NUMBER PK DEPARTMENT NAME PHONE# table 2 (education_information) ID_NUMBER FK DEGREE … |
| | |
 | [From the Oracle Forum](https://forums.oracle.com/forums/thread.jspa?threadID=451115) Hi all. I'm developing a simple database system that holds staff, customers and booking details for photography service. I've four tables - package, admin, customer and booking. Right now I'm in the process of creating application which has simple forms in it. The form I'm trying … |
| | can any one help me out i want to make an application using oracle . i want to know evrything from scratch. plzzz tel me i am so eager to make it[COLOR="Red"][/COLOR] |
| | Hi, I have following table structures. # Table1 # link - varchar hlink - varchar top-cap - varchar (FK) sub-cap - varchar (FK) lk - varchar(PK) # Table 2 # cap - varchar(PK) caps - varchar captype - varchar top cap and sub-cap in Table1 are FK. They refer cap … |
| | Whenever I tried to access Oracle DB from PHP , it shows error Everything is ok, Path is okay. I changed php.ini file to. I am using old version of xampp Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the … |
| | Can anyone explain me RR DATE FORMAT in Oracle, its getting pretty confusing for me. Appreciate your time and effort. |
| | I have installed oracle10g but I cannot find any java sample programs for data mining! I could not find any download link on the internet! Please help! |
| | Hi, can you help me please, i have to build a query and i have a problem in the group by expression ==> error message: not a group by expression my query: select ress.nom nom_ress, task.nom tache, max(tr.entrydate), ass.prstart, ass.prfinish, nvl(ass.practsum,0) service_fait, nvl(ass.prestsum,0) service_à_faire, prj.nom projet, tr.resource_class, tr.transclass, tr.project_department from …  |
| | Hi, I am trying to return a ref cursor from a stored function but I keep getting this error message 'Specified argument was out of range of valid values'. The reference cursor does point to correct data, I used a anonymous block in oracle to test it out. How can … |
| | Oracle query to display all policies existing in the database? Can anyone tell me what will be the "Oracle Query to display all policies existing in the database"? |
| | Hi Guys, I have a table in Oracle with a column userid and i have a userid column in Active Directory. based on this i want to query the Network ID and update in one of the Group in the Active Directory. Can you guys help me on how to …  |
 | # EER for Rental store, to be put into Oracle for a database. # I have a databases project due monday. I'm still very new to databases so my understanding is minimal. I'm sorry if the answer to this is already on the web or somewhere on daniweb but I … |
The End.