2,627 Topics
 | |
| | Hi, I m new member of 'daniweb' i m a student of BCA 5 in india i m intrested in VB,Oracle,JAVA,Networking so Please help me.... I m creating a project like mobile company! i have problem to create table in ORACLE 9i using VB6. I have some problem to give … |
| | Hi everybody, I am new beginer to VC++ . I want to make a connection between ORACLE and VC++ Application. Anyone can help me . your kind help would be appreciated |
| | I attempt to create a string variable to a setter() that is used as query property What am I missing in the procedure to implement a simple query on the database? It stops here. [code] searchList1 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : searchQuery1.getResultList(); [/code] [code] @Action public Task searchSplash() { if … |
| | 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  |
| | Is there anything I can do to adj. searchList1 parameters? I noticed ?null: in the searchQuery1. What does this denote Thanks Steve query = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery(resourceMap.getString("query.query")); // NOI18N list = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections.observableList(query.getResultList()); searchList1 = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : searchQuery1.getResultList(); searchQuery1 = java.beans.Beans.isDesignTime() ? null … |
 | 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, … |
| | I am having trouble setting a query property for searchQuery1 I must be a return from a getter() (getSearchQuery()) Is it possible to set this query property using a return from a method? init: deps-jar: compile: run: [TopLink Info]: 2008.05.06 07:54:48.192--ServerSession(17548445)--TopLink, version: Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007)) … |
| | Can someone help me figure out why this .form compiles yet the query to perform a search throws this error? I have one entity manager,at startup "query and list set the table with all data from [ICODE]<splashtemplateda.Content>[/ICODE] combobox and textfield and button(action) should config search specs and refresh table with … |
| | |
| | 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 All, My company runs an old custom built classic ASP web site with oracle 9.2.0.1 as the database. Recently they hired a few developers to build another asp.net application with odp.net10. Now we are unable to run both applications at the same time on our web servers because of … |
| | 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 |
| | Hello: [code=cplusplus] #include <stdio.h> // for printf #include <D:\Programavimas\Naujas Darbas\SQLAPI\include\SQLAPI.h> // main SQLAPI++ header int main(int argc, char* argv[]) { SAConnection con; // create connection object try { // connect to database // in this example it is Oracle, // but can also be Sybase, Informix, DB2 // SQLServer, InterBase, … |
| | 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) …  |
| | |
| | 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 |
| | I work here at UPS in the HR department and they use a Microsoft Access mdb database that connects to oracle servers to retrieve tables. It then creates a local copy of the tables and the queries run off that. The tables are updated every morning at 6am by a … |
| | 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 … |
 | Hi All... i m newbie with ruby. a couple weeks ago i was reading book about oracle 10G XE then i found a new language that i never heard before named Ruby on Rails. i was exited and want lo learn many about this language. so, please help me to …  |
| | 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 = … |
| | Hi, I have a project which requires me to use PL/SQL blocks, PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers. I think(not sure) i can create PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers in MySQL. Can i create PL/SQL blocks and PL/SQL cursors within MySQL … |
| | Hi guys, This is Shane; having 4 yrs experience in VB, 3 yrs in C# and 2 yrs experience in Oracle D2k. Love to code and love to design and analyz applications. Cheers!!!!  |
| | 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 … |
| | Hi jack of unix commands,oracle plsql and php, wanting to clarify silly doubts and to look for support when stuck  |
 | 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|| … |
| | I am still pretty new to writing SQL statements and I have mostly used MS Access up until now. My question is I am trying to write a single query based on the sample table below to determine how many orders were all parts orders, how many were all accessories … |
| | can anyone tell if it is the right way to connect these tables? What is the query display customerid, b_customer_id, and h_customer_id... thxxx --customers [code=sql]drop table Customers cascade constraint; create table Customers( Customer_id Number(5) primary key not null, Credit varchar2(20), Street varchar2(20), City varchar2(12), State varchar2(2), Zip varchar2(5), Telephone varchar2(14));[/code] … |
| | In Vb we can connect to all the databases like SQL 2000/SQL 2005,Oracle,Access. Out of the given databses we can connect to which databases. Secondly,told me dat if I want to connect to SQL-any version(2000/2005), To connect to the database i go to Control Panel-->Admintrative Tools-->Data sources(ODBC)-->ODBC Data source Administrator …  |
| | I want to parse strings in an XML file. Example: [code] <TestOptions> <Testing> <Tester>GETME</Tester> </Testing> </TestOptions> [/code] What I want to do is get the "GETME" contents there between the <Tester> tags. I've Googled, searched this forum + others and came up with A LOT of results such as Xerces, … |
| | Is there any one can explain to me what is the difference between when_validate_item trigger and post_change trigger? In what kind of situation I need to use those triggers? I really feel very confused about it...It makes me stuck in my database assignment... btw, thanks for ur help... :) |
| | Hi, I am developing one website in which i have around 21 table in my database out of which 8 are master tables and rest are secondry tables. I want the data stored in some columns of master table to be displayed as drop down menu in my secondry table. … |
| | Select order_num, order_date, customer_name, description From orders,part,customer Union Select order_num, order_date, customer_name, description From orders,part,customer Where customer_name = 'Johnson's Department Store' or description = 'Gas Range'; I'm getting this error and from my understanding it looks like it should be fine: SQL command not properly ended |
| | I write programs using VB as the front end with Ms Access as the back end( database), and i will love to switch my back end to oracle ( so i think of starting from 9i).Please does anyone have the note or documentation I can read on my own in … |
| | Hi, I am using oracle 9i. I've got hard time rying to rename columns or constraint definition. I use the following for renaming a column: [code] ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name; [/code] but I get this error [inlinecode]ORA-14155: missing PARTITION or SUBPARTITION keyword [/inlinecode]. The same thing … |
The End.