Keep it Simple and Smart
This is very quick way to generate the Insert Statement for all of the data in your table. Let us take an example; we have a table as shown below… Right click on the Result Grid and go to Option à Export Dataset Select the Export Format as “Insert Statement”
» Read moreIf you want to update your select result in toad, just add the ROWID is your select statement. Once you select the records with ROWID then you can edit/update your result grid. You can also see the Green indicator as shown in the below screenshot that means your records are
» Read moreWith UTL_INADDR The UTL_INADDR package provides a PL/SQL procedure to support internet addressing. It provides an API to retrieve host names and IP addresses of local and remote hosts. Example select UTL_INADDR.GET_HOST_NAME Host_Name, UTL_INADDR.GET_HOST_ADDRESS IP_Address from dual ; With SYS_CONTEXT SYS_CONTEXT returns the value of parameter associated with the context
» Read moreMemory allocation is static for char data type variables but in case of varchar memory allocation is dynamic. This is the basic difference between char and varchar. Example create table test1 ( name1 char(10), name2 varchar(10) ); Insert into test1 values ('Varinder','Varinder'); select * from test1; I hope this will
» Read moreError: ORA-01007: variable not in select list Cause: A reference was made to a variable not listed in the SELECT clause. In OCI, this can occur if the number passed for the position parameter is less than one or greater than the number of variables in the SELECT clause in
» Read moreT-SQL TSQL is a proprietary procedural language used by Microsoft in SQL Server. PL-SQL PL/SQL is a proprietary procedural language used by Oracle Microsoft’s T-SQL is similar to Oracle’s PL-SQL to some extent, sharing with some basic difference as below Difference in data type, There are many different data type.
» Read moreDECODE(value, search_value, result, default_value) compares value with search_value. If the values are equal, DECODE() returns result, otherwise default_value is returned. DECODE() allows you to perform if-then-else logic in SQL without having to use PL/SQL. Example 1 Example 2 Refer for more detail http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions040.htm
» Read moreHow can we insert the value with QUOTE in the table? In the insert statement use the two QUOTES to insert the single QUOTE as shown in the example. Example: — CREATE A TEMP TABLE CREATE TABLE TEMP ( TEMP_COL VARCHAR2(255) ); — INSERT VALUE WITH QUOTE INSERT INTO TEMP
» Read moreAbout this Book Oracle 2 Day DBA is a database administration quick start guide that teaches you how to perform common day-to-day database administrative tasks. The goal of this book is to give you adequate information to help you understand the concepts behind the Oracle Database. It teaches you how
» Read moreFor all intents and purposes you can consider a user to be a schema and a schema to be a user. A schema is the set of objects (tables, views, indexes, etc) that belongs to an user account. It is often used as another way to refer to an Oracle
» Read moreVarinder Sandhu is using WP-Gravatar