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 |
The End.