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