Latest Answer: SQL plus doesn't have engine with that. So the SQL commands will be executed at the database only. ...
Latest Answer: select employee_name from employees where substr(first_name,-1)='s' ...
Latest Answer: SELECT 'GRANT ' ||privilege ||' ON '||table_schema||'.'||table_name ||' TO '||USER ||' ;' FROM ALL_TAB_PRIVSWHERE grantee ='TILITS' -- user name that has already access ...
Latest Answer: --This code will insert a image into database create or replace PROCEDURE INSERT_BLOB(filE_namE IN VARCHAR2,dir_name varchar2)IStmp number;f_lob bfile;b_lob blob;BEGINdbms_output.put_line('INSERT BLOB ...
Latest Answer: Theta Joins Theta joins are joins that use any of the comparison operators: Greater than, denoted by > Greater than or equal to, denoted by >= Less than, denoted by < Less than or equal to, denoted by
How many types of data base triggers are there, what is cascading how many types of queries are there
Latest Answer: use savepoint after each DML statement. If using procedure/function then do not give commit in them. commit in proc/function will erase your savepoints. ...
Latest Answer: There are four Type of joins in oracle1. Inner join2.cartision join3.self join4. outer join ...
How can we order the column of day (mon to sun)such that monday comes first then tues and so no.Suppose we have retrieved day out of hiredate column
Latest Answer: Commit to like making all the changes permanently in the Server...But in case of GO statement which is available In SQL Server(TSQL), the set of steps before the GO statement is complied at once and sent to server...I mean from the beginning of the script ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
