Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
TCS,
7 11580Define the terms primary key foreign key and also the difference between primary and the unique key
2 11201i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
2 4910i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
1 4446ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
4 7903How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
3 7597SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
TCS,
6 14322
Why do you use stored procedures and state some of its disadvantages?
What is da in database?
can u give guidance abt packages of plsql
What are the Types of repositories in ODI?
Why should I use oracle database?
What are a cluster and non-cluster index?
How to create id with auto_increment on oracle?
How to export data to a csv file?
How to drop an index?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
Explain the use of rows option in exp command.
What language does oracle use?
What is the difference between post-database commit and post-form commit?
What is secure property?