View Full Version : Oracle
- get system variable inside sqlplus
- NVL on comma delimited db field
- Retrieve SQL from unix user processes / connections
- database for shop
- Query
- Partitions in 9i
- who prefetch datafile data to buffer cache?
- Guidence on Enterprise Manager
- Oracle Developer
- Trying to add constraints
- Role of disable_on_error in Streams Apply
- Not All Variables Bound
- how to check table space in oracle
- Tracking occurance of columns in DB Tables
- Strange dbms_scheduler behaior: job won't run under certain conditions (listed)
- display output of dynamic sql
- Why "connect SYS/xxx AS SYSDBA" always TRUE ?
- sending email and sms
- Sql output
- Displaying results from my procedure
- Using a parameter table
- Dna
- Oracle lag issue with a wan connection
- load data from CSV files to oracle schema
- SQL Operators
- oracle spool file
- DBCA import issues and a hard server crash
- SQL commands for Oracle just like Access?
- Installing Connection Manager
- Error in MERGE Statament
- dbms_lob.substr returns varchar2?????
- Sql using max or top
- Error, and the line number it occurred on
- Top 3 reasosn for pl\sql and top 3 reasons for JDBC
- oracle
- Namesctl starting error Oracle 7.3.4 on Windows NT4
- Virtual memory paging
- Oracle Encoding Issue
- password management 11g
- Unable to determine upgrade is successful and database cannot start up properly
- dbconsole failing to start
- how to update a record !!
- remote access
- remote access
- Shrink Oracle Tablespace
- Unable to make connection, ora-01033: oracle initialization or shutdown in progress.
- Import Command
- sample questions
- Selecting the Column Name from on table and using it as a value in another column
- conversion problem
- Iterating over dates in For Loop
- conversion
- IMP-00010 not a valid export file, header failed verification
- New Server Configuration
- Using Decode to return multiple strings
- inserting into parent from child
- biken
- compare two number,varchar column in two table
- Is RHEL 5 Certified for 10gR2 64-bit
- data not visible in table
- How to Allocate a Saperate Tablespace for Stored Procedure and Views
- Dayofmonth
- New to Oracle...please help!
- Cursor populate data
- help with SELECT command on one table
- Merge deletes w/o updates
- Non-RAC to RAC migration strategy?
- UTL_SMTP vs UTL_MAIL?
- content of default tablespace...9i
- Daily auto Email a report
- Collections Vs GTTs for performance tuning
- TNS-12518 TNS:listener could not hand off client connection
- ORACLE 9i Replication
- Drop/create sequence from a trigger
- rman instance crash and disappear
- ORA-00910, No message file for product=RDBMS
- restore the view after update/replace the view
- Convert SQL SERVER DATETIME into ORACLE TIMESTAMP
- identifying unused datafiles....
- Need help to design - storing data from a delimeter separated file
- compare TWO CLOB cloumn in two table
- compare two table
- null
- backup and restore after insert&update table,create&replace VIEW in oracle 9i
- backup and restore the view by SQL command
- PGA memory utilization
- delete from trigger
- Database Suggesstion for a large portal
- Oracle Memory always 99%
- Oracle
- oracle instance performance
- Migration From Access to Oracle
- Please help with this Query
- union all and order by .........9i
- creating a procedure for a package (dbms_output.put_line)
- CDC on a Physical Standby
- finding the percentage difference
- register forms in apps11i
- oracle 7.2.3
- update on remote database
- ORA-01849 Hour must be between 1 and 12 error
- SqlLoader Problem with column name
- Login with encrypted password versus plaintext
- creating a new user in oracle 9i
- Read Locks
- Data Archiving ...9i
- ORACLE 9i Replication
- Something i cant unserstand about null
- Insert Statment using max value for Start
- adding constraints...9i
- invalid identifier! Plz help!
- understanding another query
- How much O/S disk space left for a tablespace?
- Fast search
- Subquery
- RMAN-04006: error from auxiliary database: ORA-28547: connection to server failed, pr
- dbconsole
- what is the connection string to connection to oracle in informatica
- Temp TS growing rapidly
- Oracle 9i replication
- how to view results of function containing DML?
- environment variables
- understanding part of a proc....Oracle 9i
- Help: Query results to "No more data to read from socket"
- error when run the oracle application in server
- Group by with decode
- use of database in ERP s/w
- Calling a procedure from a trigger
- No IMP/EXP command in 'help Index'
- Trigger Copy and delete
- proc running time...
- unnessary message displayed
- How to execute STP with Named type table as parameter through ODBC calls
- Selecting Database for a Large Health Care Appliccation
- Clob in insert statement
- Outer join issue
- loading a HPUX Itanium db dump into Windows
- plz help me how to find that who pay the fee for this month
- Domains in Data Modeler
- Error : cannot read/modify an object after modifying it in parallel
- need help with group by function.
- Code VARCHAR2 with PROGRESSIVE
- Stored Procedure Error
- update colum after given amount of time
- Cannot Login in Oracle 10G
- Time A - Time B
- Moving Indexes - ???
- Self join
- sending email
- How to avoid the error - "ORA-00001: unique constraint violated"
- Phy Standby Database Log sequence not matching with Production
- blank fields....
- Query Help
- I need some serious help with delete and update triggers
- DateDiff trigger
- Making a column.....
- Changing DB 11g IP address and Name
- import only tables, not packages
- ORA-00904:invalid identifier
- 01747. 00000 - "invalid user.table.column, table.column, or column
- Plz Help in writing this query.
- Creating a new database instance on Solaris
- plsql regexp and for loop
- temporary tablespace in oracle8.05
- HELP on How Create a STORED PROCEDURE
- Array of unlimited values as input to stored procedure in oracle
- Issue in logging into sqlplus - Oracle 11g Database
- O Joy
- Oracle export just constraints, sequence
- oracle
- Merge statement with Nested tables
- TNS:listener does not currently know of service requested in connect descriptor
- Ora 2296 (cannot enable Agresso.) null values found
- Users are not receiving Oracle Workflow e-mail notifications
- extract datas from .DMP file
- visibility of textbox based on radiobutton selection
- need tutorial on how delphi insert data to oracle 9i?
- How to get a list of all users and their roles?
- named pipe to sqlldr reducing block size
- other option for refcursors
- Tables with large number of rows
- reg: DBMS_output.put_line...
- Error during cloning(dbTechStack) of 64 to 32 bit Oracle
- how to validate SQL without executing ?
- DB link
- Accesing a Oracle database (UNIX) from Z/OS (Cobol-DB2)
- How to upload the data from this text file into my db tables.
- pl/sql trigger...help needed
- Problem: Partition pruning a fact table with partitioned time dimension.
- sql plus do not show errors!
- Foreign Keys
- Importing database structure
- Advanced Replication versus Streams
- Oracle Stored procedure error
- Some Explanation about Where Clause and Having Clause
- how to fill dataset with oracle ref cursor in c# using factory classes
- Retrieve chinese caracters from table
- enterprise manager configuration
- server parameter file
- Column headers
- problem in set block property
- Error in UPDATE
- Bind Mismatch Issue
- Profile Limits
- Create temporary table for processing
- Insert into table2 from table1, table3 where
- database error
- Error in UPDATE statement
- return multiple variables from function via DBLINK
- Export BLOB data to file
- ora-01033
- reduce the size of table/file
- table structure
- Moving Row Data to Columns
- INSERT statement
- MAX average points by year and sex
- New server CONSULTING
- copy the data from one schema to another with in a single database
- 2nd highest record
- AUDIT_FILE_DEST parameter
- Sql Loader: How to terminate loading when i reached a statement.
- record serial number in oracle report
- report data sorting
- is 'bool' in oracle ?
- RMAN backup
- Duplicate database with RMAN
- Count dates
- batch file for oracle for a specific schema
- Optimizing full-table-scan query
- ORA-08103 : Object no longer exist
- proble in foreign key
- Unknown session
- connecting to ms access database in oracle slq developer
- Executing stored procedure from SQl developer
- oracle 11g apply side aborting
- understanding a query...
- FK column is automatic not null ?
- formatting a query....
- searching for a specific column in a shema
- Help with Rollup
- How do I create a Data Dictionary using Oracle Designer?
- oracle and unix
- Assertion query
- Status of indexes after truncating the partitions
- How to do bulk insert in ProC?
- Update a table with values assigned from another table
- Stored Procedure
- displaying Dynamic week columnwise
- duplicate ROW_IDs
- Oracle 9i, 10g Backup and Recovery
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.