- Selling base USA & EU for 1 hand. Format : Track2 + Name
- Oracle for online Application
- Auto increment in Oracle
- SQL Reuse with Parameters
- Use Analytical Functions to calculate years of experience.
- Using Stored Outlines
- Which number fall within a range?
- Select entire rows with most recent date only. No duplicates
- regaring IOTs
- LOB updates
- In a single row I want to display the table name and number of rows in it.
- automatic unlocking
- larg text fields
- Allow DDL for some developers and not others
- Cleanup of Buffer cache
- Capturing Fast Continuous Data Flow
- MV's question
- Semantic Web
- partitioned index
- Cost /Rule based Optimizer behaviour
- extracting data to a flat file.
- constraint state
- database sessions -- seeing their sql.
- Database backup and recovery plan.
- Yet another ASCII dump issue
- date fomat containing timezone data
- Reverse Key
- Fetch across commit
- SGA size
- Standby Database/Alert Log
- Column order in Index
- dropping and adding partitions periodically
- Does a Group By gaurantee that output data is sorted?
- partitioning
- How to use SQL*PLUS to generate a variable length file delimited by comma?
- How you go about it?
- Date datatype
- dbms_lock.sleep procedure
- Convert a String to DATE only if the format does fit exactly to the given format mask
- soft parse
- mutating table
- Logminer
- Descriptive info for schemas?
- Data Archival and Retrieval
- Insert in NESTED TABLE
- How to identify uncommitted rows
- How to achive desired output?
- Use of Triggers for auditing changes
- Search on a table with optional parameters
- Column-organized tables?
- Merge vs Update
- parallel pipelined function
- Using Min/Max in where conditions
- BUG in the SQL compilation
- Start oracle 10g 10.1.3 on 'Redhat Enterprise Linux WS 4'.
- Regarding DBMS_STATS
- distributed query and undo/redo
- recovery after losing UNDO tablespace
- RMAN backups
- Primary key index in Partitioning !
- How can I DO PATTERN MATCHING from within PL-SQL using REGULAR Expression
- Converting Longs to LOBS
- Can there be an infinite DUAL?
- Constraints
- Question on Using Ref Cursor
- Real Application Clusters
- User defined aggregates and intervals
- Multiblock tablespaces benefits?
- Query to return a Substring
- Table Reorg
- Save Undo
- Hints When to use
- Java for PL/SQL developers
- Oracle Database Administrators
- Proxy Users!!!!!!!!!!!!
- storing passwords in the database.
- Update Statement and Exception Handling
- Analytics question
- Sequences or GUIDs
- What to do in case Performance of a production database goes slow
- Create stats without histograms?
- Log buffer size tuning
- Performance Tuning
- Dbms_stats
- TNS listener, ORA-12500, ORA-00955
- very long wait for a single query
- Invalid Objects
- Deleting rows in 10g
- Self-Join
- DBMS_STATS and MONITORING
- Creating Materialized Views
- very eargent
- DECODE or NVL
- Import question : COMMIT=Y : How big is the array insert ?
- execute shell script from stored procedure
- 32 bit or 64 bit
- How can I do a variable "in list"
- Blocks - 2 or 4 or 8k?
- About low hwm
- About latch wait time
- Unique database vs multi databases (schemas) for multi countries application
- ORA-12560: TNS:protocol adapter error
- exact time when an extent is allocated
- Calculating the time between two events
- Strange Trigger Behaviour
- Results is not the same when run from a procedure
- Big Table
- Stubborn Sys or Wrong ME
- Stragg
- questions on views
- SGA size
- RAID configuration
- correlated update
- clustering_factor
- Automating purge statspack data
- Issues with rebuilding indexes
- Copying datafiles between different operating systems
- How do I clear the memory consumed by temporary lobs ?
- conn / as sysdba
- Cursor
- flashback using timestamp
- session_cached_cursor values
- editing dmp file
- Dbms_job
- stopping listener having a password
- How to Update millions or records in a table
- EXECUTE IMMEDIATE - don`t know how many input variables
- LOB compression
- shared_pool_size
- OEM of 10G
- retrieving client hostname via application server
- Pl/SQL ETL
- Are histograms worthless?
- Pivot Query
- Evolute from a Developer to DBA
- Questions on Locking
- realtime filtering the list
- How to pass an array to a stored procedure
- practice backup recovery and have a question
- SEQUENCE Cache
- enqueue processes and rescources
- Cutting the end off a string
- Partitioning question
- Mechanism to perform the product of a single column in a multirow table
- how to set default path to execute script in windows application sql*plus
- CASE Statement
- significant limitations when using the update ... set row clause
- Utl_smtp
- alert log message
- Frequent insert-delete OLTP table with CLOB
- In between adding of new partition
- pseudocolumn - ROWID
- Retrieve table hierarchy using foreign key constraint
- Is Oracle Logminer still able to use If I use java as a development tool
- Index Question
- What After 10g?
- difference between count(1) and count(*)
- escape semicolon ?
- SQL using PLSQL functions
- Query Multiple Databases...Philisophical ?
- Rewrtite using DImensions vs using Aggregate Rollup
- SQL*Net message from client
- How to enforce conditional unique on multiple columns
- Relational VS Object Oriented Database Design
- DB time
- DBMS_SCHEDULER: Emailing after inserting into database tables
- Index Organized Tables.
- Oracle Security Options
- How much data per second can be delivered by my DB server ?
- consistent gets -- Very puzzling
- controlfile
- database links
- Counting the number of business days between 2 dates.
- CPU utilization
- SQL*Loader, Resource Manager, Locally Manager TS's
- Insert the record for the every saturday and sunday as date from today to 31/01/2008
- column concatenation at run time
- Shared Memory Problem (unable to allocate shared memory ...)
- ASM on Network Storage devices
- Auditing -- where are the records visible and how to find out whats enabled.
- External Table - Bad File
- Trigger on a table Fire at commit.
- archive partition
- J00X processes
- log file synch waits
- DB_FILE_MULTI_BLOCK_READ_COUNT According with SAME Metodology
- Freelists and Initrans
- sqlplus prompt and logon trigger
- Performance Investigation Approach when using STATSPACK
- Differences Between Processes, Sessions And Connections
- basic decision on sql query performance
- Refresh on Materialized View
- Dropping objects or user
- Database Design
- Displaying PDF files stored in the Database
- SAN and Oracle databases
- dump files created by internal error
- After logon Trigger
- Synonyms vs Alter session current_schema
- Data Guard
- Transparent Data encryption in 10g release 2
- getting rows N through M of a result set
- partition pruning
- Listener Question
- Row source operation is different from explain plan
- Second Edition of "Expert One on One Oracle"
- XML and Oracle Objects
- External tables
- date query
- How does the profile parameter 'idle_time' work?
- snapshot too old error
- Is there a self-reference to my PL/SQL program's name?
- Deadlock issue in using 'APPEND' hint in multithreaded jobs running in parallel
- v$ table access from stored procedures
- CTAS vs Delete - runtime
- Monitoring Oracle Databases
- Network Configuration Parameters
- What don't you like about Oracle?
- Resumable exports
- How to compare two tables of data????
- system statistics
- Backup and Recovery
- Statspack report
- Format the Number for display
- Parallel Query
- Set autotrace on
- SQL Tuning
- Date Arithmetic: Remainder vs. Modulus
- IOT and create table as
- Data Encryption
- Ref Cursors
- Soft parsing of a procedure call (begin ... end;)
- See empty extents in a datafile
- Passing the SQL%BULK_EXCEPTIONS Collection to a Procedure
- New Features in 11g
- database design
- Oracle RAC load balancing advisory services
- Automatic Storage Managemen (ASM) and RAID, etc.
- Analytic Functions
- sqlloader versus external table.
- Audit method
- String Concatenation
- Bitmap indexes and Group BY
- lookups
- function based indexes
- adding day to dates but not counting sat and sun
- How to refresh Materialized View when the changes are made in the B tables !
- Issue Frequent COMMIT Statements
- The issue of bind variables only arises( in p/sql) when we are doing dynamic sql and
- intermedia text search
