how to begin learning oracle forms and reports ?
i have complete sql and plsql course and , i want to begin learn oracle forms and reports so i want to know how to begin and what i need (books , websites ..) thanks ...
oracle
Oracle SQL - How to Retrieve highest 5 values of a column
How do you write a query where only a select number of rows are returned with either the highest or lowest column value. i.e. A report with the 5 highest salaried employees? ...
Oracle certification
Hi, I am a 3 year experienced software developer with fairly good TSQL knowledge in SQL Server. I am looking for expanding skill to Oracle also. What all things I should learn to say confidently thaty 'I know Oracle'? Any free online certification available? Pease share your thoughts.. Thanks Lijo ...
Connect to oracle server in NSIS
Like we can connect to SQL Server using MSSQL_OLEDB plugin, how can we connect to Oracle server in NSIS? Also what if Oracle server is on some remote machine? ...
Table compression requirements in Oracle
Hi I have a Tablespace with total Size 600 MB(this is my test machine).and free space of 110 MB. i was trying to compress a table thats size is 120 MB. When execute the commands; alter table DOWNLOADSESSIONLOG move compress; im getting error saying (Error): ORA-01659: unable to allocate MINEXTENTS beyond 16 in tablespace WAP . I was se...
Change Primary Key Oracle
I have a table in Oracle which has following Schema City_ID Name State Country BuildTime Time When i declared the table my primary key was both City_ID and the BuildTime but now i want to change the primary key to three columns: City_ID BuildTime and Time Can you guide me as to how to change the primary Key ...
How build a scalable (relational) database for Petabytes+ of data?
More a general brainstorming question: what is the state-of-the-art in designing a (relational) database which scales to very large amounts of data? And given today's technology trends, how do we expect to design them in 5-10 years? By scalabiliy, I mean in particualar the ability to increase capacity with linear cost by adding hardware...
ODP.Net 9.2 and 11 on the same machine, using VS2008
Hello, I'm currently developping to application, one using the ODP.Net 9.2 and the other one should use the ODP.Net 11. I'm using the Server Explorer from VS2008 to add a new connection but failed each time with the error "ORA-12154: TNS: Could not resolve the connect identifier specified". I'm not able to debug which ODP VS2008 is usin...
Why is selecting specified columns, and all, wrong in Oracle SQL?
Say I have a select statement that goes.. select * from animals That gives a a query result of all the columns in the table. Now, if the 42nd column of the table animals is is_parent, and I want to return that in my results, just after gender, so I can see it more easily. But I also want all the other columns. select is_parent, * fr...
In Oracle what is the difference between open-for and opening a cursor with parameters?
What is the difference between these two pieces of code? TYPE t_my_cursor IS REF CURSOR; v_my_cursor t_my_cursor; OPEN v_my_cursor FOR SELECT SomeTableID FROM MYSCHEMA.SOMETABLE WHERE SomeTableField = p_parameter; And... CURSOR v_my_cur(p_parameter VARCHAR2) IS SELECT SomeTableID FROM MYSCHEMA.SOMETABLE WHERE SomeT...
Why can't I do a "with x as (...)" with ADODB and Oracle?
Hello I fail to execute an SQL query with a with clause via ADODB and Oracle. That is, the following snippet works: Dim cn As ADODB.connection Set cn = .... Dim rs As ADODB.recordSet Set rs = New ADODB.Recordset rs.Open "select 'foo' x from dual", cn Do While Not rs.eof ... rs.MoveNext Loop However, the following doesn't w...
ORA-22835 using JPA (Buffer too small)
I am trying to persist an Entity with a @Lob annotated String field. The content of that fiels if bigger than the 40k buffer size limit. The first problem I had was related to the setString method used internally by the JPA implementation (Hibernate in my case) and the Oracle JDBC Driver. This problem was solved adding <property n...
What could be the possible cause of this exception?
I get the following error when I run a java program: Exception in thread "main" java.lang.UnsatisfiedLinkError: t2cPingDatabase at oracle.jdbc.driver.T2CConnection.t2cPingDatabase(Native Method) at oracle.jdbc.driver.T2CConnection.doPingDatabase(T2CConnection.java:503) at oracle.jdbc.driver.PhysicalConnection.pin...
What is row locking and chaining in Oracle?
What is row locking and chaining in Oracle and what is its impact on performance? ...
SQL recursive query on self refrencing table (Oracle)
Hello Lets assume I have this sample data: | Name | ID | PARENT_ID | ----------------------------- | a1 | 1 | null | | b2 | 2 | null | | c3 | 3 | null | | a1.d4 | 4 | 1 | | a1.e5 | 5 | 1 | | a1.d4.f6 | 6 | 4 | | a1.d4.g7 | 7 | 4 | | a1.e5.h8 | 8 | 5 ...
Dynamic Update Query in Oracle
I'm trying to create a standard UPDATE query for a table. However, if certain criteria are met, some columns should be included/excluded from the UPDATE statement. For example: UPDATE TBL_PROJECT SET REVISION_COUNT = V_REVISION_COUNT ,PRIMARY_BRANCH = IN_PRIMARY_BRANCH ,PROJECT_STATUS = IN_PROJECT_STATUS ... WHERE ...
PLSQL - How to retrieve values into a collection given an array of values?
I have a procedure that accepts an array of folder IDs and needs to return a list of document IDs. Folders are associated to documents in a one-to-many relationship--there are many documents for each folder. Specifically, there is a documents table which has a parent_folderid fk to the folders table. This is what I have: PROCEDURE get_...
test sql queries of oracle online
Hello, is there any online tool available to test sql queries for oracle online. I need it because I dont have oracle right now but to test sql is critical. ...
java.util.Timestamp.after() wrong when comparing milliseconds?
I am pulling dates out of an Oracle database. They are set on a java.util.Date field and they are in reality java.sql.Timestamp instances (which is a subclass of Java.util.Date). If I compare two of these timestamps from two different database records by calling after() on the first date and compare it to the second, I get the wrong answ...
Oracle LEADING hint -- why is this required?
Suddenly (but unfortunately I don't know when "suddenly" was; I know it ran fine at some point in the past) one of my queries started taking 7+ seconds instead of milliseconds to execute. I have 1 local table and 3 tables being accessed via a DB link. The 3 remote tables are joined together, and one of them is joined with my local tabl...