1,488 Topics
 | |
| | Hi, I am currently working on Oracle 11.2.0.3. Below is my requirement. 1.I would like to scan the database ( Eg. 1 entire schema) and need to find the DB object either Procedure/Funcation which is having DROP statement. ( some of the procedures having " DROP PROCEDURE <PROCEDURE_NAME> " statements. … |
 | Hey!! i am using php to delete data from database but its not deleting and no error is showing. Please help me. <?php include('connect.php'); $p_No = $_POST['p_No']; $sql2 = "DELETE FROM usersR WHERE p_No = '$p_No'"; $compiled1 = oci_parse($conn,$sql2); $ex = oci_execute($compiled1,OCI_DEFAULT); ?> |
| | CREATE TABLE BUILDING(bname VarChar2(30) PRIMARY KEY, address VarChar2(30), phone number Number(15)); i write this code in sql command of oracle application express. but there is a error ORA-00907: missing right parenthesis anyone help me please i am new in oracle world  |
| | |
 | I have been butting my head against this problem for the past 4 hours, and I have to tap out. I know I can't be too far from correct I am just not sure what the missing ingredients are. Here is the problem question: Student status: List of all students … |
 | hi guys, anyone can sauggest me which institutes are best to learn oracle in india .  |
 | i have this code..,. i dont see what's wrong why its only working on the first record of LOOP of X set serveroutput on size 30000; DECLARE VTEMP NUMBER; VPARENT NUMBER; BEGIN FOR X IN ( SELECT TEMPLATE_ID, TYPE_ID, TYPE_KIND, RECORD_ID FROM RT_RECORDS WHERE TEMPLATE_ID = 106 )LOOP DBMS_OUTPUT.PUT_LINE('TYPE_ID X …  |
| | Hi! I have here data: i don't have any idea on how to insert the details in TABLE2... as you can see, the parent_id is based on TABLE1, TABLE 1 TABLE 2 (INSERTED IN NEW TABLE) LEVEL TYPE_TABLE PARENT_NAME RECORD_ID OBJECT_TYPE RECORD_ID PARENT_ID (RECORD_ID FROM TABLE 1) 1 NODEB EQUIPMENT … |
| | i'm trying to find in all tables with data in all columns.. example EMPLOYEE table with ID = 123 COLUMNS DATA ID 1 NAME TEST ADDRESS TESTADDRESS PHONE EMAIL POSITION DEV The output will be ID, NAME, ADDRESS, and POSITION.. so basically all columns with data only.. by the way, … |
| | hi everyone how can I parsing string into token in pl sql? example this is my string "170823-14785" and the parsing I want like this 17 08 23 -1 47 85  |
| | hi everyone i am new programer in oracle,i have save the url of the folders in the SQL server and i want to open or select a folder using the saved url by oracle plsql. I have select the url from the database, but the problem i don't know how … |
 | i am a new bee to oracle and database world, i need your help, as i am a student i learnt some commands in class, how to retrieve the tables and its contents in 10g, my question is that, is there any builtin tables in oracle 11g as well if … |
 | My application is developed in visual basic 6 and oracle 11g express is its database. Now we need to make it available on our network for multiple users to use it simultaneously. How can I configure it for the same. What is the procedure to make my application a networked … |
| | I have a project where I have to send data from an Excel spreadsheet to an Oracle database. Here is the code I am using and I need some help. It stops at the second string statement. I am trying to use an Excel range name to Insert or Update … |
| | Im working with Forms Builder. Ive built my form, when Im testing, it shows: FRM-41045::cannot find item:invalid ID. See Help>Online help for details But, online help sucks - there are only unanswered questions (forum-like site) Any help? |
| | Hello, I rebooted my server and it won't startup due to the below error, now server is not getting up, its throwing the below error and keep trying to connect to Oracle, so I am unable to access the server to free some space if its the issue as per …  |
| | Need on the best way to going about programming this in c#. I'm trying to do an if record exists update statement else insert statement: OracleConnection con = new OracleConnection(strConnection); con.Open(); OracleCommand check_RID = new OracleCommand("SELECT COUNT(*) FROM CONTRACT_INFO WHERE (rid = @rid)", con); check_RID.Parameters.Add("@rid", labelRID.Text); OracleDataReader reader = check_RID.ExecuteReader(); … |
 | Hi Dw. Long time ago I think late last year my computer was infected and I had installed a VM from Oracle and had a number of OS(VMs) installed one of them was with Win7 but I don't know what happened one day, when I open the VM it was … |
 | /DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …  |
 | Hi all, I am new in oracle sql dbs and I would like to take some certifications from Oracle. I have just got the 1z0-061: SQL Fundamentals exam, could you please advise me who will be the next ? Is it better to give for PL/SQL or advanced SQL ? … |
| | Hi, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to … |
| | Iam using windows 7 32 bit and Oracle 11g SQL> spool off SQL> host type c:\spool.txt The system cannot find the file specified. help me to solve the above ploblem |
 | Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), )) |
 | Group, I've written what I believe is fairly simple code to populate a combobox via data from an Oracle Database. Unfortunately it isn't working and the error in the output box says: "Exception thrown: 'System.BadImageFormatException' in OracleConnections.exe" (the name I've assigned to the program is "OracleConnections"). This is not an … |
| | Hi Group, I'm attempting to pull info from our database to populate a combo-box in VB.net (Visual Studio Express 2015). Here's my first attempt at the connection: Dim conn As New Oracle.DataAccess.Client.OracleConnection() conn.ConnectionString = oraDB From here I'm not sure how to pull the data into the combobox. I do … |
| | Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" … |
 | sir can you help us or give us an idea in our System Tutorial (Thesis) in our subjet Software Enginieering, our professor required us to make a system that is not yet existed, Examples Grading system, Inventory System, Using VIsual basic 10 with the connection of data base, . sir … |
| | Hello. Allow me to apologize in advance regarding any abnormal phrasing. There is a certain table, hereby dubbed IPT, containing 4 keys and a variety of values. I wish to select several values spread throughout IPT, anchored via the first three keys and a varying fourth. Currently, this is achieved … |
 | Hello, I have to install Oracle Developer 2000 R2.1 on a Windows 8.1 (x64) machine to run an application developed by a third party developer, but my installation keeps on crashing. Tried running in Windows XP SP3 compatibility mode still same result. The error is as follows: "D2KQT10.ins(54): 'Statement' expected … |
| | sorry for this silly question, i would like to learn ORACLE but i dont know from where should i start and what toopics should be covered? i know sql.so i like to start pl/sql. please suggest me what topics should i cover? |
The End.