1,488 Topics
 | |
| | I m using a table GATE_PASS which has a primay key named GP_ID.the structure of GP_ID is 0000/MM/YY. I want to start a new series from 0000 after 30th june of every year.anyone could help me????  |
| | [code=sql] alter table pets_like_boys drop constraint pets_like; alter table boys_like_girls drop constraint boys_like; alter table girls_like_pets drop constraint girls_like; drop table pets_like_boys; drop table boys_like_girls; drop table girls_like_pets; create table pets_like_boys (pets_name varchar(32), boys_name varchar(32),primary key (pets_name)) ; create table boys_like_girls (boys_name varchar(32), girls_name varchar(32),primary key (boys_name)) ; create table … |
| | Hi..I am trying to connect oracle which is on my pc.i am using oracle 9i. i am creating 1 customer table & trying to display it. [code] import java.sql.*; import java.net.*; public class JdbcDemo{ public static void main(String args[]){ Driver d; Connection con; Statement stmt ; ResultSet rs; try{ d=(Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); … |
| | I'm making a program that adds favourite programs, files and websites to an Oracle database so there is no longer a need to browse my pc to find those files. I'm stuck on trying to find a way to edit the database and refreshing the program so the edited data … |
| | What normal form is violated here? A telephone call is uniquely identified by telephone number and time of call. These candidate keys compose the composite primary key. There is an attribute/column “telephone location”. telephone number|time of call | telephone location(precise) Does it help if the telephone is mobile? Just thinking … |
| | Dear All, I'm developing a website which must have a link to an oracle database. does anyone knows how to configure OCI on a linux server. Thanks and Best Regards Dilbert137 |
| | Hello All. I am starting this new thread for the help of those who want to give oracle certification exam. I want help from all. I am about to give IZO-047 OCA certification exam after 15 days. Can anyone please provide me suggestion regarding the following things: 1. Book for … |
| | |
| | Would like to create a temp table at the start of my Code for pull only a small result set that I then can use for my final result. Thank you, David |
| | Dear All, I'm developing a project in php but seems to have issue connecting to an Oracle database 10g. I have got some examples on internet but is someone having the same issue or had a previous issue. Have someone a documentation guide to suggest me. Thanks Dilbert137 |
| | New to Oracle. Using Crytsal 10. Unable to create views or Stored Proc on database. Having to just use SQL code in Crystal. Need to know how to pass variables from Crystal to the SQL code that will run on Oracle DB. Also can I create a temp table and … |
| | Dear all, No matter what I do, I can't seem to be able to make the JSP with Database work. How can I connect to an Oracle database which is hosted in our University, over a JSP page. I have a project where we need to connect to Oracle database … |
| | HI Folks, we have database servers of large application. we set initialization parameters log_archive_dest_1="/u02/fra" and log_archive_dest_2 ="/u04/data". But after some time being the parameter "log_archive_dest_2 " changed to "/u01/get" can u please tell me what are the operations on database can change this parameters values? As customer is naive he … |
| | hi i am new to this forum. How to connect Oracle database from JSP page. Can you help me with some example. regards Joshua Ravi |
| | In Oracle, I need to compair to date/time fields and see if the difference is more than 15 mins. What is the best way to do this. Thank you. David |
| | i m the student of final year of BS(IT).. so i would like to do my final year project with database.. so kindly give me ideas abt my final year project.. Thanks. |
| | |
| | hi i am Raghavendra. I dont know anything abt how to connect to oracle (sql) from VB 6 . could u plz let me know d steps n d code for executing the queries. its very urgent plz let me know |
| | Can anyone tell me the difference between Truncate and delete Command .Kindly let me know the idea.Any help would be highly appreciated. |
| | |
 | I have a php user front-end and would like to validate a some fields to stop duplicates the database is oracle and the form is quite large i was wondering if it is possible with Javascript or ajax to run a select statement using php code check the values and … |
| | I would like to know if there are any resources where they clearly explain how a database is used in an ERP application such as SAP. Or else give me some keywords to search on google for this information. I searched a lot but did not get the desired information.I … |
| | I have a query called in a CSH script which is a simple select. I would like to write the result of the select statement in a a flat file but when i set the "SET HEADING OFF" and "SET FEEDBACK OFF", i get a blank line written to the … |
| | I would like to know how do i create a flat file from a query in oracle. For example i would like to create a select statement and the output to the flat file should be like this: name,location,address ...... Later on, this task will be embedded in a unix … |
| | Hello All :pretty: i m new in this forum and i want to ask if there is examples about sql bcz i have lab exam on sunday and i don't know the type of questions so i m friad from that :S i use Oracle Sql*plus and thanx alot 4 … |
 | Hello, everybody. I had a problem while connecting to Oracle. Got messages: [QUOTE=Error]ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified[/QUOTE] And found solution for this - setting the default locale in java code: [code=java] Locale.setDefault(Locale.US); [/code] This works just fine … |
 | Hi everyone. Can someone please recommend a SQL editor (other than SQL Developer) that will allow me to test out my SQL statements & queries outside of the DB environment. I will predominantly be working in a windows environment, but may move to a linux environment at times. Will be … |
| | Hi all, I would like to ask for some help in a query. I am trying to create a view and this view should show the student name, project name, hours spent on the project, and number of units the project is worth. However, if the project is not done … |
| | i have a combo box in vb6.0 which i need to get a column of data from oracle database, how can i extract a perticular column of data to a combo box |
| | I want to store multiple usernames and passwords in the oracle 9i and connect with VB. I am new with this. Kindly send me reply. Smitha |
| | hiii I am doing application in vb.net and Oracle10g. On running the project there is some "Query Engine Error C:\document\Local\temp\....3434834-453493434.rpt" error but when same dataSet object when set as source to Datagrid the grid is filled corretly.......... any idea where m i going wrong............... |
| | Hi All, I am able to connect to the database from backend that is toad.But from the java application i can't . The error is from the line [CODE]Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@vrs1.india.mitey.com:1591:dapps");[/CODE] I am getting the following error: [CODE]Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 7 at oracle.security.o3logon.C1.r(C1) at oracle.security.o3logon.C1.l(C1) at … |
| | HI friend can you tell me how to connect and retrieve data from mySQL and oracle database using ado.net in C#.  |
| | Hi, I have this view: [CODE]DROP VIEW digits; CREATE VIEW digits AS ( SELECT TO_NUMBER(SUBSTR(rounded_cost, 1, INSTR(rounded_cost, '.' -1))) left_digits, TO_NUMBER(SUBSTR(rounded_cost, INSTR(rounded_cost, '.' + 1, LENGTH(rounded_cost)))) right_digits FROM roundcost );[/CODE] It allows me to create it but the values stored are apparently not valid numbers. When I try select * … |
 | I currently run an installer app that will install a DB on a VM server. However this fails because the when oracle is called to begin the oracle services start up but the newly installed DB will not. It works on a physical machine but not on the virtual server. … |
| | Has someone managed to install Oracle 11.1 on Fedora 12 ? The following packages failed to install : Checking for libaio-0.3.106-i386; Not found. Failed <<<< Checking for libstdc++-4.1.1-i386; Not found. Failed <<<< Checking for libgcc-4.1.1-i386; Not found. Failed <<<< Checking for glibc-devel-2.5-i386; Not found. Failed <<<< Checking for compat-libstdc++-33-3.2.3-i386; Not … |
| | Hey guys I am Using Oracle APex and have created a some tables running SQL commands. I am now trying to INSERT multiple rows of data into one of the tables but am running into issues. I firstly tried the following: [CODE]INSERT INTO stock_item_table (stock_item_no, item_desc, item_price) VALUES(11,'item1',12); VALUES(12,'item1',22); VALUES(13,'item1',32); … |
| | Hello friends, i m trying to input user : scott and pass : tiger also trying user : system pass : manager but even though its not going to start. i m getting following error [QUOTE]SQL*Plus: Release 3.3.4.0.0 ERROR: ORA-12154: TNS:could not resolve service name Enter user-name: Enter password: ERROR: … |
| | Hi, I was new to c# and asp.net .I want to create a simple login page using ASP.net with c# code.I had 2 textboxs(username and id) and 1 button control.I stored all the username and id in oracle database.Ma table in database contents emp_name & password.what i need is ,once … |
| | Hello! I'm trying to install an Oracle application onto Win XP SP2 and am getting the following error: user1.pin(20): OS_ERROR while spawning ifsrv60 -install Forms60Server port=9000 mode=Socket batch=yes Any ideas on this?? Having difficulty resolving this issue. |
| | The name of this question is “three JSF questions” Hello and Thank you in advance for any assistance. [B] System info: [/B] Netbeans,MySQL,glassfish [B] The Purpose of this post is: [/B] have someone look at the excel file (subscribe_app_notes2)at : [url]http://cid-b5cb457363230793.skydrive.live.com/browse.aspx/Public[/url] [B] The functionality of this code is: [/B] I … |
| | Design an oracle for the following JavaScript function. 2. Generate a test case set for this function and provide a coverage analysis report for your test case set. The JavaScript function: [CODE=javascript]function purchaseSong(username, password, songId) { // first authenticate the user if (checkCredentials(username, password) == false) { alert('The username or … |
| | Hi, I need to get Oracle for windows 95 including sql plus 8.0 for practicing my subject. no other version would do. Can someone please give me the download link. thank you. |
| | Stupid question, really... Say, if I have a Department tuple with "Faculty" field- how can I declare it on the design stage so it only can take the values of "Science", "Arts" or "Psychology"? Department { <letter_ID : CHAR( 2)>, <english_name: VARCHAR2 (50)>, <enw_cymraeg: VARCHAR2 (50)>, <faculty: "science" or "arts" … |
| | The name of this question is oracle project Hello and Thank you in advance for any assistance. [B] System info: [/B] I presently use Netbeans6.7,MySQL,glassfish to work with learning JSF and java apps etc. [B] The Purpose of this post is: [/B] I recently was presented with a tutorial to … |
| | i wanted to create a locally managed tablespace with uniform allocation of extents. And also want my tablespace to consist only let say 5 extents. It will use only one data file. here is what i know: [CODE] CREATE TABLESPACE TABLE1 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K DATAFILE 'C:\ORACLE\ORADATA\MYDB\TABLE1.DBF' SIZE … |
| | Hello to all, Am new to oracle sql, and I am using the developer to create new database. Unfortunately, when I try to create new connection and error appears saying that : Status: failure –lo exception. The network adapter could not establish the connection. Connection Name: NewDatabase Username: test Password: … |
| | Hi, I've suddenly started getting some errors reported in my apache error_log on Windows 2003. The apache has been running fine and we've not upgraded it. I've now getting this in the error_log, [Wed Nov 11 09:42:28 2009] [crit] (10038)An operation was attempted on something that is not a socket: …  |
| | Hi, Can anyone provide a sample application that usses a login page, in which users can login and the login details will be checked from the oracle db. Thanks in advance.:)  |
| | helllllo >>> i have worked on Functions and precuders in PL/SQL for alsmost two weeks until now !! ummm i had some blocks where i stop with >< having no idea how to deal with !!! one of those blocks checks wether a member team is nethier Manager non a … |
The End.