I found out that Oracle Database 10g and 11g treat the following PL/SQL block differently (I am using scott schema for convenience):
I\'ve got an Oracle 10g database with a table with a structure and content very similar to the following:
if not (i_ReLaunch = 1 and (dt_enddate is not null)) Howthis epression will be evaluated in Oracle 10g
Is it a dangerous practice to have tables with large number of columns. Is there possibi开发者_C百科lity of some performance or memory issues? My DB is Oracle 10g. It is easier to add columns for exis
I\'m using this code: SELECT MACH_NO, COUNT(MACH_NO) AS TOTAL_REPORTS FROM MAINTENANCE_LOG GROUP BY MACH_NO;
I\'m trying to do this again an Oracle 10 database: cursor = connection.cursor() lOutput = cursor.var(cx_Oracle.STRING)
I have a global temporary table (GTT) defined in a creation script using the option to delete rows on commit. I wanted to be able to have different users see their own data in the GTT and not the data
I have an sql statement that currently is just returning all the end parent rows for a list of child rows:
I\'m trying to write a table trigger which queries another table that is outside the schema where the trigger will reside.Is this possible?It seems like I have no problem querying tables in my schema
Our customer wants us to use a connectionstring with username = "external" and add schemaName "original" infront of our queries like:
加载中,请稍侯......