I want to get the information about when a table is queried in oracle. Is there any log in oracle which shows the queries. I was looking around v$sq开发者_Go百科larea and v$sqltext but, the system adm
Does Oracle 10g database have GEO-Spacial search functionality out of the b开发者_如何学Cox, or is it something that needs to be install as an addition.
The following PL/SQL block works: DECLARE r TABLE1%ROWTYPE; BEGIN 开发者_开发百科SELECT * INTO r FROM TABLE1 SAMPLE(1) WHERE ROWNUM = 1;
I have an index: CREATE INDEX BLAH ON EMPLOYEE(SUBSTR(TO_CHAR(EMPSHIRTNO), 1, 4)); and an SQL STATEMENT:
This is one of those situations where you get an unhelpful error message back from Oracle. My situation is as follows: I\'m dynamically creating a view in PL/SQL. I build a string and use EXECUTE IM
Please consider this table: firstName |lastName | hobby ----------------------------- Mike|Stone| music Sarah|James| cooking
I have ColumnA in table. The data of each row is single character between A & H. I want my select query to return 1 for \'A\', 2 for B .... 8 for H.
I used the following (check for errors in loop and if 开发者_运维百科they are exists I insert they into the table):
I have a VARCHAR2 value in the format \'14-SEP-11 12.33.48.537150 AM\' and I need to convert this to a TIMESTAMP as is. That is like,
The me开发者_Python百科talink article [ID377037.1] I have states that the issue applies to Oracle 10.2.0.1 to 10.2.0.4 but there is no resolution to the issue. Does anyone know if this issue is fixed
加载中,请稍侯......