[oracle] Forum Topics

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 …

hi, what is the query to fetch duplicate (related) records in oracle.

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. …

Hi, can any one explain me about d2k. what it exactly mean, and its use. I got an opportunity to work with d2k. i have knowledge in Oracle. How can I learn d2k? Thanq in advance.

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 …

hi friends can you suggest me best book or link in oracle for good practice

[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 …