1,135 Topics
| |
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 | |
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, 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. … | |
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: … | |
| 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: … | |
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 … | |
hi everybody ...could anyone tell what is the difference between deny and revoke of privileges from a user. | |
I have around 2 million vouchers of some fixed denomination (say 10 and 20)[CODE]create table vouchers(pin varchar2(20) primary key ,amount number,status char(1),extra_value number); create index IDX_AMOUNT_STATUS on vouchers(amount,status);[/CODE]Typical values [CODE]amount,status ,count(status) 10 N 1000000 10 U 700000 20 N 300000 [/CODE]For each payment transaction,I fetch one voucher wrt.transaction amount and … | |
hey i'm starting with a dbms project on commonwealth games . i want to use sql . can anyone please suggest me with what all i can include in my project?? | |
[B]hi every body i have a trouble with viewing the report from using the following environments[/B] C# - Crystalreport - Oracle database i regularly use the basic way to call a view form the database and extract the data form it like that [CODE]cmd.commandtext= "Create view as select * from … | |
I am just starting to learn sql and have to questions from my homework assignment. The first is this: Write a query which will project the average rental price and number of such videos for videos of Classic movies --- BUT! You must write this without explicitly using the category … | |
I am new at oracle and working on a small project. I am trying to find "[" in a field and produce from that point to the end of the field. My code is as follows: [code] declare startPos PLS_Integer; endPos PLS_Integer; begin set startPos := (Select top 1(instr(description, '[', … | |
Hi all, Is it possible to insert a SQL statement where I specify the time, and not the date. I do need the date, but I want it to be the current date when I run the insert statement. The time got to be fixed. For example, Insert into xxx … | |
hello , (begginer of SQL) i have to make one pro. in which i have to use trigger which will fire before inserting into table and convert the name into upper case but i don't what is the prob. with the code pls provide ur suggetion my table attributes are … | |
hi I have got a table for "internet access" with user ID, it has 3 columns user ID, starttime and endtime, i want to make another column which will show how many mins or hours that user was logged in to the internet and also add the total time if … | |
I am working on an Oracle homework assignment, working in shell, trying to query a tricky display question my professor has asked for. I will show both tables, and what I have to execute. [code] SQL> describe orderline Name Null? Type ----------------------------------------- -------- ---------------------------- LINENUM NOT NULL NUMBER(3) ORDERNUM NOT … | |
Hi! I need a great favor... if someone could help i really appreciate... heres the deal: i made one year ago a webpage with a database on isQL*plus ([B]pl/sql[/B]) language.. on my webpage i have this (i will show images to you understand better what i mean): [URL="http://img36.imageshack.us/img36/5783/gerirjogadores.jpg"]http://img36.imageshack.us/img36/5783/gerirjogadores.jpg[/URL] code: [CODE]procedure … | |
With the release of [url=http://esd.ingres.com/] Ingres Database 9.3[/url] today, the company says it's now easier for developers to migrate their application to the open source system from MySQL, Oracle,SQL Server and Sybase. It does so, the company said, through "improved accessibility of table procedures from within the query" and support … | |
This is a problem that is killing me. It is a school assignment and I can't figure it out so any help will be great. I have eleven questions, and I have five of them answered. I have these tables with these fields: Table:sales_rep Columns:Last|First|Street|City|St|Zip_Code|Total_Commision|Commision_Rate Table:customer Columns:Last|First|Street|City|St|Zip_Code|Balance|Credit_Limit|slsrep_number Table:part Columns: Part_number|part_description|Units_on_hand|it|warehouse_number|unit_price … |
The End.