1,135 Topics
| |
hi, any help will be appreciated. I use Oracle discoverer plus. recently I tried to build a running total (average) calculation using the template provided. I defined 10 previous observations for this purpose. discoverer performed the calculation but the problem is with the first 9 (in this case) observations of … | |
Sorry for the simple question... But please i need help from you guys... How to import and export the database in oracle..iam have been using oracle 8i in my computer... im completely new to this environment... please help on this.. Thanks in advance... Shanti. | |
In oracle 9i ........How to delete duplicate entries in a table ? if suppose in a table named office, one or more entry(row) is repeated more then twice or minimum twice. I need a query to delete the multiple entries .... Note: --->No constraints applied on the table. --->No Primary … | |
i want to get the [COLOR="Red"]ROLE [/COLOR]of an user by entering the username and password in login form.... for example:: username password role ramesh xxxxxxx manager loginform:: enter username: enter password: [U]plllllzzzzz any one post the required query of the above problem[/U] | |
hi all, can some one help me how to display the fields which enter in current week,current month like that | |
Hello guys, Just need to know - wats making oracle to stuck when i run this simple pl-sql module declare counter number; begin <<outer>> for counter in 1..10 loop <<inner>> loop insert into lines values(counter); exit when counter=6 or counter=8; end loop inner; end loop outer; end; / | |
[B]Can someone let me know how the date syntax work. example working with "greatest" 01-oct-02 and 20-may-2003, it accept 20-may-2003 to be the greatest instead of 01-oct-02 which the oldest (greatest) can someone explain this to me. please let me know the logic behind. I have alot of problems with … | |
status teacher build exam (question and answer) and student take the exam form build_pre_exam add data into pre_exam table when form run , user(teacher ) have to insert question and four cooses then choose from list item which one i correct answer (to enable to check exam for student) ,after … | |
Hi, Can anyone help me how to retrieve data from table in the following manner. In my application I have five button namely First,last,next,previous,and Query. When I will press the query button, it should show me last data that I had feed to the table. When I press first button … | |
I am doing a project using oracle10g XE and JSP. Here i am using a table where data type of a field is autonumber. It is working fine when i insert or update record. but it does not continue its sequence when i delete a record. For example i have … | |
Does anyone know how Oracle's PL/SQL handles subtraction with a negative number? Really what I need to know is, given the following: (NOTE: this is NOT the code I'm working with. It's just an example to give and idea of what I'm trying to do.) [CODE] DECLARE number1 NUMBER; number2 … | |
Author Table INSERT INTO Author VALUES (12,'James Smith' ); Using join conditions Find memebers (by name) who have ever borrowed a book written by certain authour (JAMES SMITH) | |
hi, I need to know how to get only the upper case currency from a table using oracle. e.g:- data for currency will be as follows USD AUD EUR SGD AUd uSD EuR I need to get only the upper case currency among all the other currency such as USD … | |
In a table containing records of all customer with there orders and status of deliveries. Now I wish to find only last the entry of each customer available this table, it can be their last order or delivery status. What would be the ideal query for this? Please help me. | |
hi every one how to update one column using join condition,for example i am having two table, first table one column is to update the second table using join, please give me idea thanks | |
Hi there! Ive been working on my relational schema for a while now and just recently managed to implement it. I wanted experiment a little with it so ive decided to produce a report displaying relevant information. At the moment my schema only consists of 3 tables : a 'student' … | |
Hello, I am trying to nest some CASE statements into INNER JOINs (one CASE per INNER JOIN). The current code is: [code=sql] SELECT a.zone, a.ifield, a.iwhse, a.idesc, a.iposition FROM schema.itable a [/code]<---This is where I would like to place the INNER JOIN w/ CASE [code=sql]LEFT OUTER JOIN ( SELECT x.icode, … | |
Hi Guys I need a hand from a kind SQL*Plus guru to create Oracle abstract data types and collections using SQL*Plus I. Using Oracle’s SQLPlus create Abstract Data Type definitions for the Client and Child member entities called Client_Type and Child_Type respectively. Attributes for Client_Type include client number, name, address, … | |
I have created my tables in a database using a .bat file but when I try to insert data/values into it using toad there is prompt occurring that says that table i just created does not exist but when you look at the schema browser tab the table is there.. … | |
how are you every one?? I am student and i just started to study SQL,and now i will start studyabout Oracal . so i want ur advice to be a good student. | |
First off, I'm not really a DBA... I'm learning as I go. The office I work in has a lot of problems when it comes to the integrity and reliability of data stored in our Oracle database. One of the little things I'm wanting to resolve is the duplication of … | |
Hello all, I work for a S/w MNC as an system eng support but I wanted to move into database. I am new to databse. can anyone suggest me how to start with this. It's a new field for me but I want to make my career in this. Do … | |
what is the Major difference between Oracle,Sql Server,Mysql?WHat can do in ORACLE,SQl SERVER,MY SQL?what can't do in ORACLE,SQl SERVER,MY SQL? it is my big Doubt in DB. | |
Hi All, I am having problems trying to write unicode characters to a version 10 Oracle database, using C++ and OLE DB (the same code works with MS SQL). If I insert a unicode string directly from PL SQL it works, otherwise I get nonsense when trying from my code. … | |
what is the maximum limit for int in data type.suppose in our table im specifying ID as int type and assigning it as auto increment.After the int limit what will happen?what we will be auto increment? | |
hi what is difference between NOT EXISTS and NOT IN and also EXISTS and IN at subquery thanks | |
Ok, so I'm learning about procedures and functions in Oracle and I'm stuck here with my procedure. I have the function part down pretty good, but the whole returning variables with procedures through OUT mode is confusing me. My task is this: "Write a procedure that accepts a zipcode & … | |
hi i am creating stored procedure using cursors, i am using two cursors in my procedure, i takes the two fields in one table that fields are stored first cursor, and second table fields are stored in second cursor, and i check the condition for first table one field is … |
The End.