1,488 Topics
 | |
| | is it possible for a trigger to handles two tables ? my question, "Write a PL/SQL trigger that, on the insertion of a donation, will set its bloodGroup to the donor's blood group if the donationType is 'whole' or 'platelets', and null if the donationType is 'plasma'." and my trigger …  |
| | Hi, I am trying to install Oracle 9i but when it comes to Java Runtime Environment, it asks me path for it. I have JRE installed in my Computer. What else do i need to proceed this installation? Thanks |
 | i'm creating a form for my db and i need a code for the when_button_pressed for update one or more columns in a single row . thanx |
| | i have installed oracle 9i sql but while installing forms & reports it gives errors to run sql/plsql. pls explaine me the right steps to install oracl 9i & forms n reports. so pls help me that i can run both sql & forms reports. |
| | hello, i'm fairly new to oracle, but i pretty much get it. anyway i've created a table using this code : [CODE]create table BanquetReservation( ResNo SMALLINT NOT NULL, Restriction varchar(30) not null, ResType varchar(10) not null, DateOfEvent Date not null, NoOfPeople SMALLINT NOT NULL, EndDate Date, StartDate Date, SSN CHAR(9) … |
| | Does oracle plsql has PROBIT function inbuilt? is there any way i can implement it in plsql? this function is related to probability theory |
| | i have to get days of that particular month , that is if i give dates between different months like ex: 25-FEB-2008 and 05-MAR-2008 in this i want get 5 days only not 10 days |
| | Hi, I have a question pls clarify it. If a table is created and grant, index, triggers, synonyms etc are defined on the table. what happens to grant, index, triggers, synonyms etc if the table is dropped. What is the data dictionary needs to be checked to validate all these … |
| | Hi, I have a question. Please help me out. What is the default "display date format" and default internal "accepting date format"? How to change the default display and accepting format. In my system, the default display date format in sql * plus is dd-mon-yy, where as in toad it … |
| | hello!!! could anyone tell me how can i use php with oracle?? i have installed wampserver and oracle 10 (oci10) but it doesn't work, i think they are incompatible (wamp is only for oci8) what other php packet could i get for oracle 10? what is your advice? thanks !! |
| | Hi, How can i call a Oracle Stored procedure in vb6? Stored procedure : [code]ADD_SP (1, '1', 1, 1, 'abc')[/code] Thanks |
| | hi can anyone help me out in suggesting a way to connect oracle and VB6.  |
| | Please mail me the procedure for Java Oracle Connectivity. <snipped email>  |
| | Hi, What configs i need to do to connect to Oracle 10g? I use wampserver. Thanks |
| | Hallo everybody, newly I installed OracleUnivEx 10g, and also I am able to connect to Oracle by its own Web-GUI, but the problem not recognising the MySQL commands like "create database "db_name"" and others like SELECT, INSERT, and ... any idea please? how to create database in Oracle and modefy … |
| | We have given a project at school, we have to submit ERD next week... the project is as followes..... Software Experts(SE) is a consulting firm that specialises in creating custom software application for clients. When a client approaches SE with a project, the management at SE determine the staffing needs … |
| | Hi frnds, i want normalised tables for airline reservation system.my project date is due after 4 days.so plz help asap.it should do all works like add flight,book a ticket ,report generation etc. |
| | Hi all, I m converting stored proc from sql server to oracle. first have a look sql stored proc. create procedure xyz.. as begin -- i have created one temp table -- then inserted some data into it by select query over some db table. -- then i have another … |
| | Hi, What do i need to do to send SMS message or Email via Oracle 10g database? How do we do that? Thanks |
| | I'm new to asp.net and I have an oracle stored function with 3 input parameters that returns a string. The function is one that validates a user. I want to validate my users from Oracle. I'm trying to use the sqldatasource component to interact with my stored procedure but I … |
| | This what i do; Can anyone tell me whay i receice an error. 1- Run "SQL Command Line". 2- [inlinecode]connect / as sysdba[/inlinecode]. "No error". 3- [inlinecode]@?/rdbms/admin/utlmail.sql[/inlinecode]. "Created and no error". 4- [inlinecode]@?/rdbms/admin/prvtmail.plb[/inlinecode]. "Created and no error". 5- [inlinecode]GRANT execute ON utl_mail TO SYSTEM;[/inlinecode] "No error" 6- Open my "Oracle … |
| | Hi guys, Both cursor works if i don't use them in one Stored procedure. Both cursors return TRUE for(cursor_x%found). But, insert into process doen't work in cursor_1. Is there any structure problem? Thanks [code] CREATE OR REPLACE PROCEDURE ADD_RENTAL_SP IS -- cursor1 CURSOR cursor_1 IS SELECT ...... rec1 VARCHAR(15); -- … |
| | Hi, Where is the mistake? It doesn't work. thanks [CODE] CREATE OR REPLACE TRIGGER A_ACCOUNT_EKLEME BEFORE INSERT ON A_SIPARIS CURSOR CURSOR_TARIH IS SELECT TARIH FROM A_ACCOUNT where TARIH = SYSDATE; FOR EACH ROW BEGIN IF CURSOR_TARIH%NOTFOUND THEN INSERT INTO A_ACCOUNT (TARIH, PRICE) VALUES (SYSDATE, '1'); END IF; END; [/CODE] |
| | When I'm attempting to tnsping my database from the server it is stored on, I keep getting error code 3509, however I can ping my database from clients. I've checked naming in tnsnames.ora and all is as it should be. Any ideas??? |
| | hello, would somebody help me to connect oracle db to PHP best regards, zanzo  |
 | Hi Guys... i'm not so good at oracle, sql and related stuff.. but i do need to write some simple query's from time to time and i do need to understand that which all tables get updated by a particular transaction. I can do that by going through the code, … |
| | Hi friends, i got this err while executing this procedure. err is like this:- ----------------------------------------------------------------------------- 9/3 PL/SQL: Statement ignored 9/13 PLS-00201: identifier 'DATEADD' must be declared 11/3 PL/SQL: Statement ignored 11/13 PLS-00201: identifier 'DATEADD' must be declared ------------------------------------------------------------------------------ Please have look my stored procedure CREATE OR REPLACE PROCEDURE GReptExprtCompliTestRelt(EntityFolderCode number, … |
| | Hi, I can not use below code in stored proc in oracle; [code] IF (SYSDATE = '04-MAY-08') THEN ... END IF; [/code] This doesn't work either way (true or false). Is there any other way to check it? thanks |
| | Hi, I need a trigger; - to find number 1 from "ID" column and - update "AVAILABILITY" column from Yes to No in "PRODUCT" table. Thanks |
| | Hi, How do we connect to the Oracle with PHP? I can't find codes. for example: database connection name : Hello user name: system password : 123123 hostname : localhost port : 1521 thanks |
| | Please, could anyone tell me if there is tutorial for this issue? or give me instructions. I have search all day and found nothing. |
| | Hi, 1- When i insert more than 30 datas (at once) into a table, does sequence cache size(20) effect anything because, i use sequence for auto increment in the table. 2-What happens if i increase the cache size from 20 to 50? thanks |
| | Hi Experts! I am professionally working in Oracle Developer 6i and database oracle 10g. but now i want to learn JDeveloper. I have no tutor available in my area. will you give me some tutorials or URL of tutorials... regards Khalid Mehmood |
| | Hi I installed oracle 9i on my system. I am working with sql plus browser. my doubt is how to open iSQL *plus browser. I tried my level best to find out but no use. please any tell me how to open iSQL *plus. Thanks |
| | Hi everyone. Sorry if this question is in the wrong area..I posted it on the VB forum and they advised me to post here also. I have created a visual basic system that is connected to an oracle database. (I connected through data>Add New Data source>New Connection>Oracle Database etc etc) …  |
| | Hi Experts I am trying to develop a web application using Pl/Sql as scripting language. but i cant understand where to start and what i should implement the configuration for this purpose. |
| | I have a program that has a connection to an Oracle database and is supposed to execute an Insert statement. It runs with no problem until the [I]connection.Execute SQLString[/I] command. This causes a crash. The code compiles error free, and I've checked the syntax of the Insert statement and it … |
| | Hi. I have created a visual basic system that is connected to an oracle database. (I connected through data>Add New Data source>New Connection>Oracle Database etc etc) I am using the system to create new oracle users with passwords etc. I have a form called frmAdd and text boxes txtUser and … |
| | Hi, When i insert data into any table last number of sequnce get increased in all sequences that are listed below. These are for auto incremented numbers. All tables have their own autoincremented coloumns. Can anyone see mistake? Thanks [code] CREATE SEQUENCE FRANC_AUTOINC_SEQ START WITH 1 INCREMENT BY 1 NOMAXVALUE; … |
| | Hi, Here is my mysql sentence: [CODE]select last_insert_id() from pp;[/CODE] and the table pp is created by: [CODE]create table pp(id int not null auto_increment primary key,name varchar(255) not null);[/CODE] Now I'd like to change the above into sentences that are right in Oracle. First I create table: [CODE]create table pp(id … |
| | Hi, I have just downloaded 10g express edition but there is no user interface like SQL Server has. Does anyone prefer any program because i am new for Oracle and have never used before. Thanks |
| | Hi, Below trigger increments double(2,4,6,8...) not single. I want single. Where is mistake? If you can not help, is there other way to do auto increment? Thanks [code] CREATE TABLE MY_TEST ( IDNUM NUMBER, NAME VARCHAR2(4000) ) ; create sequence test_seq start with 1 increment by 1 nomaxvalue; create trigger … |
| | Hey all, Ok first my problem. I have a database that has an employee table and then also an absent table(for when they are off sick). The problem i have is using sql to find the employee that is off the most! So for my sql on the absent table … |
| | Hi, Could you pls explain me the confusing, diffterece between the views "USER_ " , "ALL_" and "DBA_". On which table query should be executed to get all the list of views like user_constraints, user_sons_constraints, user_source,user_sequences etc. Regards Pointers. |
| | Hi dudes, I desperately like to know the best way for learning Oracle including all accessories with regard to that I am fully familiar with database designing and Mssql into the bargain. Show all ways like all materials,tutorials and so on. All the best!!! |
| | from last thread, I figured it out my tables relationship and they do work i believe. however, i can't successfully get elements from each of the table out. if i do: select b_customer_name, h_customer_firstname, h_customer_lastname, telephone from customers c, business_customers b, home_customers h where c.customer_id = b.b_customer_id and c.customer_id = … |
| | I have to create a trigger having the following database. I'm confused in using the trigger type(row-level,st-type). Please help me out. Consider the relation schema of the COMPANY database given below EMPLOYEE (fname, minit, lname, ssn, birthdate, address, sex, salary, superssn, dno) KEY: ssn DEPARTMENT (dname, dnumber, mgrssn, mgrstartdate)KEY: dnumber. … |
| | Hi, I have some tables (below), but I'm having trouble entering multiple lines of data. Here are the tables I have created. [QUOTE][B][U]CUSTOMER table[/U][/B] SQL> create table customer 2 (customer_no char(6) not null, 3 name varchar2(30) not null, 4 address varchar2(50) not null, 5 credit_limit number(6,2), 6 constraint customer_customer_no_pk primary … |
 | Hello, I have created a synonym. But later I have dropped the base table which is referenced by this synonym. I thought that the synonym would be dropped automatically. But later I found it exists in all_synonyms and doesnt exist in user_objects dictionary. When i quried the date from this … |
| | I have written the following code to try and run a report that will list customers names and ytd charter costs whose ytd charter cost are greater than the average charter cost for all customers. There are 4 table involved: customer: PK cus_code, cus_fname, cus_lname|| charter: pk char_trip, char_date, cus_code,char_distance,ac_number|| … |
The End.