Latest Answer: drop user ...
Latest Answer: ALTER SYSTEM SET SHARED_POOL_SIZE=..... ...
I developed like below.Any experts query ....please send.selecttable_name,constraint_namefrom user_cons_columns where column_name=(select a.COLUMN_NAME from user_cons_columns a,user_constraints bwhere
Latest Answer: SELECT uc.CONSTRAINT_NAME, ut.TABLE_NAME, ucc.COLUMN_NAMEFROM USER_CONS_COLUMNS ucc, USER_CONSTRAINTS uc , USER_TABLES utWHERE uc.table_name = ut.TABLE_NAME AND uc.CONSTRAINT_NAME =ucc.CONSTRAINT_NAME ...
Is there any way to import the excel data in to oracle database without using the SQL loader, please let me know.
Latest Answer: Well,if you have less data ,you can just copy the data; for exampleselect * from table for update then open the lock, then copy the data from excel to the database; ...
SQL is a comprehensive language. All tasks associated with a database application can be accomplished using SQL. Do you agree or disagree with this statement? Substantiate your answer
Latest Answer: Using SQLERRM, and SQLCODE functions we can find the error message related to the SQL Error code. ...
Select round(13.19,1) from dual will return 13.2Select round(13.19,-1) from dual ....what will be the output.....IN ORACLE
Latest Answer: SELECT ROUND(13.19,-1) FROM DUAL;RETURN result IS 10; WHEN you pass second argument AS "-1" , rounding takes place BEFORE the DECIMAL point.That IS the reason IN the above example it rounds 13 TO 10. IF you USE 15 OR more than 15 it will ...
Latest Answer: In table level constraints, a single constraint can be created on more than one columns but it is not possible in case of column level constraints.A table level column can be created after the creation of the table without altering the column definitions. ...
Latest Answer: if group of columns or column which uniquely identifies each and every record of a table is called candidate key. Candidate key other than primary key is called alternate key. ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
