[oracle] Forum Topics

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

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.

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

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"?